Tuesday, September 23, 2008

DataStage Error - [General repository interface 'other error']

Situation
Today,one of my DataStage job that is scheduled to be run everyday suddenly failed and below is the error message that I captured in DataStage Director.

jobControlForEntity..JobControl (@JA_loadETLStreamFromRelationship): Controller problem: Error calling DSRunJob(loadETLStreamFromRelationship), code = -99
[General repository interface 'other error']


When I saw this error message, I really have no clues on why this error message is thrown as the job is running without fail all the time. Anyway, after spending a couple of hours to debug it and I managed to resolve this.


Solutions
  1. Create a new copy of the loadETLStreamFromRelationship by right click on the job and select Create Copy. A new job with the name CopyOfloadETLStreamFromRelationship is created.
  2. Change the job sequence to invoke the new copy of the job which is CopyOfloadETLStreamFromRelationship.
  3. Recompile and re-run the job. Now the job running fine without throwing any errors as stated above.
  4. Delete the previous job loadETLStreamFromRelationship.
  5. Rename the new copy of the job to become loadETLStreamFromRelationship and change back the sequence to invoke the loadETLStreamFromRelationship.

Hope this helps.

No comments: