SAP Knowledge Base Article - Preview

2458005 - Dump DBIF_RSQL_INVALID_RSQL/ DBSQL_TOO_MANY_OPEN_CURSOR occurs at program SBAL_DELETE

Symptom

  • You are running SBAL_DELETE report, either in Dialog mode either as a Background Job, in order to remove logs from Application Log tables.
     
  • When running this report, it gets canceled due to DBSQL_TOO_MANY_OPEN_CURSOR dump (it can also be DBIF_RSQL_INVALID_RSQL dump).

    For instance, you can see on JobLog:
      Date             Time          Message text
      dd.mm.yyyy hh:mm:ss   Job started
      dd.mm.yyyy hh:mm:ss   Step 001 started (program SBAL_DELETE, variant <Variant_Name>, user ID <BTC_user>)
      dd.mm.yyyy hh:mm:ss   Database commit done every 100 logs
      dd.mm.yyyy hh:mm:ss   Internal session terminated with a runtime error DBSQL_TOO_MANY_OPEN_CURSOR (see ST22)
      dd.mm.yyyy hh:mm:ss   Job cancelled
     
  • You can find relevant information over ST22 dump:

    Termination occurred in the ABAP program "SBAL_DELETE" - in

     "DELETE_WITH_CURSOR".

    The main program was "SBAL_DELETE ".

 

    In the source code you have the termination point in line 1234

    of the (Include) program "SBAL_DELETE".

    The program "SBAL_DELETE" was started as a background job.

    Job Name....... "XXXXXXX"

    Job Initiator.. "XXXNNN"

    Job Number..... NNNNNN
  • Dump DBSQL_TOO_MANY_OPEN_CURSOR can also happen showing information similar to:

    Termination occurred in the ABAP program "SAPLSTRD" - in

     "TRINT_READ_NAMESPACE_FROM_PAT".

    The main program was "SBAL_DELETE ".

 

    The termination occurred in ABAP program "SBAL_DELETE", in

     "DELETE_AUTHORITY_CHECK". The main program

    was "SBAL_DELETE ".

 


Read more...

Environment

SAP NetWeaver system

Product

SAP NetWeaver all versions

Keywords

DBIF_RSQL_INVALID_RSQL, DBSQL_TOO_MANY_OPEN_CURSOR,
SBAL_DELETE, DELETE_WITH_CURSOR, DELETE_AUTHORITY_CHECK,
SOLMAN_BTC, SOLMAN_BATCH , KBA , BC-SRV-BAL , Basis Application Log , 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.