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.
SAP Knowledge Base Article - Preview