RT_STATUS Error

kollurianu · Post by **kollurianu** » Wed May 11, 2005 8:24 am

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 ,

ArndW · Post by **ArndW** » Wed May 11, 2005 8:30 am

Kollurianu,

what file did you execute a CLEAR.FILE on? What does the log file for SAARTTABLELOAD1 show?

kollurianu · Post by **kollurianu** » Wed May 11, 2005 8:59 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed May 11, 2005 5:21 pm

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.

kollurianu · Post by **kollurianu** » Thu May 12, 2005 8:29 am

Hi Ray ,

thank u very much for ur reply , what does CLEAR.FILE mean , does it mean clearing the status table .

Thank you,
Purna.

ArndW · Post by **ArndW** » Thu May 12, 2005 8:50 am

Purna,

CLEAR.FILE is the DataStage engine equivalent of an SQL TRUNCATE; in general you should never be doing a manual CLEAR.FILE of any DataStage control file.

kollurianu · Post by **kollurianu** » Thu May 12, 2005 9:32 am

thank you very much Arnd. what does clear status file and cleaning up the resourses from director mean?

Thank you,

ArndW · Post by **ArndW** » Thu May 12, 2005 9:40 am

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.

kollurianu · Post by **kollurianu** » Thu May 12, 2005 11:59 am

Thank you very much Arnd , for ur answer.

kollurianu · Post by **kollurianu** » Thu May 12, 2005 12:03 pm

Hi Arnd,

What did you mean by potentially removing datatstage processes , like
what processes would be taken out by issuing clean up resources on the director.

which table is truncated when CLEAR.FILE issued?

Thank you,

ray.wurlod · Post by **ray.wurlod** » Thu May 12, 2005 6:30 pm

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?!!