|
Возник вот такой дамп.
Как я понимаю пытается пихнуть в таблицу две записи с одинаковым первичным ключом. Может кто сталкивался, ибо это стандарт и как-то странно.
P.S. У меня не получислось с отладчиком дойти до дточки дампа.
Динамическая ошибка SAPSQL_ARRAY_INSERT_DUPREC
ОсобСит CX_SY_OPEN_SQL_DB
Дата и время 28.03.2011 15:16:43
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Краткий текст |
| The ABAP/4 Open SQL array insert results in duplicate database records. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Анализ ошибки |
| 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 "BUFFER_UPDATE" "(FORM)", 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.) |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Указания по устранению ошибки |
| Use an ABAP/4 Open SQL array insert only if you are sure that none of |
| the records passed already exists in the database. |
| |
| You may able to find an interim solution to the problem |
| in the SAP note system. If you have access to the note system yourself, |
| please use the following search criteria: |
| |
| "SAPLGLO_UPDATE_ASSET_DATA" "SAPSQL_ARRAY_INSERT_DUPREC" |
| |
| If you cannot solve the problem yourself, please send the |
| following documents to SAP: |
| |
| 1. A hard copy print describing the problem. |
| To obtain this, select the "Print" function on the current screen. |
| - |
| |
| 2. A suitable hardcopy prinout of the system log. |
| To obtain this, call the system log with Transaction SM21 |
| and select the "Print" function to print out the relevant |
| part. |
| |
| 3. If the programs are your own programs or modified SAP programs, |
| supply the source code. |
| To do this, you can either use the "PRINT" command in the editor or |
| print the programs using the report RSINCL00. |
| |
| 4. Details regarding 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 |
| "BUFFER_UPDATE" "(FORM)", or its possible occurrence must be declared in the |
| RAISING clause of the procedure. |
| To prevent the exception, note the following: |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Информация о месте прерывания |
| Termination occurred in the ABAP program "SAPLGLO_UPDATE_ASSET_DATA" - in |
| "BUFFER_UPDATE". |
| The main program was "RSM13000 ". |
| |
| In the source code you have the termination point in line 20 |
| of the (Include) program "LGLO_UPDATE_ASSET_DATAF01". |
| The program "SAPLGLO_UPDATE_ASSET_DATA" was started in the update system. |
| The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in |
| procedure "BUFFER_UPDATE" "(FORM)", but it was neither handled locally nor |
| declared |
| in the RAISING clause of its signature. |
| |
| The procedure is in program "SAPLGLO_UPDATE_ASSET_DATA "; its source code |
| begins in line |
| 12 of the (Include program "LGLO_UPDATE_ASSET_DATAF01 ". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Фрагмент исходного текста программы |
----------------------------------------------------------------------------------------------------
|Строк|ИсхднТкст |
----------------------------------------------------------------------------------------------------
| 1|*----------------------------------------------------------------------* |
| 2|***INCLUDE LFAA_UPDATE_ASSET_DATAF01 . |
| 3|*----------------------------------------------------------------------* |
| 4|*&---------------------------------------------------------------------* |
| 5|*& Form buffer_update |
| 6|*&---------------------------------------------------------------------* |
| 7|* text |
| 8|*----------------------------------------------------------------------* |
| 9|* --> p1 text |
| 10|* <-- p2 text |
| 11|*----------------------------------------------------------------------* |
| 12|FORM buffer_update. |
| 13| IF gt_buffer_d IS NOT INITIAL. |
| 14| DELETE GLOFAAASSETDATA FROM TABLE gt_buffer_d. |
| 15|* Assert, that update was successful |
| 16| ASSERT ID faa_db_update |
| 17| CONDITION sy-subrc EQ 0. |
| 18| ENDIF. |
| 19| IF gt_buffer_i IS NOT INITIAL. |
|>>>>>| INSERT GLOFAAASSETDATA FROM TABLE gt_buffer_i. |
| 21|* Assert, that update was successful |
| 22| ASSERT ID faa_db_update |
| 23| CONDITION sy-subrc EQ 0. |
| 24| ENDIF. |
| 25| IF gt_buffer_u IS NOT INITIAL. |
| 26| MODIFY GLOFAAASSETDATA FROM TABLE gt_buffer_u. "N929720 |
| 27|* Assert, that update was successful |
| 28| ASSERT ID faa_db_update |
| 29| CONDITION sy-subrc EQ 0. |
| 30| ENDIF. |
| 31| PERFORM buffer_clear. |
| 32|ENDFORM. " buffer_update |
| 33|*&---------------------------------------------------------------------* |
| 34|*& Form buffer_clear |
| 35|*&---------------------------------------------------------------------* |
| 36|* text |
| 37|*----------------------------------------------------------------------* |
| 38|* --> p1 text |
| 39|* <-- p2 text |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Содержимое системных полей |
----------------------------------------------------------------------------------------------------
|Имя |Знач |
----------------------------------------------------------------------------------------------------
|SY-SUBRC|0 |
|SY-INDEX|0 |
|SY-TABIX|2 |
|SY-DBCNT|0 |
|SY-FDPOS|0 |
|SY-LSIND|0 |
|SY-PAGNO|0 |
|SY-LINNO|1 |
|SY-COLNO|1 |
|SY-PFKEY| |
|SY-UCOMM| |
|SY-TITLE|Update control |
|SY-MSGTY| |
|SY-MSGID| |
|SY-MSGNO|000 |
|SY-MSGV1| |
|SY-MSGV2| |
|SY-MSGV3| |
|SY-MSGV4| |
|SY-MODNO|0 |
|SY-DATUM|20110328 |
|SY-UZEIT|151638 |
|SY-XPROG|SAPLGIVA |
|SY-XFORM|XAB_READ |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Активные вызовы/события |
----------------------------------------------------------------------------------------------------
|№ Вид Программа Include Строк |
| Имя |
----------------------------------------------------------------------------------------------------
| 6 FORM SAPLGLO_UPDATE_ASSET_DATA LGLO_UPDATE_ASSET_DATAF01 20 |
| BUFFER_UPDATE |
| 5 FORM SAPMSSY0 SAPMSSY0 472 |
| %_PROCESS_P_O_C |
| 4 FORM SAPMSSY0 SAPMSSY0 246 |
| %_COMMIT |
| 3 FORM RSM13000 RSM13000 5274 |
| VB_V1_EXEC |
| 2 FORM RSM13000 RSM13000 3952 |
| VB_V1_NORMAL |
| 1 MODULE (PBO) RSM13000 RSM13000 3801 |
| VBEXEC |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Выбранные переменные |
----------------------------------------------------------------------------------------------------
|Имя |
| Знач |
----------------------------------------------------------------------------------------------------
|№ 6 Вид FORM |
|Имя BUFFER_UPDATE |
----------------------------------------------------------------------------------------------------
|GT_BUFFER_D |
| Table[initial] |
|%_ARCHIVE |
| |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|FAACA_OPERATION-UPDATE |
| U |
| 0 |
| 0 |
| 5 |
| 5 |
|<%_TABLE_GLOFAAASSETDATA> |
| ??? |
| ?????? |
| ?????? |
|%_SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|FAACA_OPERATION-DELETE |
| D |
| 0 |
| 0 |
| 4 |
| 4 |
|SY-SUBRC |
| 0 |
| 0000 |
| 0000 |
|SYST-REPID |
| SAPLGLO_UPDATE_ASSET_DATA |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454444555445454554554454222222222222222 |
| 310C7CFF504145F13354F4141000000000000000 |
|GT_BUFFER_I |
| Table IT_94[2x464] |
| \FUNCTION-POOL=GLO_UPDATE_ASSET_DATA\DATA=GT_BUFFER_I |
| Table reference: 1 |
| TABH+ 0(20) = 0000000106CF81E8000000000000000000000000 |
| TABH+ 20(20) = 000000010000005E00000002000001D0FFFFFFFF |
| TABH+ 40(16) = 04000062000003E00010249401800000 |
| store = 0x0000000106CF81E8 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 1 (0x00000001) |
| label = 94 (0x0000005E) |
| fill = 2 (0x00000002) |
| leng = 464 (0x000001D0) |
| loop = -1 (0xFFFFFFFF) |
| xtyp = TYPE#000006 |
| occu = 16 (0x00000010) |
| access = 1 (ItAccessStandard) |
| idxKind = 0 (ItIndexNone) |
| uniKind = 2 (ItUniqueNon) |
| keyKind = 1 (default) |
| cmpMode = 2 (cmpSingleMcmpR) |
| occu0 = 1 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 0 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| gcKind = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| >>>>> Shareable Table Header Data <<<<< |
| tabi = 0x0000000106C9F978 |
| pgHook = 0x0000000000000000 |
| idxPtr = 0x0000000000000000 |
| shmTabhSet = 0x0000000000000000 |
| id = 46 (0x0000002E) |
| refCount = 0 (0x00000000) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 16 (0x00000010) |
| lineAlloc = 16 (0x00000010) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 1 (0x00000001) |
| >>>>> 1st level extension part <<<<< |
| regHook = Not allocated |
| collHook = Not allocated |
| ext2 = Not allocated |
| >>>>> 2nd level extension part <<<<< |
| tabhBack = Not allocated |
| delta_head = Not allocated |
| pb_func = Not allocated |
| pb_handle = Not allocated |
|GT_BUFFER_U |
| Table[initial] |
----------------------------------------------------------------------------------------------------
|№ 5 Вид FORM |
|Имя %_PROCESS_P_O_C |
----------------------------------------------------------------------------------------------------
|IMODE_ORDERS |
| Table[initial] |
|IMODE_ORDERS_WA |
| #### |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 2222222222222222222222222222222222222222222222222222222222222222222222220000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000 |
|SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SYST-REPID |
| SAPMSSY0 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454555322222222222222222222222222222222 |
| 310D339000000000000000000000000000000000 |
|IMODE_ORDERS_WA-PROG |
| |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 2222222222222222222222222222222222222222 |
| 0000000000000000000000000000000000000000 |
|IMODE_ORDERS_WA-ROUT |
| |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 22222222222222222222222222222222 |
| 00000000000000000000000000000000 |
|IMODE_ORDERS_WA-U_LEVEL |
| 0 |
| 0000 |
| 0000 |
|ORDERS |
| Table IT_45[19x152] |
| \PROGRAM=SAPMSSY0\DATA=ORDERS |
| Table reference: 40 |
| TABH+ 0(20) = 0000000106CAF778000000000000000000000000 |
| TABH+ 20(20) = 000000280000002D000000130000009800000000 |
| TABH+ 40(16) = 0400003F0000092000102C9401800000 |
| store = 0x0000000106CAF778 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 40 (0x00000028) |
| label = 45 (0x0000002D) |
| fill = 19 (0x00000013) |
| leng = 152 (0x00000098) |
| loop = 0 (0x00000000) |
| xtyp = TYPE#000034 |
| occu = 16 (0x00000010) |
| access = 1 (ItAccessStandard) |
| idxKind = 1 (ItIndexLinear) |
| uniKind = 2 (ItUniqueNon) |
| keyKind = 1 (default) |
| cmpMode = 2 (cmpSingleMcmpR) |
| occu0 = 1 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 0 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| gcKind = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| >>>>> Shareable Table Header Data <<<<< |
| tabi = 0x0000000106CCAC38 |
| pgHook = 0x0000000106ED6CA0 |
| idxPtr = 0x0000000106E6ACB0 |
| shmTabhSet = 0x0000000000000000 |
| id = 24 (0x00000018) |
| refCount = 0 (0x00000000) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 48 (0x00000030) |
| lineAlloc = 48 (0x00000030) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 1 (0x00000001) |
| >>>>> 1st level extension part <<<<< |
| regHook = Not allocated |
| collHook = Not allocated |
| ext2 = Not allocated |
| >>>>> 2nd level extension part <<<<< |
| tabhBack = Not allocated |
| delta_head = Not allocated |
| pb_func = Not allocated |
| pb_handle = Not allocated |
|%_LIST |
| Table[initial] |
|%_FMBS |
| Table[initial] |
|SAVE_VBPARAM |
| # |
| 0 |
| 3 |
|TH_ARFC_RES_LOCAL_LOW_MAXCOMM |
| # |
| 1 |
| 5 |
|OPCODE_VMC_GET_EXT_TIMER_STATE |
| % |
| 2 |
| 5 |
|ORDERS_WA |
| SAPLGLO_UPDATE_ASSET_DATA BUFFER_UPDATE #### |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 5454444555445454554554454222222222222222454445555445422222222222222222220000 |
| 310C7CFF504145F13354F4141000000000000000256652F50414500000000000000000000001 |
|ORDERS_WA-PROG |
| SAPLGLO_UPDATE_ASSET_DATA |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5454444555445454554554454222222222222222 |
| 310C7CFF504145F13354F4141000000000000000 |
|ORDERS_WA-ROUT |
| BUFFER_UPDATE |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 45444555544542222222222222222222 |
| 256652F5041450000000000000000000 |
|OS_ORDERS |
| Table[initial] |
----------------------------------------------------------------------------------------------------
|№ 4 Вид FORM |
|Имя %_COMMIT |
----------------------------------------------------------------------------------------------------
|OPCODE_VMC_STOP_EXT_TIMER |
| $ |
| 2 |
| 4 |
|SY-ONCOM |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|OPCODE_CREATE_MODE |
| # |
| 1 |
| 7 |
|GET_VB_KEY |
| # |
| 0 |
| 2 |
|%%VBKEY-VBKEY |
| 4D8CA4669C0A0F6BE1000000C0A8091E |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 34344333343434344333333343433334 |
| 44831466930106625100000030180915 |
|VB_RUN_V1 |
| 246 |
| 000F |
| 0006 |
|%_ARCHIVE |
| |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|OPCODE_ACTIVATE_RES_CHECK |
| J |
| 4 |
| A |
|%_STATE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|%_VB_CALLS[] |
| Table[initial] |
|SY-SUBRC |
| 0 |
| 0000 |
| 0000 |
|%%VBKEY |
| %%4D8CA4669C0A0F6BE1000000C0A8091E |
| 0000000000000000000000000000000000 |
| 0000000000000000000000000000000000 |
| 2234344333343434344333333343433334 |
| 5544831466930106625100000030180915 |
|TH_WPSTATE |
| # |
| 0 |
| 0 |
|%_SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SCREEN |
| |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|VB_ERR_OFFSET |
| 100 |
| 0006 |
| 0004 |
|L_LINES |
| 0 |
| 0000 |
| 0000 |
----------------------------------------------------------------------------------------------------
|№ 3 Вид FORM |
|Имя VB_V1_EXEC |
----------------------------------------------------------------------------------------------------
|ELOG |
| ELOG |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 4444222222222222222222222222222222222222222222222222222222222222222222 |
| 5CF7000000000000000000000000000000000000000000000000000000000000000000 |
|VBHDR-VBKEY |
| 4D8FF061B1DE6862E1000000C0A8091E |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 34344333434433334333333343433334 |
| 44866061214568625100000030180915 |
|MTUS |
| MUS |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 4552222222222222222222222222222222222222222222222222222222222222222222 |
| D530000000000000000000000000000000000000000000000000000000000000000000 |
|%_SPACE |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|TH_FALSE |
| # |
| 0 |
| 0 |
|%_DUMMY$$ |
| |
| 0000 |
| 0000 |
| 2222 |
| 0000 |
|VB_START_COMMIT |
| # |
| 1 |
| E |
|OFF |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|SY-ONCOM |
| |
| 0 |
| 0 |
| 2 |
| 0 |
|VB_COMMIT_PROCESSED |
| # |
| 1 |
| F |
|MTRP |
| MRP |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 4552222222222222222222222222222222222222222222222222222222222222222222 |
| D200000000000000000000000000000000000000000000000000000000000000000000 |
|VBHDR |
| 4D8FF061B1DE6862E1000000C0A8091E330101DIT00004 SAPLBAPT |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 3434433343443333433333334343333433333344533333222222222222254544455222222222222222222222222222|
| 44866061214568625100000030180915330101494000040000000000000310C2104000000000000000000000000000|
|OFFICE_TASO00 |
| SO00 |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000 |
| 5433222222222222222222222222222222222222222222222222222222222222222222 |
| 3F00000000000000000000000000000000000000000000000000000000000000000000 |
----------------------------------------------------------------------------------------------------
 |
|
Вход
Регистрация
FAQ пользователя
Поиск
