Error calling DSRunJob....code=-99

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Rubu
Premium Member
Premium Member
Posts: 82
Joined: Sun Feb 27, 2005 9:09 pm
Location: Bangalore

Error calling DSRunJob....code=-99

Post by Rubu »

I am getting the following error while running a job.

Actually the job postal_loc_pickdel_20 is triggered from a Job Sequence SEQ_postal_loc_pickdel. While I run the sequence alone it runs fine.

But while I try to trigger the sequenec SEQ_postal_loc_pickdel from another sequence this problem occurs.......

Below is the error message captured from the log of sequence SEQ_postal_loc_pickdel .......


SEQ_postal_loc_pickdel..JobControl (@postal_loc_pickdel_20): Controller problem: Error calling DSRunJob(JOB_postal_loc_pickdel_20), code=-99
[General repository interface 'other error']
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

Faced this problem earlier and we rebuilt indices and it started working fine.

Try building reindex and post it how it goes.

Regards
Saravanan
Rubu
Premium Member
Premium Member
Posts: 82
Joined: Sun Feb 27, 2005 9:09 pm
Location: Bangalore

Post by Rubu »

elavenil wrote:Faced this problem earlier and we rebuilt indices and it started working fine.

Try building reindex and post it how it goes.

Regards
Saravanan
Hi Saravanan

Thanks for your reply. But, I dint quite understand rebuilding of indices. Could you please explain it further.

Are you telling about rebuilding index in datastage or database?

Regards
rub
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

Rebuild index in DataStage.

Log in DS administrator and select the project and click on command. Then type 'DS.REINDEX ALL' that will build indices to the project.

HTWH.

Regards
Saravanan
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Make sure that no-one is logged into the proj when you do that.
Post Reply