DSXchange

Hi All,

I got stuck when resetting the value in SDKSequences routine.

I used the below statement in UV environment.
UPDATE SDKSequences USING DICT VOC SET F1='87228' WHERE @ID='<sequence name>';

1. The execution takes too long.
2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".

Please help.

Also, I tried to ran the routine manually and the sequence number is incremental in the output of the routine. But the hash file is not updated.

Please help me to understand why hash file is not updated when routine was run manually?

Thanks
Arif

You replied to a thread last touched in 2007. It is better form to create your own thread for a new Problem.

In your case the record is indeed locked by another process. You can use the "PORT.STATUS" command to see which user might be locking the record for your sequence in the SDKSequences file.

... or just wait for someone to come along and split them for you.

Here is the original 11 yeard old topic for reference:

viewtopic.php?t=98814

And since this was your first post, had to guess about your version number. Please feel free to edit your post and correct it if needed.

imsularif wrote: Please help me to understand why hash file is not updated when routine was run manually?

2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".

DataStage will not update the hashed file if it cannot lock the record for update.