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.
SAP Knowledge Base Article - Preview