Hash look up error

sunil2020 · Post by **sunil2020** » 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!

chulett · Post by **chulett** » 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.

sunil2020 · Post by **sunil2020** » 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.

ArndW · Post by **ArndW** » 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.

ray.wurlod · Post by **ray.wurlod** » 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?