DSXchange

yes

But first you need two versions of the client, right? Not the case here.

Thank you for the last two suggestions. I tried both of them. Resetting to factory default did nothing - same problem as before. The suggestion to copy from the "good" server was worth trying. I created the palette file and transmitted it to the "bad" server. After loading the fi...

This problem occurs on all clients. I have tried to issue the command 'UPDATE.ACCOUNT', but without much success. After message 'Updating your "D_VOC" file (each "*" = 10 records)' it hangs on the first "*". There is no visible progress after several minutes. I finally ...

Thanks Ray. I have ran the command and got the folowing response: 'Warning licencing is in effect. - DSPX package is installed - DSSRV package is installed' Should we worry about the warning? During the installation we've got another warning: command 'uvsh UPDATE.ACCOUNT' returned (9) Could this be ...

I have tried restarting the server several times. Also looked for differences between two installations - nothing jumped at me.
Re-installing is a problem since I have developers working on the server.

Thank you for your responses.
Yes, I am aware of the option to customize my palette. The problem is that I do not see the paraller icons anywhere, so there is nothing to customize from.

We installed EE over DS7.5 on two servers. In the process of configuring and testing the installation, we came across a problem on one of the servers. When connected to server1 we can see the full palette for paraller jobs, but when connectred to server2 we only see the server job palette with same ...

We are also running on Solaris 2.8 with DS7.5.1.
What OCI stage are you using, which Oracle client, and what is the version of your Oracle db?
We are using OCI8, Oracle client is 8.1.7, data base is 8i.

Unfortunately, I'm going to agree with IBM/Ascential. Can you possible try to use the 9i client with an OCI9 stage? The 8i client was problematic, from my own experiences with large volumes over long runtimes. Thank you. Is it this true for the combination of DS7.5 and OCI8? It runs fine with OCI8 ...

Has anybody come across similar problem? Several of our production DataStage jobs abort when extracting data from Oracle tables. There is no meaningful error message. The abort happens once the extracts reaches a certain number of rows (about 15.7 million). It does not matter if the extract is to a ...

Thank you very much for the explanation and advoce. This might be a good long term solution. For now I have to use something 'quick and dirty' to resole production problem. Cheers, Bozenna As supplied the routine works with integers. Most join columns in star schemas use integer as their data type, ...

Thanks so much. This is a very neat idea. Bozenna Hi Bozenna The quick and dirty way to fix your problem is to update your existing key column with -1. SQL : Update table set key_col = key_col * -1 This will set all the records with the same number in negative value. Since you new key is rolled over...

The immediate fix to the issue would be to use the sum of the last Key value and the sequence number. For example say the last value of the key was 9999999999 before the rollback to 1 happen. Then your expression should be KeyMgtGetNextValueConcurrent('<Your sequence Name>')+9999999999. Regards, Su...

I have a job that inserts rows into an Oracle table using an artificial key generated by function KeyMgtGetNextValueConcurrent. Recently the job aborted with 'duplicate key' errors because the key values rolled over to 1. The last value before rolling over was a 10 digit number. What is the best way...