Symptom
- Short dump in function module TABLE_IMRG_UPDATE when running RIIBIP00
- "SAPSQL_ARRAY_INSERT_DUPREC" dump in transactions IK21 or IK11
- Short dump "SAPSQL_ARRAY_INSERT_DUPREC" occurs when entering/creating
measurement documents - Short dump details:
Category ABAP Programming Error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLIMR1
How to correct the error
Probably the only way to eliminate the error is to correct the
program.
If the error occurs in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"
"SAPLIMR1" or "LIMR1U05"
"TABLE_IMRG_UPDATE"
Source Code Extract
----------------------------------------------------------------------------------------------------
|Line |SourceCde
----------------------------------------------------------------------------------------------------
| 60|
| 61|* Read customizing
| 62| SELECT SINGLE * FROM t370p INTO ls_t370p WHERE valid ='X'.
| 63|
| 64|* Is testing active
| 65| IF ls_t370p-valid EQ 'X'.
| 66| CALL FUNCTION 'IMRG_TEST_DATA_VALIDATE'
| 67| EXPORTING
| 68| iv_mode = '1' " posting mode
| 69| iv_stop = 'X' " stop after first error
| 70| TABLES
| 71|* return
| 72|* t_imrg
| 73| t_imrg_ins = imrg_ins
| 74| t_imrg_upd = imrg_upd
| 75| t_imrg_old = imrg_old
| 76| EXCEPTIONS
| 77| imrg_test_error = 1
| 78| OTHERS = 2.
| 79| IF sy-subrc <> 0.
| 80|* time to dump
| 81| MESSAGE ID SY-MSGID TYPE 'X' NUMBER SY-MSGNO
| 82| WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
| 83| ENDIF.
| 84| ENDIF.
| 85|
| 86|* Time to post
| 87| DESCRIBE TABLE imrg_ins LINES x_lines.
| 88| IF NOT ( x_lines IS INITIAL ).
| 89|* Array-INSERT ....................
|>>>>>| INSERT IMRG FROM TABLE IMRG_INS.
| 91| ENDIF.
| 92|
Read more...
Environment
- SAP ERP Plant Maintenance (PM)
- SAP ERP Central Component
- SAP ERP
- SAP Enhancement package for SAP ERP
- SAP Enhancement package for SAP ERP, version for SAP HANA
Product
Keywords
Measurement documents, IFCU, IK12, IK22 collective entry, MeasDocuments, create, change, runtime error, terminated , KBA , PM-EQM-SF-MPC , Measuring points and counters , How To
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.