Jobs Execution Error

fk4u · Post by **fk4u** » Fri Jan 26, 2007 2:20 am

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

ArndW · Post by **ArndW** » Fri Jan 26, 2007 3:01 am

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.

fk4u · Post by **fk4u** » Fri Jan 26, 2007 5:02 am

Thanks for the sharp response.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 26, 2007 5:28 am

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.