DSXchange

Posted: **Fri Nov 30, 2012 2:26 am**

The job was executing without any issues. In the second run I killed the job as it was slow.

From there on, I get this below error message. I have no clue what is going on. Please find the error message below

Thanks

Code: Select all

Format..AddressidtbloutHash.Addresstbl: DSD.BCIOpenW call to function SQLExecDirect failed.
DELETE FROM "AddressidtblHash" 
SQLSTATE=40001, DBMS.CODE=950261
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: NOWAIT, Can't lock file, conflict with user "63978". 
SQLSTATE=S1000, DBMS.CODE=1502
[DataStage][SQL Client][UNIVERSE]Unable to continue. Aborting!

Posted: **Fri Nov 30, 2012 6:44 am**

Killed how? Not cleanly as your hashed table is still "busy" and cannot be locked, something the error message clearly notes. Find and kill the remaining process(es) for that job.

Posted: **Fri Nov 30, 2012 7:48 am**

I stopped the Job from the designer. We even tried restarting the DS server, it still didn't help.

Posted: **Fri Nov 30, 2012 8:51 am**

Was the same user number shown after your restart (number 63978)? How one goes forward depends upon that, since it is highly unlikely that the same user/lock scenario will happen twice in a row.

Posted: **Fri Nov 30, 2012 2:42 pm**

Do you see a lock on this table when you invoke Cleanup Resources from the Director client? How about if you issue a LIST.READU command?

DSXchange

Hash look up error

Hash look up error