SAP Knowledge Base Article - Preview

2449131 - Usage Data app does not show any available systems


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.



Solution Manager 7.2 SP03+


SAP Solution Manager 7.2


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.