SAP Knowledge Base Article - Preview

1841098 - MERGE SQL statement raises error 12319 "Fatal internal error encountered during deferred dml on table..." - SAP ASE for Business Suite

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

SAP Adaptive Server Enterprise 15.7

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.