3257215 - Query access ARFCSSTATE suffer from lock wait.

Symptom

You notice blocked transactions on system and below 2 statements are mainly affected:

917733c889f0eeec874ca783ea8a3b40
UPDATE "ARFCSSTATE" SET "ARFCSTATE" = ? , "ARFCFNAM" = ? , "ARFCRETURN" = ? , "ARFCUZEIT" = ? , "ARFCDATUM" = ? , "ARFCUSER" = ? , "ARFCRETRYS" = ? , "ARFCTCODE" = ? , "ARFCRHOST" = ? , "ARFCMSG" = ? , "ARFCRESERV" = ? , "HASH" = ? WHERE "ARFCIPID" = ? AND "ARFCPID" = ? AND "ARFCTIME" = ? AND "ARFCTIDCNT" = ? AND "ARFCDEST" = ? AND "ARFCLUWCNT" = ? WITH RANGE_RESTRICTION('CURRENT')

a2c02d737ce003965d65321ab8900124
SELECT * FROM "ARFCSSTATE" "ARFCSSTATE" WHERE "ARFCIPID" = ? AND "ARFCPID" = ? AND "ARFCTIME" = ? AND "ARFCTIDCNT" = ? AND "ARFCDEST" = ? AND "ARFCLUWCNT" = ? FOR UPDATE WITH RANGE_RESTRICTION('CURRENT')

Product

SAP HANA, platform edition all versions

Keywords

a2c02d737ce003965d65321ab8900124; 7b84bc319e14ca9371cf0f500e884582; 917733c889f0eeec874ca783ea8a3b40; db4ff98c75591e934351e781a474d6e1; , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.