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 Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date 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.