SAP Knowledge Base Article - Preview

2489011 - SQL error 12205, 12207 on NRIV - SAP ASE for Business Suite


  • SAP applications running slow during RFC processing, ICM background jobs.
  • SQL errors SQL12205 and/or SQL12207 are encountered on the table, NRIV.
  • SM50 - work processes stall - DIRECT READ on NRIV table
  • ST22 - work processes terminate with a short dump :

Short text

SQL error 12205 when accessing table "NRIV".
What happened?

Error Text of the Database: "[ASE Error SQL12205]Could not acquire a lock within the specified wait period.
SERVER level wait period=1800 seconds, spid=99, lock type=update row, dbid=4, objid=1399476458, pageno=5149625, rowno=51.
Aborting the transaction. "



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


SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0


NRIV, ARFCSSTATE, RFC, locks, waits, SQL12205, SQL12207,recompile, sp_recompile, CR797604 , 797604, , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.