Fixing system tables in the master database after a change of Characterset / SortOrder

From SybaseWiki
Revision as of 14:25, 10 March 2006 by Psap (Talk | contribs) (Fixing system tables in the master database after a change of Characterset/SortOrder)

Jump to: navigation, search

Things about Adaptive Server Enterprise

Administration

Fixing system tables in the master database after a change of Characterset/SortOrder

When you have changed the characterset and/or sort order for a server it might be necesarry to fix a few system tables in the master database. When you have not done this, a stacktrace similiar to this one will be shown in the errorlog.

kernel ************************************ kernel SQL causing error : spt_ijdbc_mda kernel ************************************ server SQL Text: spt_ijdbc_mda kernel curdb = 1 pstat = 0x10000 lasterror = 614 kernel preverror = 0 transtate = 1 kernel curcmd = 326 program = isql kernel pc: 0x00000001208c5260 pcstkwalk+0x50() kernel pc: 0x00000001208c4fa0 ucstkgentrace+0x250() kernel pc: 0x0000000120830664 ucbacktrace+0x104() kernel pc: 0x00000001202cf084 terminate_process+0xbc4() kernel pc: 0x00000001203d6a58 hdl_default+0x68() kernel pc: 0x00000001205370e0 ut_handle+0x130() kernel pc: 0x0000000120324a34 ex_raise+0x364() kernel pc: 0x00000001201851e0 rowsize+0x270() kernel pc: 0x00000001205622b8 ups_main+0x10b8() kernel pc: 0x00000001202359a0 getnext+0x150() kernel pc: 0x00000001201dc3b8 ups_deadlock_getnext+0x28() kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x0000000120563630 ups_main+0x2430() kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x00000001205617bc ups_main+0x5bc() kernel pc: 0x00000001202817fc s_execute_cold_3+0x2bac() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel [Handler pc: 0x0000000120521ad0 hsm_memobjsize+0x10 installed by the following function:-] kernel pc: 0x000000012033f498 internal_sql+0x6a8() kernel pc: 0x0000000120280974 s_execute_cold_3+0x1d24() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x00000001202456c0 execproc+0x3c0() kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x00000001202456c0 execproc+0x3c0() kernel pc: 0x000000012027f4ec s_execute_cold_3+0x89c() kernel [Handler pc: 0x00000001205a0cc0 s_handle installed by the following function:-] kernel pc: 0x0000000120245280 sequencer+0x440() kernel pc: 0x0000000120172d28 tdsrecv_language+0x348() kernel [Handler pc: 0x00000001203d6520 hdl_backout installed by the following function:-] kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel [Handler pc: 0x0000000120536fb0 ut_handle installed by the following function:-] kernel pc: 0x000000012016f560 conn_hdlr_cold_347+0x830() kernel end of stack trace, spid 76, kpid 261554288, suid 30

hallo