no job status, DSR_EXECJOB (Action=5) error

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
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

no job status, DSR_EXECJOB (Action=5) error

Post by attu »

Hi DS Gurus,
One of our job sequence failed with this error

Code: Select all

code=-99 [General repository interface 'other error']
Another job in this sequence finished but not showing any status. I tried to clear the status file but no use, it shows it as compiled and when I close the director and re-open it, it does not have any status

Code: Select all

 Error getting job status
Is the RT_Status hashed file corrupted for this job? If yes, is it because of any disk space errors?
We have asked the developers to provide us details about how many jobs were running at that time.

Besides that this message also pops up intermittently when director is opened

Code: Select all

 Error calling DSR_EXECJOB (Action=5) ; check Datastage is set up correctly in project xxxx. 
(Subroutine failed to complete successfully (30107)) 
Did a count on ds jobs and ds jobobjects, it did returned records.
I understand a reindex is needed, but how can we prevent this from happening in future.
Appreciate any suggestions.
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Make sure that there's always enough disk space.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

How are the Runtime hashed files (RT_SC, RT_CONFIG,RT_STATUS) are affected when jobs are running and suddenly we run out of disk space?
Just want to go a little deeper, how is it anticipated?

Thanks
satya99
Participant
Posts: 104
Joined: Thu Nov 30, 2006 1:22 pm

Post by satya99 »

Attu,

Command:

df -k .

Output:

filesystem kbytes used avail capacity mountedon

You need to look at capacity which is in terms of percentage

Good luck
satya
Post Reply