Question from Poulomi on Sep 10 at 5:22 AM Hi,
When a visit list replication job is running in ECC to replicate the created visit lists it is some times failing in ECC giving a runtime error SAPSQL_ARRAY_INSERT_DUPREC. But this issue is not consistent and not replicated in sub production systems but occurring intermittently in production.
But is the job is rerun it is running successfully.
But I need a permanent solution to this.
The dump details given below:
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Exception CX_SY_OPEN_SQL_DB
Date and Time 2014.09.05 17:31:54
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short text |
| The ABAP/4 Open SQL array insert results in duplicate database records. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| Error in the ABAP Application Program |
| |
| The current ABAP program "SAPLCRM_ORDERADM_H_DU" had to be terminated because |
| it has |
| come across a statement that unfortunately cannot be executed. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What can you do? |
| Note down which actions and inputs caused the error. |
| |
| |
| To process the problem further, contact you SAP system |
| administrator. |
| |
| Using Transaction ST22 for ABAP Dump Analysis, you can look |
| at and manage termination messages, and you can also |
| keep them for a long time. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Error analysis |
| An exception occurred that is explained in detail below. |
| The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught |
| in |
| procedure "CRM_ORDERADM_H_UPDATE_DU" "(FUNCTION)", nor was it propagated by a |
| RAISING clause. |
| Since the caller of the procedure could not have anticipated that the |
| exception would occur, the current program is terminated. |
| The reason for the exception is: |
| If you use an ABAP/4 Open SQL array insert to insert a record in |
| the database and that record already exists with the same key, |
| this results in a termination. |
| |
| (With an ABAP/4 Open SQL single record insert in the same error |
| situation, processing does not terminate, but SY-SUBRC is set to 4.) |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|How to correct the error |
| Use an ABAP/4 Open SQL array insert only if you are sure that none of |
| the records passed already exists in the database. |
| |
| If the error occures 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" |
| "SAPLCRM_ORDERADM_H_DU" or "LCRM_ORDERADM_H_DUU01" |
| "CRM_ORDERADM_H_UPDATE_DU" |
| |
| If you cannot solve the problem yourself and want to send an error |
| notification to SAP, include the following information: |
| |
| 1. The description of the current problem (short dump) |
| |
| To save the description, choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 2. Corresponding system log |
| |
| Display the system log by calling transaction SM21. |
| Restrict the time interval to 10 minutes before and five minutes |
| after the short dump. Then choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 3. If the problem occurs in a problem of your own or a modified SAP |
| program: The source code of the program |
| In the editor, choose "Utilities->More |
| Utilities->Upload/Download->Download". |
| |
| 4. Details about the conditions under which the error occurred or which |
| actions and input led to the error. |
| |
| The exception must either be prevented, caught within proedure |
| "CRM_ORDERADM_H_UPDATE_DU" "(FUNCTION)", or its possible occurrence must be |
| declared in the |
| RAISING clause of the procedure. |
| To prevent the exception, note the following: |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|System environment |
| SAP-Release 700 |
| |
| Application server... "SAPPCR03" |
| Network address...... "10.248.200.109" |
| Operating system..... "AIX" |
| Release.............. "6.1" |
| Hardware type........ "00C45FFE4C00" |
| Character length.... 16 Bits |
| Pointer length....... 64 Bits |
| Work process number.. 37 |
| Shortdump setting.... "full" |
| |
| Database server... "pl1ca288" |
| Database type..... "ORACLE" |
| Database name..... "PCR" |
| Database user ID.. "SAPSR3" |
| |
| Char.set.... "C" |
| |
| SAP kernel....... 721 |
| created (date)... "Feb 16 2014 12:11:35" |
| create on........ "AIX 1 6 00C027A54C00" |
| Database version. "OCI_112, 11.2.0.2.0, V2, default" |
| |
| Patch level. 219 |
| Patch text.. " " |
| |
| Database............. "ORACLE 10.1.0.*.*, ORACLE 10.2.0.*.*, ORACLE 11.2.*.*.*" |
| SAP database version. 721 |
| Operating system..... "AIX 1 6, AIX 1 7" |
| |
| Memory consumption |
| Roll.... 0 |
| EM...... 71226464 |
| Heap.... 0 |
| Page.... 1884160 |
| MM Used. 1133664 |
| MM Free. 3053456 |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|User and Transaction |
| Client.............. 400 |
| User................ "USRFERP1" |
| Language Key........ "S" |
| Transaction......... " " |
| Transactions ID..... "54084D97D5848710E10080000AF8C870" |
| |
| Program............. "SAPLCRM_ORDERADM_H_DU" |
| Screen.............. "SAPMSSY0 1000" |
| Screen Line......... 6 |
| |
| Information on caller of Remote Function Call (RFC): |
| System.............. "PR3" |
| Database Release.... 700 |
| Kernel Release...... 721 |
| Connection Type..... 3 (2=R/2, 3=ABAP System, E=Ext., R=Reg. Ext.) |
| Call Type........... "synchronous and non-transactional (emode 0, imode 1)" |
| Inbound TID.........." " |
| Inbound Queue Name..." " |
| Outbound TID........." " |
| Outbound Queue Name.." " |
| |
| Client.............. 400 |
| User................ "USERJOBS" |
| Transaction......... " " |
| Call Program........."/SMLSD/SAPLVISIT_REPLICATION " |
| Function Module..... "/SMLSD/GEN_CALL_LIST" |
| Call Destination.... "PR3PCR400" |
| Source Server....... "SAPPR307_PR3_07" |
| Source IP Address... "10.248.200.112" |
| |
| Additional information on RFC logon: |
| Trusted Relationship " " |
| Logon Return Code... 0 |
| Trusted Return Code. 0 |
| |
| Note: For releases < 4.0, information on the RFC caller are often |
| only partially available. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Information on where terminated |
| Termination occurred in the ABAP program "SAPLCRM_ORDERADM_H_DU" - in |
| "CRM_ORDERADM_H_UPDATE_DU". |
| The main program was "SAPMSSY4 ". |
| |
| In the source code you have the termination point in line 31 |
| of the (Include) program "LCRM_ORDERADM_H_DUU01". |
| The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in |
| procedure "CRM_ORDERADM_H_UPDATE_DU" "(FUNCTION)", but it was neither handled |
| locally nor declared |
| in the RAISING clause of its signature. |
| |
| The procedure is in program "SAPLCRM_ORDERADM_H_DU "; its source code begins in |
| line |
| 1 of the (Include program "LCRM_ORDERADM_H_DUU01 ". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Source Code Extract |
----------------------------------------------------------------------------------------------------
|Line |SourceCde |
----------------------------------------------------------------------------------------------------
| 1|FUNCTION crm_orderadm_h_update_du. |
| 2|*"---------------------------------------------------------------------- |
| 3|*"*"Verbuchungsfunktionsbaustein: |
| 4|*" |
| 5|*"*"Globale Schnittstelle: |
| 6|*" IMPORTING |
| 7|*" VALUE(IT_RECORDS_TO_INSERT) TYPE CRMT_ORDERADM_H_DU_TAB |
| 8|*" OPTIONAL |
| 9|*" VALUE(IT_RECORDS_TO_UPDATE) TYPE CRMT_ORDERADM_H_DU_TAB |
| 10|*" OPTIONAL |
| 11|*" VALUE(IT_RECORDS_TO_DELETE) TYPE CRMT_ORDERADM_H_DU_TAB |
| 12|*" OPTIONAL |
| 13|*" VALUE(IT_GUID_TO_DELETE) TYPE CRMT_OBJECT_KEY_TAB OPTIONAL |
| 14|*"---------------------------------------------------------------------- |
| 15| |
| 16|*Data declarations |
| 17| DATA: lt_editpos LIKE cdred OCCURS 0. |
| 18| DATA: lv_guid TYPE crmt_schedlin_guid. |
| 19| DATA: lv_objectid_c TYPE char32. |
| 20| DATA: lv_objectclass TYPE cdhdr-objectclas VALUE 'CRM_ORDER'. |
| 21| DATA: ls_o_crm_orderadm_h LIKE crmt_orderadm_h_wrk. |
| 22| DATA: n_crma_orderadm_h LIKE crma_orderadm_h. |
| 23| DATA: o_crma_orderadm_h LIKE crma_orderadm_h. |
| 24| DATA: lv_objectid_del TYPE cdhdr-objectid. |
| 25| FIELD-SYMBOLS: <fs_guid_to_delete_changedoc> LIKE LINE OF it_records_to_delete. |
| 26| DATA: ls_guid_to_delete_changedoc LIKE LINE OF it_records_to_delete. |
| 27| |
| 28| |
| 29|*** records to insert |
| 30| IF NOT it_records_to_insert IS INITIAL. |
|>>>>>| INSERT crmd_orderadm_h FROM TABLE it_records_to_insert. |
| 32| IF sy-subrc NE 0. |
| 33| MESSAGE a002(crm_order_misc) WITH gc_object_name-orderadm_h. |
| 34| ENDIF. |
| 35| IF sy-oncom NE 'P'. |
| 36| PERFORM trigger_events ON COMMIT. |
| 37| ELSE. "don't run perform on commit if already called within perform on commit |
| 38| PERFORM trigger_events. |
| 39| ENDIF. |
| 40| ENDIF. |
| 41| |
| 42|*** records to update |
| 43| IF NOT it_records_to_update IS INITIAL. |
| 44| UPDATE crmd_orderadm_h FROM TABLE it_records_to_update. |
| 45| IF sy-subrc NE 0. |
| 46| MESSAGE a002(crm_order_misc) WITH gc_object_name-orderadm_h. |
| 47| ENDIF. |
| 48| ENDIF. |
| 49| |
| 50|*** records to delete |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Contents of system fields |
----------------------------------------------------------------------------------------------------
|Name |Val. |
----------------------------------------------------------------------------------------------------
|SY-SUBRC|0 |
|SY-INDEX|0 |
|SY-TABIX|2 |
|SY-DBCNT|1 |
|SY-FDPOS|0 |
|SY-LSIND|0 |
|SY-PAGNO|0 |
|SY-LINNO|1 |
|SY-COLNO|1 |
|SY-PFKEY| |
|SY-UCOMM| |
|SY-TITLE|Control de actualización |
|SY-MSGTY| |
|SY-MSGID| |
|SY-MSGNO|000 |
|SY-MSGV1| |
|SY-MSGV2| |
|SY-MSGV3| |
|SY-MSGV4| |
|SY-MODNO|0 |
|SY-DATUM|20140905 |
|SY-UZEIT|173153 |
|SY-XPROG|RSDBRUNT |
|SY-XFORM|%_INIT_PBO_FIRST |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Active Calls/Events |
----------------------------------------------------------------------------------------------------
|No. Ty. Program Include Line |
| Name |
----------------------------------------------------------------------------------------------------
| 5 FUNCTION SAPLCRM_ORDERADM_H_DU LCRM_ORDERADM_H_DUU01 31 |
| CRM_ORDERADM_H_UPDATE_DU |
| 4 FORM SAPLCRM_ORDERADM_H_DU LCRM_ORDERADM_H_DUU01 1 |
| CRM_ORDERADM_H_UPDATE_DU |
| 3 FORM SAPMSSY4 SAPMSSY4 117 |
| %_UPDATES_NO_UTASK |
| 2 FORM SAPMSSY4 SAPMSSY4 37 |
| LOCAL_UPDATE_TASK |
| 1 EVENT SAPMSSY4 SAPMSSY4 19 |
| START-OF-SELECTION |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Chosen variables |
----------------------------------------------------------------------------------------------------
|Name |
| Val. |
----------------------------------------------------------------------------------------------------
|No. 5 Ty. FUNCTION |
|Name CRM_ORDERADM_H_UPDATE_DU |
----------------------------------------------------------------------------------------------------
|SY-XFORM |
| %_INIT_PBO_FIRST |
| 000000000000000000000000000000 |
| 000000000000000000000000000000 |
| 254445554454455522222222222222 |
| 5F9E94F02FF6923400000000000000 |
|IT_GUID_TO_DELETE |
| Table[initial] |
|SY-XPROG |
| RSDBRUNT |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5544554522222222222222222222222222222222 |
| 234225E400000000000000000000000000000000 |
|IT_RECORDS_TO_DELETE |
| Table[initial] |
|%_ARCHIVE |
| |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 22222222222222222222222222222222222222222222222222 22222222222222222222222222222222222222222222|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
|IT_RECORDS_TO_INSERT |
| 400########1145700293ZTP1201409053000707545_JULIO CESAR_PUMA QUINTASI_JPUSPCRCLNT400BBPCRM 600|
| 0005F32E80C000000000000000000000000000000000000000 00000000000 000000000000000000000000000000000|
| 0004F8310A8000000000000000000000000000000000000000 00000000000 000000000000000000000000000000000|
| 33302F100F6333333333355533333333333333333335454442 44545555442554454545455554544453334454542333|
| 400A710008D1145700293A401201409053000707545FA5C9F0 35312F05D10159E4139FA0530323CE440022032D0600|
| Table IT_12[1x418] |
| \FUNCTION-POOL=CRM_ORDERADM_H_DU\DATA=IT_RECORDS_TO_INSERT |
| Table reference: 7 |
| TABH+ 0(20) = 07000000802159C0000000000000000000000000 |
| TABH+ 20(20) = 000000070000000C00000001000001A2FFFFFFFF |
| TABH+ 40(16) = 04000022000461F0000145AC13000000 |
| store = 0x07000000802159C0 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 7 (0x00000007) |
| label = 12 (0x0000000C) |
| fill = 1 (0x00000001) |
| leng = 418 (0x000001A2) |
| loop = -1 (0xFFFFFFFF) |
| xtyp = TYPE#000421 |
| occu = 1 (0x00000001) |
| accKind = 2 (ItAccessSorted) |
| idxKind = 0 (ItIndexNone) |
| uniKind = 2 (ItUniNo) |
| keyKind = 3 (user defined) |
| cmpMode = 5 (cmpSingle) |
| occu0 = 1 |
| stMode = 0 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 1 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| hasScndKeys = 0 |
| hasRowId = 0 |
| scndKeysOutdated = 0 |
| scndUniKeysOutdated = 0 |
| ----- Shareable Table Header Data ----- |
| tabi = 0x0700000080215A40 |
| pgHook = 0x0000000000000000 |
| idxPtr = 0x0000000000000000 |
| id = 10 (0x0000000A) |
| shmTabhSet = 0x0000000000000000 |
| refCount = 1 (0x00000001) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 1 (0x00000001) |
| lineAlloc = 1 (0x00000001) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 2 (0x00000002) |
| rowId = 18446744073709551615 |
| scndKeyAdmin = 0x0000000000000000 |
|%_VIASELSCR |
| # |
| 0 |
| 4 |
|IT_RECORDS_TO_UPDATE |
| Table[initial] |
|GC_CI_NAME |
| CI_EEW_ORDERADM_H CI_EEW_ORDERADM_I CI_EEW_ACTIVITY_H CI_E|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 44544554544544454222222222222244544554544544454222 22222222224454455445454555422222222222224454|
| 39F557FF245214DF8000000000000039F557FF245214DF9000 000000000039F557F13496949F8000000000000039F5|
|<%_TABLE_CRMD_ORDERADM_H> |
| ??? |
| ?????? |
| ?????? |
|GC_CREDIT_CHECK_QUANTITY |
| A |
| 00 |
| 00 |
| 24 |
| 01 |
|SY-SUBRC |
| 0 |
| 0000 |
| 0000 |
|SY-REPID |
| SAPLCRM_ORDERADM_H_DU |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454454545445444545452222222222222222222 |
| 310C32DFF245214DF8F450000000000000000000 |
|SY-MSGID |
| |
| 00000000000000000000 |
| 00000000000000000000 |
| 22222222222222222222 |
| 00000000000000000000 |
|GC_DOCU_INTERN_OBJECT |
| DSYS |
| 0000000000 |
| 0000000000 |
| 4555222222 |
| 4393000000 |
|SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SY-MSGNO |
| 000 |
| 000 |
| 000 |
| 333 |
| 000 |
|SY-MSGV1 |
| |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
|GC_OBJECT_NAME-ORDERADM_H |
| ORDERADM_H |
| 000000000000000000000000000000 |
| 000000000000000000000000000000 |
| 454454445422222222222222222222 |
| F245214DF800000000000000000000 |
|SY-MSGV2 |
| |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
|SY-MSGV3 |
| |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
|SY-MSGV4 |
| |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
|SY-ONCOM |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SCREEN |
| |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 22222222222222222222222222222222222222222222222222 22222222222222222222222222222222222222222222|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
----------------------------------------------------------------------------------------------------
|No. 4 Ty. FORM |
|Name CRM_ORDERADM_H_UPDATE_DU |
----------------------------------------------------------------------------------------------------
|SYST-REPID |
| SAPLCRM_ORDERADM_H_DU |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454454545445444545452222222222222222222 |
| 310C32DFF245214DF8F450000000000000000000 |
|%_%_IT_RECORDS_TO_UPDATE |
| Table[initial] |
|%_%_IT_RECORDS_TO_DELETE |
| Table[initial] |
|%_%_IT_GUID_TO_DELETE |
| Table[initial] |
|GC_APPOINTMENT_MAINT_ID |
| 123 |
| 000 |
| 000 |
| 333 |
| 123 |
|%_KEY |
| %%L0h}epZn8n3X08002lZ8RG 1 |
| 0000000000000000000000000000000000 |
| 0000000000000000000000000000000000 |
| 2243676756363533333653542222222232 |
| 55C08D50AE8E3808002CA8270000000010 |
|%_SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|%_%_IT_RECORDS_TO_INSERT |
| 400########1145700293ZTP1201409053000707545_JULIO CESAR_PUMA QUINTASI_JPUSPCRCLNT400BBPCRM 600|
| 0005F32E80C000000000000000000000000000000000000000 00000000000 000000000000000000000000000000000|
| 0004F8310A8000000000000000000000000000000000000000 00000000000 000000000000000000000000000000000|
| 33302F100F6333333333355533333333333333333335454442 44545555442554454545455554544453334454542333|
| 400A710008D1145700293A401201409053000707545FA5C9F0 35312F05D10159E4139FA0530323CE440022032D0600|
| Table IT_10[1x418] |
| \FUNCTION-POOL=CRM_ORDERADM_H_DU\FORM=CRM_ORDERADM_H_UPDATE_ DU\DATA=%_%_IT_RECORDS_TO_INSERT |
| Table reference: 5 |
| TABH+ 0(20) = 07000000802159C0000000000000000000000000 |
| TABH+ 20(20) = 000000050000000A00000001000001A2FFFFFFFF |
| TABH+ 40(16) = 04000022000461F0000145AC13000000 |
| store = 0x07000000802159C0 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 5 (0x00000005) |
| label = 10 (0x0000000A) |
| fill = 1 (0x00000001) |
| leng = 418 (0x000001A2) |
| loop = -1 (0xFFFFFFFF) |
| xtyp = TYPE#000421 |
| occu = 1 (0x00000001) |
| accKind = 2 (ItAccessSorted) |
| idxKind = 0 (ItIndexNone) |
| uniKind = 2 (ItUniNo) |
| keyKind = 3 (user defined) |
| cmpMode = 5 (cmpSingle) |
| occu0 = 1 |
| stMode = 0 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 1 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| hasScndKeys = 0 |
| hasRowId = 0 |
| scndKeysOutdated = 0 |
| scndUniKeysOutdated = 0 |
| ----- Shareable Table Header Data ----- |
| tabi = 0x0700000080215A40 |
| pgHook = 0x0000000000000000 |
| idxPtr = 0x0000000000000000 |
| id = 10 (0x0000000A) |
| shmTabhSet = 0x0000000000000000 |
| refCount = 1 (0x00000001) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 1 (0x00000001) |
| lineAlloc = 1 (0x00000001) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 2 (0x00000002) |
| rowId = 18446744073709551615 |
| scndKeyAdmin = 0x0000000000000000 |
|%_DUMMY$$ |
| |
| 0000 |
| 0000 |
| 2222 |
| 0000 |
----------------------------------------------------------------------------------------------------
|No. 3 Ty. FORM |
|Name %_UPDATES_NO_UTASK |
----------------------------------------------------------------------------------------------------
|TH_VB_SERVER_TYPE |
| # |
| 0 |
| 0 |
|<%_TABLE_TFDIR> |
| ??? |
| ?????? |
| ?????? |
|SYST-REPID |
| SAPMSSY4 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454555322222222222222222222222222222222 |
| 310D339400000000000000000000000000000000 |
|SY-REPID |
| SAPMSSY4 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454555322222222222222222222222222222222 |
| 310D339400000000000000000000000000000000 |
|RST_VB_STATISTIC |
| # |
| 0 |
| B |
|TH_VB_FB_MODE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|%_VB_CALLS-FUNC_NAME |
| CRM_ORDERADM_H_UPDATE_DU |
| 000000000000000000000000000000 |
| 000000000000000000000000000000 |
| 454545445444545554454545222222 |
| 32DFF245214DF8F504145F45000000 |
|%_PRINT |
| 000 0###|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 22223332222222222222222222222222222222222222222222 2222222 2222222222222222222222222222222223000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
|TFDIR |
| CRM_ORDERADM_H_UPDATE_DU SAPLCRM_ORDERADM_H_DU 0100000000V 1|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 45454544544454555445454522222254544545454454445454 52222222222222222222333333333352222222222223|
| 32DFF245214DF8F504145F45000000310C32DFF245214DF8F4 50000000000000000000010000000060000000000001|
|OPCODE_SET_ENQ_INFO |
| ! |
| 2 |
| 1 |
|SY-SUBRC |
| 0 |
| 0000 |
| 0000 |
|%_ARCHIVE |
| |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
| 22222222222222222222222222222222222222222222222222 22222222222222222222222222222222222222222222|
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000|
|VB_COMMIT_PROCESSED |
| # |
| 1 |
| F |
|TFDIR-PNAME |
| SAPLCRM_ORDERADM_H_DU |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454454545445444545452222222222222222222 |
| 310C32DFF245214DF8F450000000000000000000 |
|%_DUMMY$$ |
| |
| 0000 |
| 0000 |
| 2222 |
| 0000 |
|%_VB_CALLS-DATEN_ID |
| %%L0h}epZn8n3X08002lZ8RG 1 |
| 0000000000000000000000000000000000 |
| 0000000000000000000000000000000000 |
| 2243676756363533333653542222222232 |
| 55C08D50AE8E3808002CA8270000000010 |
|%_VIASELSCR |
| # |
| 0 |
| 4 |
|SY-MSGID |
| |
| 00000000000000000000 |
| 00000000000000000000 |
| 22222222222222222222 |
| 00000000000000000000 |
|TH_VB_CLIINFO |
| # |
| 0 |
| 0 |
|RST_VB_DISPATCHING_INFO |
| # |
| 0 |
| A |
|SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SY-MSGNO |
| 000 |
| 000 |
| 000 |
| 333 |
| 000 |
|TH_VB_STATE |
| # |
| 0 |
| 0 |
|SY-MSGV1 |
| |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
----------------------------------------------------------------------------------------------------
|No. 2 Ty. FORM |
|Name LOCAL_UPDATE_TASK |
----------------------------------------------------------------------------------------------------
|%_VB_CALLS[] |
| CRM_ORDER_INDEX_UPDATE_DU %%L0h}epZn8n3X08002lZ8RG 4 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 45455455444545555454555452222222436767563635333336 53542222222232 |
| 32DF3526935FF3F504FF34F450000055C08D50AE8E3808002C A8270000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 45454544544454555445454522222222436767563635333336 53542222222232 |
| 32DFF245214DF8F504145F4500000055C08D50AE8E3808002C A8270000000010 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 45454544555545454445444522222222436767563635333336 53542222222232 |
| 32DFF2452F72945F4F35D5E400000055C08D50AE8E3808002C A8270000000020 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 45454444554545452222222222222222436767563635333336 53542222222232 |
| 32DFC9EBF3165F450000000000000055C08D50AE8E3808002C A8270000000030 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000 |
| 45454544554444555544545452222222436767563635333336 53542222222232 |
| 32DFF2452F9E458F504145F450000055C08D50AE8E3808002C A8270000000040 |
| Table IT_7[10x128] |
| \PROGRAM=SAPMSSY4\DATA=%_VB_CALLS[] |
| Table reference: 2 |
| TABH+ 0(20) = 07000000801C6950000000000000000000000000 |
| TABH+ 20(20) = 00000002000000070000000A0000008000000000 |
| TABH+ 40(16) = 0400000000013BC0000A249003000000 |
| store = 0x07000000801C6950 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 2 (0x00000002) |
| label = 7 (0x00000007) |
| fill = 10 (0x0000000A) |
| leng = 128 (0x00000080) |
| loop = 0 (0x00000000) |
| xtyp = TYPE#000023 |
| occu = 10 (0x0000000A) |
| accKind = 1 (ItAccessStandard) |
| idxKind = 0 (ItIndexNone) |
| uniKind = 2 (ItUniNo) |
| keyKind = 1 (default) |
| cmpMode = 2 (cmpSingleMcmpR) |
| occu0 = 0 |
| stMode = 0 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 0 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| hasScndKeys = 0 |
| hasRowId = 0 |
| scndKeysOutdated = 0 |
| scndUniKeysOutdated = 0 |
| ----- Shareable Table Header Data ----- |
| tabi = 0x070000008020FBF0 |
| pgHook = 0x0000000000000000 |
| idxPtr = 0x0000000000000000 |
| id = 8 (0x00000008) |
| shmTabhSet = 0x0000000000000000 |
| refCount = 0 (0x00000000) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 10 (0x0000000A) |
| lineAlloc = 10 (0x0000000A) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 1 (0x00000001) |
| rowId = 18446744073709551615 |
| scndKeyAdmin = 0x0000000000000000 |
|VBKEY_ID |
| %%540AFF8538F12310E10080000AF8C86D |
| 0000000000000000000000000000000000 |
| 0000000000000000000000000000000000 |
| 2233344433334333334333333334434334 |
| 5554016685386123105100800001683864 |
|SY-XPROG |
| RSDBRUNT |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5544554522222222222222222222222222222222 |
| 234225E400000000000000000000000000000000 |
|VB_GET_PSEUDO_KEY |
| # |
| 1 |
| 5 |
|WALL_ALLOC_FAILED |
| 4 |
| 0000 |
| 0004 |
|RSJOBINFO |
| 00000000000000 ## |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000 |
| 22222222222222222222222222222222333333333333332222 22222222222222222222222222222200 |
| 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000 |
|SY-ONCOM |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|GET_VB_KEY |
| # |
| 0 |
| 2 |
|L_VBKEY-VBKEY |
| |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 22222222222222222222222222222222 |
| 00000000000000000000000000000000 |
|L_ENQKEY |
| |
| 00000000000000000000000000000000000000000000000000 00000000 |
| 00000000000000000000000000000000000000000000000000 00000000 |
| 22222222222222222222222222222222222222222222222222 22222222 |
| 00000000000000000000000000000000000000000000000000 00000000 |
----------------------------------------------------------------------------------------------------
|No. 1 Ty. EVENT |
|Name START-OF-SELECTION |
----------------------------------------------------------------------------------------------------
|SY-LDBPG |
| SAPDB__S |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454455522222222222222222222222222222222 |
| 31042FF300000000000000000000000000000000 |
|SYST |
| ###############################################################################T######## ####|
| 00000000000000000000000000000000000000000000000000 000000000000000000000000000000000000FB000000|
| 00000000000000000000000000000000000000000000000000 000000000000000000000000000000000000F9000500|
| 00000000000000000000000000000000000000080000000000 000000000000000000000000000105000000FB220000|
| 0000020A000000000000010001000100000000000000000000 000000000000000000000000000604000000F000000C|
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Application Calls |
----------------------------------------------------------------------------------------------------
|Index|Calls |
----------------------------------------------------------------------------------------------------
| 1|R=11 T=S S=SAPPR307_PR3_07 I=/SMLSD/SAPLVISIT_REPLICATION F=/SMLSD/GEN_CALL_LIST C=400 U=USE|
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Internal notes |
| The termination was triggered in function "ab_HandleRsqlErrors" |
| of the SAP kernel, in line 724 of the module |
| "//bas/721_REL/src/krn/runt/absapsql.c#18" ;. |
| The internal operation just processed is "SQLS". |
| Internal mode was started at 20140905173153. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Active Calls in SAP Kernel |
----------------------------------------------------------------------------------------------------
|Lines of C Stack in Kernel (Structure Differs on Each Platform) |
----------------------------------------------------------------------------------------------------
|=> 64 bit R/3 Kernel |
|=> 64 bit AIX Kernel |
|=> Heap limit = unlimited |
|=> Stack limit = 33554432 |
|=> Core limit = 1073741312 |
|=> File size limit = unlimited |
|=> Heap address = 0x118ac0860 |
|=> Stack address = 0xfffffffffff62c0 |
|=> Stack low = 0xfffffffffff62c0 |
|=> Stack high = 0xffffffffffff890 |
|=> Stack Trace: |
| CTrcStack() at 0x10052d4e4 |
| CTrcStack@glue4D1() at 0x100f553a0 |
| @22@rabax_CStackSave__Fv@AF40_38() at 0x1027afd38 |
| ab_rabax() at 0x1004dceac |
| ab_HandleRsqlErrors__FR5Jsqls9RsqlError9CloseMode( ) at 0x1004cc708 |
| @23@SqlsExecuteCall__FUcR5Jsqls() at 0x10023ceec |
| ab_jsqls__Fv() at 0x10023a614 |
| ab_extri__Fv() at 0x1001f421c |
| ab_run() at 0x1001fa2ec |
| @17@dynpmcal() at 0x100ab1448 |
| @17@dynppai0() at 0x100ab42a0 |
| dynprctl() at 0x100ab9458 |
| dynpen00() at 0x100aa27b4 |
| Thdynpen00() at 0x1000bf9e0 |
| Unknown at 0x100012a50 |
| ThStart() at 0x100010f9c |
| DpMain() at 0x100007938 |
| main() at 0x100006678 |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|List of ABAP programs affected |
----------------------------------------------------------------------------------------------------
|Index |Typ|Program |Group |Date |Time |Size |Lang. |
----------------------------------------------------------------------------------------------------
| 0|Prg|SAPMSSY4 | 0|2009.02.05|08:21:09| 88064|S |
| 1|Prg|SAPMSSY0 | 1|2009.02.05|08:21:15| 104448|S |
| 2|Prg|SAPMSSYD | 1|2007.02.16|12:52:44| 23552|S |
| 3|Prg|SAPFSYSCALLS | 1|2004.12.17|10:47:44| 8192|S |
| 4|Prg|RSDBRUNT | 0|2009.02.05|08:32:28| 294912|S |
| 5|Typ|RSSCR | 0|1997.06.20|14:06:55| 5120| |
| 6|Prg|RSDBSPBL | 0|2005.02.19|11:28:27| 84992|S |
| 7|Prg|SAPDB__S | 0|2004.12.17|10:47:44| 21504|S |
| 8|Prg|RSDBSPMC | 0|2007.02.16|12:48:48| 92160|S |
| 9|Typ|DDSHDESCR | 0|1997.11.28|16:26:30| 4096| |
| 10|Typ|SPPARAMS | 0|1997.03.07|14:48:48| 2048| |
| 11|Prg|SAPLSABE | 11|2004.12.17|10:47:44| 14336|S |
| 12|Prg|SAPLSECU | 12|2009.02.05|08:01:12| 96256|S |
| 13|Typ|RSSUBINFO | 0|2000.01.28|04:14:21| 3072| |
| 14|Prg|SAPLSTUP | 14|2009.02.05|07:56:32| 86016|S |
| 15|Prg|SAPLCNDP | 15|2009.02.05|08:00:38| 227328|S |
| 16|Prg|SAPLSCNT | 16|2005.02.19|11:28:30| 34816|S |
| 17|Prg|SAPSHDTV | 16|2005.01.15|19:29:56| 37888|S |
| 18|Prg|SAPFGUICNTL | 1|2005.02.19|11:28:11| 27648|S |
| 19|Prg|SAPLOLEA | 19|2009.04.19|02:45:37| 110592|S |
| 20|Prg|SAPLSGUI | 20|2009.02.05|08:21:15| 100352|S |
| 21|Prg|SAPLSTTM | 21|2005.06.27|10:18:45| 79872|S |
| 22|Prg|SAPLSBDC | 22|2009.02.05|07:57:06| 49152|S |
| 23|Prg|SAPLSFES | 23|2009.02.05|08:36:07| 303104|S |
| 24|Prg|SAPLTHFB | 24|2009.02.05|08:35:24| 455680|S |
| 25|Typ|WPINFO | 0|1999.02.08|14:18:32| 6144| |
| 26|Prg|SAPLURFC | 26|2009.02.05|08:18:06| 25600|S |
| 27|Prg|SAPLSPLUGIN | 27|2004.12.17|10:47:45| 10240|S |
| 28|Typ|SWCBCONT | 0|1997.10.07|12:13:50| 3072| |
| 29|Typ|OLE_VERBS | 0|1995.02.09|13:23:37| 2048| |
| 30|Typ|OLE_PA | 0|1995.01.13|11:06:59| 2048| |
| 31|Typ|TFDIR | 0|2005.01.15|20:46:20| 3072| |
| 32|Prg|SAPLCRM_SERVICE_ROB_DU | 32|2009.08.16|03:09:58| 337920|S |
| 33|Typ|CRMD_SRV_OSSET | 0|2001.02.20|10:36:33| 3072| |
| 34|Prg|SAPLCRM_ORDERADM_H_DU | 34|2009.08.16|03:09:54| 328704|S |
| 35|Typ|CRMD_ORDERADM_H | 0|2007.02.16|13:20:18| 8192| |
| 36|Prg|CX_SY_OPEN_SQL_DB=============CP | 36|2005.06.27|10:18:45| 13312|S |
| 37|Prg|CX_SY_OPEN_SQL_ERROR==========CP | 37|2005.06.27|10:18:45| 11264|S |
| 38|Prg|CX_SY_SQL_ERROR===============CP | 38|2005.06.27|10:18:45| 11264|S |
| 39|Prg|CX_DYNAMIC_CHECK==============CP | 39|2005.06.27|10:18:45| 10240|S |
| 40|Prg|CX_ROOT=======================CP | 40|2007.08.13|18:56:38| 13312|S |
| 41|Prg|CX_NO_CHECK===================CP | 41|2005.06.27|10:18:45| 10240|S |
| 42|Prg|CX_SY_NO_HANDLER==============CP | 42|2005.06.27|10:18:45| 11264|S |
| 43|Typ|SYST | 0|2004.12.16|20:31:11| 30720| |
| 44|Prg|%_CSYDB0 | 0|2005.02.19|11:28:27| 40960|S |
| 45|Typ|RSVAMEMKEY | 0|1996.12.16|19:31:50| 2048| |
| 46|Prg|%_CRSDS | 0|2005.02.19|11:28:17| 11264|S |
| 47|Prg|%_CSLIS | 12|2006.03.30|16:06:50| 93184|S |
| 48|Typ|DTC_S_LAYO | 0|2001.01.19|18:50:00| 7168| |
| 49|Typ|CAT_SVARS | 0|2004.10.05|16:20:04| 3072| |
| 50|Typ|RSJOBINFO | 0|1995.02.09|13:25:17| 3072| |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Directory of Application Tables |
----------------------------------------------------------------------------------------------------
|Name Date Time Lngth |
| Val. |
----------------------------------------------------------------------------------------------------
|Program SAPMSSY4 |
----------------------------------------------------------------------------------------------------
|SYST 2004.12.16 20:31:11 00004612 |
| \0\0\0\0\0\x0002\0\x000A\0\0\0\0\0\0\0\0\0\0\0\0\0\ x0001\0 |
|SY . . : : 00004612 |
| \0\0\0\0\0\x0002\0\x000A\0\0\0\0\0\0\0\0\0\0\0\0\0\ x0001\0 |
|RSJOBINFO . . : : 00000164 |
| 00000000000000 |
|TFDIR . . : : 00000268 |
| CRM_ORDERADM_H_UPDATE_DU SAPLCRM_ORDERADM_H_DU |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|ABAP Control Blocks (CONT) |
----------------------------------------------------------------------------------------------------
|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|S ource Code |Line |
----------------------------------------------------------------------------------------------------
| 46|----|00|0000| | | | | | |<SYSINI> | 56|
| 47|FUNP|3D|0000|0011|4003|0000|8003|0000|0000|LCRM _ORDERADM_H_DUU01 | 1|
| 51|FUNP|3D|0000|0010|4002|0000|8002|0000|0000|LCRM _ORDERADM_H_DUU01 | 1|
| 55|FUNP|3D|0000|000E|4000|0000|8000|0000|0000|LCRM _ORDERADM_H_DUU01 | 1|
| 59|FUNP|3D|0000|000F|4001|0000|8001|0000|0000|LCRM _ORDERADM_H_DUU01 | 1|
| 63|FUNP|80|0000|0000|0000|0000|0000|0000|0000|LCRM _ORDERADM_H_DUU01 | 1|
| 67|CMPS|20|02DD|4000|4000| | | | |LCRM_ORDERADM_H_DUU01 | 30|
| 69|BRAF|05|0027| | | | | | |LCRM_ORDERADM_H_DUU01 | 30|
| 70|SQLS|0B|0000| | | | | | |LCRM_ORDERADM_H_DUU01 | 31|
| 71|SQLS|06|0012| | | | | | |LCRM_ORDERADM_H_DUU01 | 31|
| 72|PAR1|00|0180| | | | | | |LCRM_ORDERADM_H_DUU01 | 31|
| 73|SQLS|39|09D1| | | | | | |LCRM_ORDERADM_H_DUU01 | 31|
|>>>>>|SQLS|0F|4000| | | | | | |LCRM_ORDERADM_H_DUU01 | 31|
| 75|cmpr|00|00E2|0181|0000| | | | |LCRM_ORDERADM_H_DUU01 | 32|
| 77|BRAF|05|000F| | | | | | |LCRM_ORDERADM_H_DUU01 | 32|
| 78|MOVL|00|0002|0182|0014| | | | |LCRM_ORDERADM_H_DUU01 | 33|
| 80|mlq1|02|0500|0F50|0041| | | | |LCRM_ORDERADM_H_DUU01 | 33|
| 82|MOVL|00|0008|0183|0013| | | | |LCRM_ORDERADM_H_DUU01 | 33|
| 84|DWRI|01|0184| | | | | | |LCRM_ORDERADM_H_DUU01 | 33|
| 85|WRIT|00|0185| | | | | | |LCRM_ORDERADM_H_DUU01 | 33|
----------------------------------------------------------------------------------------------------
| Reply to this email to post your response. __.____._ |   _.____.__ |
