Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sap table locked / head lock

Dear Experts .

Recently we experience system hangs on our sap clients (teminal) due to database table lock for a long period of time .

Upon looking into the matter I see that there is presumably a select query that blocks other queries

e.g. :

when checking into spid 105 I see that database history has the following query as last run for this session id  :

SELECT [OWTJ].[TimerEtyId],[OWTJ].[Status],[OWTJ].[JobHanConf],[OWTJ].[LastUpdate],[OWTJ].[StartDate],[OWTJ].[StartTime],[OWTJ].[JobHanType],[OWTJ].[Id],[OWTJ].[IsASync] FROM [Dyn2005]..[OWTJ] WHERE [OWTJ].[StartDate] IS NULL  FOR BROWSE

if I kill session 105 (source host is the SAP sql Server )  everything works fine but of course sooner or later same problem occurs.

checking into OWTJ , I don't have any workflow set up for the company

any help is much appreciated.

Thank you ,

Nadav.

Former Member
Not what you were looking for? View more on this topic or Ask a question