2623765 - Runtime error " DBSQL_SQL_ERROR" caused by a long running job "AGSCC_QCACH, ID:dvm_ici_xxx" in SAP Solution Manager 7.2 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2623765 - Runtime error " DBSQL_SQL_ERROR" caused by a long running job "AGSCC_QCACH, ID:dvm_ici_xxx" in SAP Solution Manager 7.2

Symptom

  • In ST22 the following dump is found:

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR

Short Text
    SQL error "SQL code: 12205" occurred while accessing table "AGSCC_QCACH_INF".

Information on where terminated
    The termination occurred in ABAP program "CL_AGSCC_QCACH_DB=============CP",
     in "DELETE_AXIS_INFO". The main program
    was "SAPMSSY1".

    In the source code, the termination point is in line 3 of (Include)
    program "CL_AGSCC_QCACH_DB=============CM004".
    The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
     "DELETE_AXIS_INFO" "(METHOD)".
    This exception was not handled locally or declared in the RAISING
    clause in the procedure's signature however.
    The procedure is in program "CL_AGSCC_QCACH_DB=============CP". The source
     code begins in line 1 of
    (include) program "CL_AGSCC_QCACH_DB=============CM004".

Information on where terminated
    The termination occurred in ABAP program "CL_AGSCC_QCACH_DB=============CP",
     in "DELETE_AXIS_INFO". The main program
    was "SAPMSSY1".

    In the source code, the termination point is in line 3 of (Include)
    program "CL_AGSCC_QCACH_DB=============CM004".
    The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
     "DELETE_AXIS_INFO" "(METHOD)".
    This exception was not handled locally or declared in the RAISING
    clause in the procedure's signature however.
    The procedure is in program "CL_AGSCC_QCACH_DB=============CP". The source
     code begins in line 1 of
    (include) program "CL_AGSCC_QCACH_DB=============CM004".

Line  SourceCde

>>>>> delete from AGSCC_qcach_inf where query_guid = query_guid.

  • The job "AGSCC_QCACH, ID:dvm_ici_xxx" is running for an excessive amount of time

Read more...

Environment

SAP Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

AGSCC_QCACH, ID:dvm_ici_xxx, E2E_ICIDB_EXT_DVM, CL_AGSCC_QCACH_DB=============CM004, DBSQL_SQL_ERROR, AGSCC_QCACH_INF,
runtime errors, excessive runtime, configure. , KBA , SV-SMG-DVM , Data Volume 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.