Symptom
Odata request fails dump like:
Category ABAP programming error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program /IWFND/CL_SUTIL_STATISTICS====CP
Application Component OPU-FND-CS
|Short Text |
| Open SQL array insert produces duplicate records in the database. |
| 1| METHOD write_mhub_data. |
| 2| |
| 3| IF it_sutil_stats IS NOT INITIAL. |
|>>>>>| INSERT /iwfnd/su_stats FROM TABLE it_sutil_stats. |
| 5| ENDIF. |
| 6| |
| 7| ENDMETHOD. |
| 9 METHOD /IWFND/CL_SUTIL_STATISTICS====CP /IWFND/CL_SUTIL_STATISTICS====CM00E 4 |
| /IWFND/CL_SUTIL_STATISTICS=>WRITE_MHUB_DATA |
| 8 METHOD /IWFND/CL_METERING_DB=========CP /IWFND/CL_METERING_DB=========CM00S 17 |
| /IWFND/CL_METERING_DB=>STORE_MHUB_DATA |
| 7 METHOD /IWFND/CL_METERING_API========CP /IWFND/CL_METERING_API========CM00O 7 |
| /IWFND/CL_METERING_API=>STORE_MHUB_DATA |
| 6 METHOD /IWFND/CL_SODATA_HTTP_HANDLER=CP /IWFND/CL_SODATA_HTTP_HANDLER=CM00M 80 |
| /IWFND/CL_SODATA_HTTP_HANDLER=>FINALIZE_MICRO_HUB_REQUEST_17 |
| 5 METHOD /IWFND/CL_SODATA_HTTP_HANDLER=CP /IWFND/CL_SODATA_HTTP_HANDLER=CM00O 503 |
| /IWFND/CL_SODATA_HTTP_HANDLER=>PROCESS_MICRO_HUB_REQUEST_17 |
| 4 METHOD /IWFND/CL_SODATA_HTTP_HANDLER=CP /IWFND/CL_SODATA_HTTP_HANDLER=CM002 210 |
| /IWFND/CL_SODATA_HTTP_HANDLER=>IF_HTTP_EXTENSION~HANDLE_REQUEST |
| 3 METHOD CL_HTTP_SERVER================CP CL_HTTP_SERVER================CM00I 801 |
| CL_HTTP_SERVER=>EXECUTE_REQUEST |
| 2 FUNCTION SAPLHTTP_RUNTIME LHTTP_RUNTIMEU02 1566 |
| HTTP_DISPATCH_REQUEST |
| 1 MODULE (PBO) SAPMHTTP SAPMHTTP 12 |
| %_HTTP_START |
Read more...
Environment
"Micro Hub" or "OData on Backend" is used.
Product
Keywords
DBSQL_DUPLICATE_KEY_ERROR, /IWFND/CL_SUTIL_STATISTICS, "Micro Hub", "OData on Backend", write_mhub_data, /iwfnd/su_stats , KBA , OPU-FND-CS , Common Services (Only Internal use) , 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.