8/30/16

Error Selecting from logfile RT_LOGxxx DataStage

DataStage Director Error Message When try to view the log.

Error selecting from log file RT_LOGnn
Command was: SSELECT RT_LOGnn WITH @ID LIKE '1NON' COUNT.SU
Error was: Internal data error. File /RT_LOGnn/':
Computed blink of 0xnnnn does not match expected blink of 0xnnnn! Detected within group starting at address 0xnnnnnn!


Cause:
The error message received indicates that the log file for the job is corrupted.

Solution:

The Log file must be recreated.

We can try 3 things here.

1) Create a Copy of the Job and delete the old job and compile the new job

0r

2) Manully delete and re-create the RT_LOGxx , for this follow below steps.

  1. Log on to DS Administrator and go to the Projects tab. Select the project in question and click on the "Command" button.
  2. Delete the existing damaged log file with the following command, where xxx is the description number as seen in the error:
    Ex : DELETE.FILE DATA RT_LOG52
  3. Create a new log file with the following command, where xxx is the description number as seen in the error:
    CREATE.FILE DATA RT_LOG52 30
Or 

# This will Clear the logfile of the Job

3)   CLEAR.FILE RT_LOG52 ( This will do the trick )

0 comments:

Post a Comment