SAP Knowledge Base Article - Preview

3666249 - Error Message 3949, "An illegal attempt was made to update '##tablename' in database 'tempdb' using a transaction that was started in database '<dbname>'

Symptom

  • Error Message 3949, "An illegal attempt was made to update '##tablename' in database 'tempdb' using a transaction that was started in database '<dbname>' (mode: 1, type: 0)." is reported to the SAP ASE Errorlog when running reorg reclaim_space, compact, forwarded_rows or defrag against a global temporary table. After this, a stack trace is reported.
  • On Unix platforms:
    • 00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000002a6717c pcstkwalk+0x35()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000002a66f2c ucstkgentrace+0x2fd()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000002a60424 ucbacktrace+0x120()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000000a597bf terminate_process+0x2167()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000022edf82 close_network+0x13()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000022eded4 hdl_default+0x51()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000002803f5f reorg_handler+0x168()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000022ebeaa exc__raise+0xbba()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000022eb2ee exc_raise+0x1ee()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000001b5f7c2 xact_beginupdate+0x1a0()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000027fb241 reorg_new_xact+0xd3a()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x0000000002803df7 reorg_handler installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000027f5aae reorg__ptn_rs+0x729()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x0000000002803df7 reorg_handler installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000027f7160 reorg__rs+0xb86()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x0000000002803df7 reorg_handler installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000027f5128 reorg_main+0x174a()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000021920fb s_execute+0xfbb2()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x00000000022ed0b5 hdl_stack installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x000000000221df11 s_handle installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x00000000022115b8 sequencer+0x3e37()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000000aca1b6 tdsrecv_language+0xe24()
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  [Handler pc: 0x0x0000000002945218 ut_handle installed by the following function:-]
      00:0033:00000:00028:2025/10/02 22:33:29.34 kernel  pc: 0x0000000000b05090 conn_hdlr+0x5301()


'"> Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

CR831286  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.