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
ABAP Program SAPLAGS_CC_AGGREGATE_UPL
Application Component SV-SMG-CCM-CDM
An error has occurred while parsing a dynamic entry.
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
>>>>> 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.
Solution Manager 7.2 SP03+
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 pageThis 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.