SAP Knowledge Base Article - Preview

2645599 - "The SQL command for a FOR ALL ENTRIES select is too large." error with BPO Alert Inbox in SAP Solution Manager 7.2

Symptom

Within SAP Solution Manager 7.2, attempting to load/open the Business Process Monitoring Alert Inbox results in the following runtime error:

  • "Error while processing your query
     What has happened?

     The URL call http://<SITE>:<CLIENT>/sap/bc/webdynpro/sap/WDC_BPMON_ALRT_INBOX was terminated because of an error.

     The following error occurred in system <SID> : The SQL command for a FOR ALL ENTRIES select is too large."

The following shortdump is generated in the system for the above error, accessible via ST22:

         Category                       ABAP Programming Error
         Runtime                        Errors DBSQL_FAE_STATEMENT_TO_BIG
         Except.                         CX_SY_OPEN_SQL_DB
         ABAP Program               CL_ABR_Q_SMUD_MAI=============CP
         Application Component   SV-SMG-MON-BPM

         Short Text
                  The SQL command for a FOR ALL ENTRIES select is too large.

         Information on where terminated
                  The termination occurred in ABAP program "CL_ABR_Q_SMUD_MAI=============CP",
                  in "IF_AGS_BPM_REP_QUERY~EXECUTE". The main program
                  was "SAPMHTTP".

                  In the source code, the termination point is in line 68 of (Include)
                  program "CL_ABR_Q_SMUD_MAI=============CM002".
                  The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
                  "IF_AGS_BPM_REP_QUERY~EXECUTE" "(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_ABR_Q_SMUD_MAI=============CP". The source
                  code begins in line 1 of
                  (include) program "CL_ABR_Q_SMUD_MAI=============CM002".


Read more...

Environment

SAP Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

BPM, BPMON, Alert Inbox, Business Process Monitoring , KBA , SV-SMG-MON-BPM-MON , Monitoring , SV-SMG-MON-BPM , Business Process Operations , 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.