SAP Knowledge Base Article - Preview

1933239 - Shortdumps with resource shortage and runtime error SQL12205 DBIF_SETG_SQL_ERROR - SAP ASE for Business Suite

Symptom

  • You see errors with DBIF_SETG_SQL_ERROR, like this example:
      • Category Resource Shortage
        Runtime Errors DBIF_SETG_SQL_ERROR
        Date and Time <timestamp>

        Short text
        SQL error 12205 when accessing a table.

        What happened?
        Database Error Text: "[ASE Error SQL12205]Could not acquire a lock within the
        specified wait period. SERVER level wait period=1800 seconds, spid=.., lock
        type=shared row, dbid=.., objid=..., pageno=..., rowno=.... Aborting
        the transaction. "

  • On the ASE error log you can see the same message reported for Msg 12205.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Netweaver

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

SQL12205, 12205, lock, DBIF_SETG_SQL_ERROR , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

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

Search for additional results

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