Page 1 of 1

Jobs Execution Error

Posted: Fri Jan 26, 2007 2:20 am
by fk4u
Hi All
I got following error while executing Ascential DataStage job.

DataStage Job 7 Phantom 9296
Creating file "SDKSequences" as Type 2, Modulo 1, Separation 1.
Creating file "D_SDKSequences" as Type 3, Modulo 1, Separation 2.
Added "@ID", the default record for Retrieve, to "D_SDKSequences".
DataStage Phantom Finished

Note: We are using Red Hat Linux with Oracle 10gR2 for Datastage7.5.2

When i executed job after sometime it successfully executed without any error.
Any idea why this error occured?
Thanks

Posted: Fri Jan 26, 2007 3:01 am
by ArndW
The message you posted are informational and are not error messages. When the DataStage sequences are used for the first time in a project the system will create these files and issue these messages. This only happens the first time, after that the file exists and is not created again, so you won't see this message.

Posted: Fri Jan 26, 2007 5:02 am
by fk4u
Thanks for the sharp response.

Posted: Fri Jan 26, 2007 5:28 am
by ray.wurlod
Its severity is warning not because it's a failure, but because it is an unusual event. It occurs only the first time one of the KeyMgt... routines from the SDK is used. You will never see this message again in this project. SDKSequences is a hashed file in which these routines preserve the next value in each named sequence.