SAP Knowledge Base Article - Preview

2489011 - SQL error 12205 and/or 12207 reportted on table NRIV - SAP ASE for Business Suite

Symptom

  • SAP applications running slow during RFC processing, ICM background jobs (ie while creating or copying users in SU01).
  • SQL errors SQL12205 and/or SQL12207 are reported from ST22 on the table NRIV, ie:

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. "

  • From SM50 - work processes stall - DIRECT READ on NRIV table can be seen.

Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

NRIV, ARFCSSTATE, RFC, locks, waits, SQL12205, SQL12207, 818023, use_gwstart , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , BC-SRV-NUM , Number Range Management , 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.