Job control fatal error (-4)

[attu]

What could be the reason of this error.

Code: Select all

RetrieveLogInformationMultipleInstance.I.JobControl (fatal error from DSGetLogEntry): Job control fatal error (-4)
(DSGetLogEntry) Event number 141 not found in RT_LOG5276
(DSGetLogEntry) Cannot find log event with id '141'

Any suggestions please?

Thanks

[ArndW]

The most likely reason is that the job log is corrupted. If you don't need the information a "clear log" might fix the error.

[ray.wurlod]

This can be caused if entries have been purged (manually or automatically) between the call to DSGetNewestLogId() or DSGetLogSummary() and the call to DSGetLogEntry().

That is, we're more likely talking data "corruption" here than physical corruption.

[attu]

I dont think the RT_LOG hashed table is corrupted, I executed count RT_log5276 and it did return records.

[ray.wurlod]

So verify whether Event 141 exists or does not exist. If it does not exist, verify that the control records are correct.

[attu]

PLease tell me how to find if event 141 exists ?

And how to verify control records are correct?

[ray.wurlod]

Code: Select all

SELECT * FROM RT_LOG5276 WHERE @ID = 141;

The control records are those that begin with //.

Code: Select all

LIST.ITEM RT_LOG5276 WITH @ID LIKE "//..."

[attu]

>SELECT * FROM RT_LOG5276 WHERE @ID = 141;

0 records listed.

[ArndW]

Attu - now you have proven that the DataStage error was, in fact, correct. But your file inconsistancy still exists. Clearing the log file (from the director, not from the TCL prompt) should do the trick for you.

[ray.wurlod]

Still haven't seen the control records from Attu, particularly //JOB.STARTED.NO.

[attu]

I am still confused how to execute the command to see control records.

Code: Select all

LIST.ITEM RT_LOG5276 WITH @ID LIKE // ???? 

[chulett]

Ray gave you the syntax.

[attu]

I am getting this error after executing from TCL
syntax error. Unexpected sentence without filename. Token was ""

[ArndW]

Where did you start TCL? If from UNIX and the $DSHOME directory, you need to enter the command "LOGTO {YourProjectName}"

[chulett]

Hmm... the syntax doesn't seem to be valid and I get the same error running it for an RT_LOG in my project. And I ain't smart enough to know what the correct syntax should be.