Symptom
Error 12319 is raised in the ASE errorlog during the execution of a MERGE SQL statement:
00:0013:00000:02375:2013/03/06 12:09:23.61 server Error: 12319, Severity: 20, State: 13
00:0013:00000:02375:2013/03/06 12:09:23.61 server Fatal internal error encountered during deferred dml on table 'BSP_DL_STXTELEM' in database 'SID'. All rows that qualified during the first phase were not visited during second phase of dml.
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel ************************************
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel SQL causing error : ^K^BB8
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel Current statement number: 1 Current line number: 1
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel ************************************
00:0013:00000:02375:2013/03/06 12:09:23.61 server SQL Text: MERGE INTO "BSP_DL_STXTELEM" AS T1 USING ( SELECT ? , ? ) AS T2 ("CONTEXT_ID", "ELEMENT_ID") O
N ( T1."CONTEXT_ID" = T2."CONTEXT_ID" AND T1."ELEMENT_ID" = T2."ELEMENT_ID" ) WHEN NOT MATCHED THEN INSERT ("CONTEXT_ID", "ELEMENT_ID") VALUES (T2."CONTEXT
_ID", T2."ELEMENT_ID") WHEN MATCHED THEN UPDATE SET "CONTEXT_ID" = T2."CONTEXT_ID" /* R3:CL_AI_CRM_BP_HELPER===========CP:557 T:BSP_DL_STXTELEM M:001 */
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel curdb = 4 tempdb = 6 pstat = 0x10100 p2stat = 0x20101000
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x0 p7stat = 0x10000
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel lasterror = 12319 preverror = 0 transtate = 0
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel curcmd = 197 program = R3D21 comm rd ODBC
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel extended error information: hostname: XXX login: SAPSR3
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x00000000014b01db pcstkwalk+0x3a3()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x00000000014afcb3 ucstkgentrace+0x263()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x00000000014abc2e ucbacktrace+0x50()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x0000000000779017 terminate_process+0x9b7()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x000000000117e4c6 hdl_default+0x3b()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x000000000111f961 s_handle+0xa51()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x000000000117d5af ex_raise+0x23f()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x0000000001735b94 dol_def_update+0x454()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x0000000001735013 dodeferred+0x153()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x0000000000f62bf4 exec_ri_deferred+0x15()
00:0013:00000:02375:2013/03/06 12:09:23.61 kernel pc: 0x00000000007ebc8c LeDMLOp::_LeOpClose(ExeCtxt&)+0x18c()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x0000000001702fd9 LeMergeStmtOp::_LeOpClose(ExeCtxt&)+0x113()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007efb34 LeEmittOp::_LeOpClose(ExeCtxt&)+0x64()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007e5394 LePlanClose+0x84()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel [Handler pc: 0x0x0000000000f59cd0 le_execerr installed by the following function:-]
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x0000000000f64cd8 exec_lava+0x258()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x000000000116ebb5 s_xoltp_dml+0x166b()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel [Handler pc: 0x0x000000000117da50 hdl_stack installed by the following function:-]
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel [Handler pc: 0x0x000000000111ef10 s_handle installed by the following function:-]
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x0000000001122b9d sequencer+0x18dd()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007c0f2c tdsrecv__dynexec_xoltp+0x335()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007be109 tdsrecv__dynexec+0x253()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007bc8d4 tdsrecv_dynamic+0xf9()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel [Handler pc: 0x0x000000000140dc10 ut_handle installed by the following function:-]
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel pc: 0x00000000007d63e5 conn_hdlr+0x1be5()
00:0013:00000:02375:2013/03/06 12:09:23.63 kernel end of stack trace, spid 2375, kpid 730793483, suid 6
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 ESD #4.2 for Business Suite
Product
Keywords
"MERGE Anweisung", "Fehler 12319", CR713572, 713572 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
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