Symptom
The Usage Data(UPL and SCMON) app in the Custom Code Management workcenter does not display any available systems and in TCode ST22 you observe the following dump:
Category ABAP Programming Error
Runtime Errors SAPSQL_PARSE_ERROR
Except. CX_SY_DYNAMIC_OSQL_SEMANTICS
ABAP Program SAPLAGS_CC_AGGREGATE_UPL
Application Component SV-SMG-CCM-CDM
Short Text
An error has occurred while parsing a dynamic entry.
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLAGS_CC_AGGREGATE_UPL" had to be terminated because it has
come across a statement that unfortunately cannot be executed.
Information on where terminated
The termination occurred in ABAP program "SAPLAGS_CC_AGGREGATE_UPL", in "SYSTEMS_FROM_NON_HDB". The main program was "SAPMSSY1".
In the source code, the termination point is in line 153 of (Include) program "LAGS_CC_AGGREGATE_UPLP01".
The termination is due to exception "CX_SY_DYNAMIC_OSQL_SEMANTICS" occurring in procedure "SYSTEMS_FROM_NON_HDB" "(METHOD)".
This exception was not handled locally or declared in the RAISING clause in the procedure's signature however.
The procedure is in program "SAPLAGS_CC_AGGREGATE_UPL". The source code begins in line 116 of (include) program "LAGS_CC_AGGREGATE_UPLP01".
151 "Get data from the dimension
152 "***************************
>>>>> SELECT DISTINCT sid_0smd_lsid dimid
154 FROM (ls_cube_tables-landscape_dimension_table) " /bi0/d0sm_upl2
155 INTO CORRESPONDING FIELDS OF TABLE lt_landscape_data.
Read more...
Environment
Solution Manager 7.2 SP03+
Product
Keywords
CCM, Custom Code Management Workcenter, UPL Data App, UPL and SCMON App, UPL, SCMON, No Available Systems, SAPSQL_PARSE_ERROR, CX_SY_DYNAMIC_OSQL_SEMANTICS, SAPLAGS_CC_AGGREGATE_UPL , KBA , SV-SMG-CCM , Custom Code Management , 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.