Page 1 of 1

Generating sequence number in server job

Posted: Fri Jul 06, 2007 11:28 am
by samythiru
Hi All,

I am using KeyMgtGetNextValue transform inside transformer for generating sequence number .

I am passing 100 as the initial value for SequenceName KeyMgtGetNextValue(%SequenceName%).

My job aborted with following error .

DataStage Job 1063 Phantom 29104
"SDKSequences" is already in your VOC file as a file definition record.
File name = Attempting to Cleanup after ABORT raised in stage x..Transformer_1
DataStage Phantom Aborting with @ABORT.CODE = 3


If any one know about the error . Please let me know .

Posted: Fri Jul 06, 2007 11:48 am
by ray.wurlod
Either you don't have permission to SDKSequences or someone has deleted one or both of SDKSequences and D_SDKSequences using operating system commands. The key management routine, because it can't open SDKSequences hashed file, attempts to create it.

It is up to you to determine which of the above scenarios obtains, in order that correct remedial action may be recommended. Please post your response.