RT_STATUS Error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
RT_STATUS Error
Batch::BUIDWHTABLOAD.JobControl (fatal error from DSWaitForJob): Job control fatal error (-99)
(DSGetJobInfo) SAARTTABLELOAD1: RT_STATUS Record for wave 10 not found.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1
I cleaned up Datastage using CLEAR.FILE command from administrator before starting the process.
Do you have any idea what is the reason for this error? Please let me know?
Thank you ,
(DSGetJobInfo) SAARTTABLELOAD1: RT_STATUS Record for wave 10 not found.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1
I cleaned up Datastage using CLEAR.FILE command from administrator before starting the process.
Do you have any idea what is the reason for this error? Please let me know?
Thank you ,
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
RT_STATUS Record for wave 10 not found.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1
is the error shown on the log .
CLEAR.FILE on the adminstrator for the whole project , does this help?
OR cleaning up the resources form administrator and clearing the status file would help , if so why ?
What could be the reason for the error.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1
is the error shown on the log .
CLEAR.FILE on the adminstrator for the whole project , does this help?
OR cleaning up the resources form administrator and clearing the status file would help , if so why ?
What could be the reason for the error.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you cleared the status table (RT_STATUSnn), then you have made it very difficult for DataStage to figure out which unique instance (wave number) to run. Recompiling the job ought to fix things.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
The Director's "cleanup resources" starts a program that lets you see and and potentially remove DataStage processes and system locks; the Director's "Clear status file" modifies the status file contents, but it does leave certain control entries in the file and is by no means equivalent to a CLEAR.FILE.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
CLEAR.FILE takes a command line argument indicating the table whose data are to be cleared.
It was you, in your original post, who claimed to have executed a CLEAR.FILE command. If you didn't specify a table name, then the CLEAR.FILE command would have prompted for one. What name did you provide?!!
It was you, in your original post, who claimed to have executed a CLEAR.FILE command. If you didn't specify a table name, then the CLEAR.FILE command would have prompted for one. What name did you provide?!!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.