DSXchange

Folks, I have two jobs being called in a sequencer.When I run the sequencer,Job1 is getting kicked off and finished successfully.But after this Job2 is not getting started and the sequencer is getting aborted with the following message. Controller problem: Error calling DSRunJob (Job1code=-99) [Gene...

Gurus,

Is there any way, I can enable a user to do only a read access to the DS jobs at the project level.It is ok, if he can run the jobs but the user should not be able to modify the existing jobs.


Thanks..............

Hey Kris....
Your are right....there was one job going in parallel which is writing into the hashfile.So I just changed the execution order.Now it is working fine.
Some times,small things will effect everything..................
Thanks...

Yes...I could see those files in that directory.....

Hi folks, Im trying to run an etl job which uses the hashed file as lookups.These files are located in /u02/HashFiles. The jobs runs successfully for one run and some time the job gets aborted becoz of the following error. DSD.UVOpen Unable to open file '/u02/HashFiles/yyyyyy. Could any one help to ...

This is the process to unlock the locked jobs. Processes Locked by Another User and release or check for any issues. For checking and clearing locked processes PC Start DataStage Administration Start/Ascential DataStage/DataStage Administration Login as dsadm Select Project and click Command Enter: ...

Hi Gurus,

Today I have recieved this message and Im not able to figure out, what made to generate this.

DSD.UVOpen "Job Name" is already in your VOC file as a file definition record.
File name =
File not created.
.|

Please mail me u valuable opinion on this message.

Thanks

VG

Folks, I have a job sequencer where it calls jobs (multiple instances of 2 jobs). When the first job is completed, it calls the second one...and this process happens for multiple instances. The situation right now is whenever the first job is completed, it is not calling the second job and is throwi...

Hi , Im trying to insert records into a table1 and trying to delete the records from the source once it inserts into table1, in the same job.I was successful in it.But when I try to run this,it is generating the following message, DSP.Close Error -100 in $DSP.Close. The job doesnt perform the delete...

I just happened to see one of the discussions posted on this issue.It was suggested,"The best way to handle it , is to go to the column tab in the sequential file stage, and set the 'Contains Terminators' of the last row to Yes. " Now I just ran the job with the said modifications and is r...

Hi Fellas, I'm loading data from a oracle table to a sequential file(Job1).The job is running fine with no indication of errors or warnings in the log.I use this sequential file to load to another table(Job2). Now the scenario is like this. When I tried to view the data from the job 1, I get the fol...

Hi Folks, I'm trying to run a master sequencer in a testing environment.The job runs for every 15 min.Whenever I run this job,I'm getting the following message. " (fatal error from DSRunJob): Job control fatal error (-2) (DSRunJob) Job jsCTdataTrnCTtoI is not in a runnable state) " Could a...

Thanks !!!!!

Hi Folks, Thanks to DSxchange for the valuable information that is being posted.Right now I have to test some of the developed jobs.So could you guide any procedure to do testing of the jobs.Btw, What do you mean by unit testing and Data Integration testing of DS jobs.Please throw you u valuable opi...

Hi Gurus, Today I encountered a unusual error while running a job.Both my source and target databases are oracle.I could see the data in TOAD/PL SQL developer.But when I tried to view the data from datastage Oracle plug-in, it throwed the following error. " Oracle datatype not presently support...