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 , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.