Symptom
- When running archive write job for any archive object a SARA SAPSQL_ARRAY_INSERT_DUPREC dump is thrown.
- From reviewing the dump the issue looks to be related to table ADMI_VARIA, code where dump is thrown => INSERT admi_varia FROM TABLE lt_admi_varia
- The details of the dump are as follows:
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLARCH
"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"
"SAPLARCH" or "LARCHF01"
"CONSTRUCTOR"
1030 " save values of variant in ADMI_VARIA
1031 ls_admi_varia-document = me->current_session.
1032 LOOP AT lt_variant INTO ls_variant.
1033 ls_admi_varia-sequence = sy-tabix.
1034 MOVE-CORRESPONDING ls_variant TO ls_admi_varia.
1035 MOVE ls_variant-option TO ls_admi_varia-opti.
1036 APPEND ls_admi_varia TO lt_admi_varia.
1037 ENDLOOP.
1038 IF sy-subrc IS INITIAL. " LOOP was entered at least once
>>>>> INSERT admi_varia FROM TABLE lt_admi_varia.
Active Calls/Events
No. Ty. Program Include
Name
3 METHOD SAPLARCH LARCHF01
CL_SESSION_ADMIN_WW=>CONSTRUCTOR
2 FUNCTION SAPLARCH LARCHU12
ARCHIVE_OPEN_FOR_WRITE
1 EVENT ARCHIVE_OBJECT_WRITE_PROGRAM ARCHIVE_OBJECT_WRITE_PROGRAM
START-OF-SELECTION
Read more...
Environment
- SAP Business Technology Platform
- SAP Basis release independent
Product
SAP ERP all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions
Keywords
ADK, archiving, SARA, write job, write variant, 9999, selection, criteria, limit, from-to , KBA , BC-CCM-ADK , Archive Development Kit , 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