SAP Knowledge Base Article - Preview

3065132 - SQL Error 1204 The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time - NetWeaver

Symptom

  • The job failed with the errors below:

    C  ERROR: -1 in function ExeNormalModify (execute) [line 19110]
    C  (1204) [HY000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to ch
    C  ExeNormalModify: stmt of NULL_STMTID

  • min/max server memory is not configured correctly


Read more...

Environment

SAP NetWeaver on SQL Server

Product

SAP NetWeaver 7.5

Keywords

1204, SQL Server , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.