DSXchange

Hi Thanks for your response This error was not happening previously. We are seeing this issue from last 2 days I checked the director log The LD_LIBRARY_PATH value is going wrong when the job is failing LD_LIBRARY_PATH=:/lib After restarting the job,the LD_LIBRARY_PATH value goes correct and job run...

Hello Friends We are getting below error in one of our server jobs Could not load drsoci.so There has been no change to environment variable on unix level. Interesting thing is ,this error is coming only in 1 job and it runs well when restarted. This job is reading from a table and loading the Hash ...

Prasoon - DataStage version is 8.5. The job is showing running in Designer and director. When i am restarting it, same thing happens Ray - Actually the job is getting completed, but it is not getting reflected in designer and director until i stop it. This is happening in more than 1 jobs and happen...

Hello Friends I am facing a strange kind of issue. The jobs are showing running (links turn Blue) in the designer. When i am stopping it, it shows completed (link turn Green) This is not happening in all jobs, but in few jobs it is happening so Any idea what is the issue and how can i resolve it Tha...

I am trying to load the data in to the oracle enterprise stage

we have 72 million record to read and doing a insert into oracle

We are gettig below error message
write() failed: Bad file descriptor

Can some one explain how to fix this issue.

Regards
Ulhas

Thanks guys for your response @SURA - Currently We are creating different database sequences for each job. We are planning to switch to file so that round trips to database can be saved. We will be creating the file before the job run,taking the max surrogate key value from the target table and incr...

Thanks Sura for your reply i think my question was not clear in previous post we are creating a key source in the 1st job( which only having the surrogate key generator stage). In this job,we are selecting database sequence in the source Type option of SKG Stage Does using this sequence in other job...

Hello Friends

I am having a query regarding database sequence and State File option of Surrogate Key Generator Stage.

Which option is better performance wise ?

Thanks in advance for your help

Regards
Ulhas

Hello Friends We are getting below error in one of our job Fatal Error: Subprocess appears to be writing binary data as error messages. 131072 binary bytes written to stdout or stderr of a subprocess operator I read posts on this error.I found that this error is mostly encountered with C++ routines....

How abt using a lookup. The reject file of the look-up will give you the required data.

Regards
Ulhas

Thanks guys for your responses.

We have only single project on our datastage server. This project is having this issue.

Yes. Our datastage admin team is working with official support to get a resolution

Thanks for your responses

We can see the changes immediately after making the changes but yes sometimes even after 1 hr change does not appear there. No scheduled task is running which could be impacting this.

We are on DataStage 8.5

Thanks once again

Regards
Ulhas

Hello Friends

We are facing a strange issue of changes not getting saved to Parameter Set.
Sometime we add parameter to parameter set and when we check the parameter set next day,its not there.

Any suggestions ?

Thanks in advance

Regards
Ulhas

Thanks All

I used Index() function and it worked

Regards
Ulhas

Hello Friends I have a requirement where if either of values are present then i need to put a particular value in other column.This can be done using a IF-ELSE statement but the problem here is a lot of values to be checked. For ex If column A IN ('A','B','C'......15 values) then Column B='Value' An...