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
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.
SAP Knowledge Base Article - Preview