Symptom
After upgrading to Solution Manager 7.2 SPS03 or SPS04, the following dump occurs in ST22 when running the report SMREP_PROCESS_BW_DATA_QUEUE. The exact error code may vary, depending on the database:
Category Installation ErrorsRuntime Errors DBSQL_SQL_ERRORExcept. CX_SY_OPEN_SQL_DBDate and Time DD.MM.YYYY HH:MM:SS
|Short Text |
| SQL error "SQL code: 264" occurred while accessing table "CDS_WMM_DETAILS".
|What happened? |
| Database error text: "SQL message: invalid datatype: LOB type in distinct |
| select clause: line 1 col 123 (at pos 122)"
| Function module..... ADD_CCDB_ABAP_EXTRACTOR
| 1| METHOD if_workmode_dao~get_wm_details_for_time_range. |
| 2| IF it_contexts IS SUPPLIED. |
|>>>>>| SELECT * FROM cds_wmm_details INTO CORRESPONDING FIELDS OF TABLE rt_context_workmodes |
| 4| FOR ALL ENTRIES IN it_contexts
| 10 METHOD CL_WORKMODE_DAO===============CP CL_WORKMODE_DAO===============CM00V 3 |
| CL_WORKMODE_DAO=>IF_WORKMODE_DAO~GET_WM_DETAILS_FOR_TIME_RANGE |
| 9 METHOD CL_WMM_API====================CP CL_WMM_API====================CM00K 26 |
| CL_WMM_API=>GET_ALL_WMS_FOR_CONTEXT_IDS |
| 8 METHOD CL_WMM_API====================CP CL_WMM_API====================CM00J 31 |
| CL_WMM_API=>GET_ALL_WMS_FOR_CONTEXTS |
| 7 FUNCTION SAPLDSWP_WMM_MON_API LDSWP_WMM_MON_APIU01 59 |
| FDSWP_GET_WM_INFO
Read more...
Environment
SAP Solution Manager 7.2
Product
Keywords
ORA-00932, SQL code: -134, SQL code: 932 , KBA , SV-SMG-MON-REP , Content for Technical Monitoring Reporting , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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