DSXchange

If the error is "ORA-01722: invalid number" then double check the data getting loaded into the Oracle numeric columns. Maybe Oracle 12c is more strict?

Have you tried adding a reject link off the Oracle Connector stage (if Server jobs allow reject links)?

It depends on your hardware. Talk to your hardware people and find out the throughput.

Those are supported versions. Is the same job writing to Oracle and SQL Server at the same time or are they separate jobs? Are there any other targets in the job design that could be causing a wait? Just wondering what more could be done to narrow it down, such as cutting the job in half or eliminat...

I am not sure how normal those things might be. What are your versions of DataStage, Oracle server, and Oracle client (if using)? What stage type are you using to connect to Oracle? Does the source or target stage have any before-SQL or after-SQL statements? If you select count on the target table w...

I have not heard that before.

I would think you install and configure the newest release, then export each old project and import into each new project.

Here are a few links for you to research.

Migrating from InfoSphere DataStage

That sounds very unusual. Try contacting Support about resolving it.

1. You can copy all the hashed files or FTP them in binary mode. I had to do the same thing years ago and it worked. There was some catch to it, such as pre-creating each one with a script then copying over top of what was created. Have you search this site on that topic? 2. Have you search this site?

I am a little bit confused by what was stated above:

"reading the data using the Schema file"

"using the schema file to load the data"

Yes, those are all tcp/ip port numbers. You can also look in the response.txt file that should have been created on the server when it was installed to find port numbers. Assuming you have a team that manages the network, firewalls, and firewall rules, they should be able to monitor and log network ...

How many users do you have on the system at once?

Here is a technote link (desc: "DataStage: Problems with 40 or more simultaneous users"). I am curious if this is the same error you are getting.

http://www-01.ibm.com/support/docview.w ... wg21318249

One guess is that you are truncating or deleting the target table multiple times in parallel? Another guess is your target table may have a different primary key defined than the source table?

The time format tag is missing the colons that were shown in the expected output example.

Read through this topic and check everything suggested: http://www.dsxchange.com/viewtopic.php?t=152044 To quote PaulVL from the above topic, "Remember that the entry in the log is NOT the time that the event happened. It is the time that the event was written to the log. There is a difference....

There is a security role called "Operations Viewer" related to the Operations Console that PaulVl mentioned. It has been available since at least December 2011. The Console is web-based, so there's not even any need to install the Client!