SAP Knowledge Base Article - Preview

2537622 - BPC Clear package aborts or does not end and DBSQL_SQL_ERROR runtime error occurs

Symptom

  • When running / executing an SAP Business Planning and Consolidation, version for SAP NetWeaver (BPC) Data Manager (DM) Clear (Clear transaction data) package, it aborts (abort status) or does not end.
  • The following run time error (dump) also appears in transaction code ST22:

Category Installation error
Runtime Errors DBSQL_SQL_ERROR

Short Text
SQL error "SQL code: 3114" occurred while accessing table "SOTR_HEAD".

What happened?
Database error text: "SQL message: ORA-03114: not connected to ORACLE"

Return value of the database layer: "SQL dbsl rc: 99"

20-Sep-17 1-46-01 PM.png

  • If you open the BPC: Clear Transaction Data (/CPMB/CLEAR) process chain in transaction code RSPC and review the logs (Right click display logs), the BPC: CLEAR COMMENTS FOR CLEAR step (variant /CPMB/CLEAR_COMMENTS_FOR_CLEAR) appears in a failed state (red):
    20-Sep-17 1-52-18 PM.png
  • This error may also occur in the Simple Job Selection (transaction code SM37):
    Internal session terminated with a runtime error DBSQL_SQL_ERROR (see ST22)

Read more...

Environment

  • SAP Business Planning and Consolidation, version for SAP NetWeaver
  • SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation, version for SAP NetWeaver all versions ; SAP NetWeaver 7.5

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , EPM-BPC-NW , NetWeaver Version , How To

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.