Difference between revisions of "Fixing system tables in the master database after a change of Characterset / SortOrder"

From SybaseWiki
Jump to: navigation, search
Line 480: Line 480:
 
[http://www.donx.de/blog/ballgowns/ ball gowns]
 
[http://www.donx.de/blog/ballgowns/ ball gowns]
 
[http://www.privetparis.com/blog/rtgcasinobonus/ rtg casino bonus]
 
[http://www.privetparis.com/blog/rtgcasinobonus/ rtg casino bonus]
 +
</div>
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
<div  style="display:none">
 +
[We are delicate. We do not delete your content.]
 +
[l_sp20]
 +
 +
 +
[http://www.buddyprofile.com/viewprofile.php?username=waterfordcrystal waterford crystal]
 +
[http://www.buddyprofile.com/viewprofile.php?username=swarovskicrystal swarovski crystal bead]
 +
[http://www.buddyprofile.com/viewprofile.php?username=mesotheliomalawsuits mesothelioma lawsuits]
 +
[http://www.buddyprofile.com/viewprofile.php?username=mesotheliomasymptoms mesothelioma symptoms]
 +
[http://www.buddyprofile.com/viewprofile.php?username=mesotheliomadiag mesothelioma diagnosis]
 +
[http://www.buddyprofile.com/viewprofile.php?username=wacoalbras wacoal bras]
 +
[http://www.buddyprofile.com/viewprofile.php?username=teenbra teen bra]
 +
[http://www.buddyprofile.com/viewprofile.php?username=unsecuredloan unsecured signature loan]
 +
[http://www.buddyprofile.com/viewprofile.php?username=homeloans Countrywide Home Loans]
 +
[http://blog.moddingplanet.it/?w=formalpromdresses Formal Prom Dresses]
 +
[http://blog.moddingplanet.it/?w=sexypromdress Sexy Prom Dress]
 +
[http://blog.moddingplanet.it/?w=cocktaildresses cocktail dresses]
 +
[http://www.buddyprofile.com/viewprofile.php?username=telmobile TMobile]
 +
[http://www.buddyprofile.com/viewprofile.php?username=watersoftener water softener]
 +
[http://www.buddyprofile.com/viewprofile.php?username=tanklesswaterheater tankless water heater]
 +
[http://www.buddyprofile.com/viewprofile.php?username=rockportshoes rockport shoes]
 +
[http://www.buddyprofile.com/viewprofile.php?username=osmosiswaterfilter reverse osmosis water filter]
 +
[http://www.buddyprofile.com/viewprofile.php?username=merrellshoes merrell shoes]
 +
[http://www.buddyprofile.com/viewprofile.php?username=oscardresses oscar dresses]
 +
[http://www.buddyprofile.com/viewprofile.php?username=easterdresses easter dresses]
 +
[http://flyfone.blox.pl/resource/flyfonevoip.htm flyfone voip]
 +
[http://www.buddyprofile.com/viewprofile.php?username=plussizepromdresses plus size prom dresses]
 +
[http://www.buddyprofile.com/viewprofile.php?username=discountpromdresses discount prom dresses]
 +
[http://blog.moddingplanet.it/?w=hooterscasinolas Hooters Casino Las Vegas]
 +
[http://blog.moddingplanet.it/?w=grandcasinomille grand casino mille lacs]
 +
[http://blog.moddingplanet.it/?w=lasvegascasino las vegas casino coupons]
 +
[http://blog.moddingplanet.it/?w=onlinepokeraide online poker aide]
 +
[http://www.donx.de/blog/pechangacasino pechanga casino]
 +
[http://www.donx.de/blog/grandvictoriacasino/ grand victoria casino]
 +
[http://www.donx.de/blog/ballgowns/ ball gowns]
 +
[http://www.privetparis.com/blog/rtgcasinobonus/ rtg casino bonus]
 +
 +
[http://blog.moddingplanet.it/?w=rtgcasinobonus rtg casino bonus]
 +
[http://blog.moddingplanet.it/?w=grandcasinocoushat grand casino coushatta]
 +
[http://blog.moddingplanet.it/?w=grandcasinohinckle grand casino hinckley]
 +
[http://blog.moddingplanet.it/?w=isleofcapricasino isle of capri casino]
 +
[http://blog.moddingplanet.it/?w=mohegansuncasino mohegan sun casino]
 +
[http://blog.moddingplanet.it/?w=palacasino pala casino]
 +
[http://blog.moddingplanet.it/?w=roulettewheels roulette wheels]
 +
[http://blog.moddingplanet.it/?w=winstarcasino winstar casino]
 +
[http://blog.moddingplanet.it/?w=cheappromdresses Cheap Prom Dresses]
 +
[http://blog.moddingplanet.it/?w=informalweddingdre informal wedding dresses]
 +
[http://blog.moddingplanet.it/?w=oscardresses oscar dresses]
 +
[http://blog.moddingplanet.it/?w=eveninggowns evening gowns]
 +
 +
[http://vvvvvv.blox.pl/resource/throat_pokers.htm throat pokers]
 +
[http://vvvvvv.blox.pl/resource/online_poker_assistant.htm online poker assistant]
 +
[http://vvvvvv.blox.pl/resource/online_poker_tracker.htm online poker tracker]
 +
[http://vvvvvv.blox.pl/resource/online_poker_aide.htm online poker aide]
 +
[http://vvvvvv.blox.pl/resource/party_poker_bonus.htm party poker bonus]
 +
[http://vvvvvv.blox.pl/resource/party_poker_bonus_code.htm party poker bonus code]
 +
[http://vvvvvv.blox.pl/resource/bonus_code_party_poker.htm bonus code party poker]
 +
[http://vvvvvv.blox.pl/resource/bonus_code_deposit_party_poker.htm bonus code deposit party poker]
 +
[http://vvvvvv.blox.pl/resource/party_poker_bonus_codes.htm party poker bonus codes]
 +
[http://vvvvvv.blox.pl/resource/carnival_cruises.htm carnival cruises]
 +
[http://vvvvvv.blox.pl/resource/carnival_game_rentals.htm carnival game rentals]
 +
[http://vvvvvv.blox.pl/resource/fuzzydice.htm fuzzy dice]
 +
[http://vvvvvv.blox.pl/resource/bingodaubers.htm bingo daubers]
 +
[http://vvvvvv.blox.pl/resource/bingoblowers.htm bingo blowers]
 +
[http://vvvvvv.blox.pl/resource/motor_scooters.htm motor scooters]
 +
[http://vvvvvv.blox.pl/resource/mini_harley_chopper_scooter.htm mini harley chopper scooter]
 +
[http://blog.moddingplanet.it/?w=fakerolex fake rolex]
 +
 +
[http://blog.moddingplanet.it/?w=bextravioxx bextra vioxx]
 +
[http://blog.moddingplanet.it/?w=zocor zocor]
 +
[http://blog.moddingplanet.it/?w=zithromax zithromax]
 +
[http://blog.moddingplanet.it/?w=bextralawyernew bextra lawyer new hampshire]
 +
[http://blog.moddingplanet.it/?w=akanesoma akane soma]
 +
[http://blog.moddingplanet.it/?w=kyosoma kyo soma]
 +
[http://blog.moddingplanet.it/?w=prozacnation prozac nation]
 +
[http://blog.moddingplanet.it/?w=prozacwithdrawal prozac withdrawal]
 +
[http://blog.moddingplanet.it/?w=simslots sim slots]
 +
[http://blog.moddingplanet.it/?w=pachisloslotmachine pachislo slot machines]
 +
[http://blog.moddingplanet.it/?w=programcherries program cherries wild slot machine]
 +
[http://blog.moddingplanet.it/?w=slotcarracing slot car racing]
 +
[http://blog.moddingplanet.it/?w=hoslotcars ho slot cars]
 +
 +
[http://blog.moddingplanet.it/?w=bingocages bingo cages]
 +
[http://blog.moddingplanet.it/?w=bingodaubers bingo daubers]
 +
[http://blog.moddingplanet.it/?w=bingoblowers bingo blowers]
 +
[http://blog.moddingplanet.it/?w=bingobags bingo bags]
 +
[http://blog.moddingplanet.it/?w=baccaratcrystal baccarat crystal]
 +
[http://blog.moddingplanet.it/?w=nexium nexium]
 +
[http://blog.moddingplanet.it/?w=onlinepaigowpoker online pai gow poker]
 +
[http://blog.moddingplanet.it/?w=leighkeno leigh keno]
 +
 +
[http://www.privetparis.com/blog/tramadol50mg/ tramadol 50mg]
 +
[http://www.privetparis.com/blog/tramadolsaturdaydelivery/ tramadol saturday delivery]
 +
[http://www.privetparis.com/blog/tramadoler/ tramadol er]
 +
[http://www.privetparis.com/blog/tramadolsales/ tramadol sales]
 +
[http://www.privetparis.com/blog/tramadolhcl50mg/ tramadol hcl 50 mg]
 +
[http://www.privetparis.com/blog/120tramadoll/ 120 tramadol]
 +
[http://www.privetparis.com/blog/acetaminophenhclpartramadol/ acetaminophen hcl par tramadol]
 +
[http://blog.moddingplanet.it/?w=plussizemother plus size mother of the bride dresses]
 +
[http://blog.moddingplanet.it/?w=cheapflowergirl cheap flower girl dresses]
 +
[http://blog.moddingplanet.it/?w=discountflowergirl discount flower girl dresses]
 +
[http://blog.moddingplanet.it/?w=infantflowergirl infant flower girl dresses]
 +
[http://blog.moddingplanet.it/?w=bridalflowergirl bridal flower girl dresses]
 
</div>
 
</div>

Revision as of 01:48, 27 May 2006

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. Running "update index statistics" on tables in the master database seem to raise this stacktrace.

server  Error: 614, Severity: 21, State: 7
server  Adaptive Server accessed a row that has an illegal length of 16640 while in data base 'master'. Page pointer = 0x1abe59800, pageno = 1098, status = 0x2, objectid = 224000798, indexid = 2, level = 0. The minimum row length is 13. The page size is 2048.
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

To resolve this issue you to run the following commands in the master database:

dbcc reindex(spt_ijdbc_mda)
dbcc reindex(spt_mda)
dbcc reindex(spt_jtext)

When you reindex spt_jext and the following error is raised:

Msg 7952, Level 16, State 1:
Server 'xxx', Line 1:
A TEXT value with an invalid MAGIC NUMBER has been found on page 2370. TEXT values will no longer be checked for this table. Note because of this, the TEXT page count will be inaccurate. Use DBCC FIX_TEXT to fix the TEXT values.

you need to run this: dbcc fix_text(spt_jtext)

All these dbcc commands can be run while users are active in the server. Currently it is not known what ASE versions, character set or sort orders causes these problems.













[We are delicate. We do not delete your content.] [l_sp91] indoor tanning beds daybed comforter sets southwestern bedding leather sectional sofa thomasville bedding naturalizer shoes designer dog beds k1 visa fiancee visa rivotril cingular ringtone nail fungus bridesmaid dress formal prom dresses bcbg shoes tramadol hcl cingular ringtone bcbg shoes bridesmaid dress formal prom dresses nail fungus tanning bed bcbg shoes naturalizer shoes leather sectional sofa designer dog beds heated mattress pad bridesmaid dress 2006 prom dresses formal prom dresses sexy prom dresses cheap prom dresses nextel ringtone verizon ringtone cingular ringtone free sprint ringtone free nextel ringtone dianabol tribulus terrestris nutrex lipo 6 Tribex Xyience Vasopro caffeine pills scifit twinlab faxless payday loans











[We are delicate. We do not delete your content.] [l_sp894] indoor tanning beds daybed comforter sets southwestern bedding leather sectional sofa thomasville bedding naturalizer shoes designer dog beds k1 visa fiancee visa rivotril cingular ringtone nail fungus bridesmaid dress formal prom dresses bcbg shoes tramadol hcl cingular ringtone bcbg shoes bridesmaid dress formal prom dresses nail fungus tanning bed bcbg shoes naturalizer shoes leather sectional sofa designer dog beds heated mattress pad bridesmaid dress 2006 prom dresses formal prom dresses sexy prom dresses cheap prom dresses nextel ringtone verizon ringtone cingular ringtone free sprint ringtone free nextel ringtone sprint ringtones verizon ringtone dianabol tribulus terrestris nutrex lipo 6 Tribex Xyience Vasopro caffeine pills scifit twinlab faxless payday loans ringtone maker cash until pay day loan faxless payday loans no fax payday loans fash cash personal loans









[We are delicate. We do not delete your content.] [l_sp2006] http://top20man.in.ua/black-eyed-peas-mp3 black eyed peas mp3] madonna mp3 eminem mp3 ringtone maker godsmack awake godsmack voodoo sean paul temperature sean paul we be burnin bad day daniel powter system of a down mp3 sean paul mp3 metallica mp3 shakira mp3 rascal flatts what hurts the most rascal flatts bless the broken road red hot chili peppers under the bridge james blunt wisemen bad day daniel powter godsmack mp3 godsmack i stand alone goodbye my lover james blunt [fall out boy grand theft autumn jack johnson mp3 natasha bedingfield unwritten 50 cent mp3 nextel ringtone bad day daniel powter daniel powter mp3 verizon ringtone US Cellular Ringtone free sprint ringtone verizon ringtone verizon ringtone bcbg shoes free sprint ringtones cheap prom dresses sexy prom dresses











[We are delicate. We do not delete your content.] [l_sp2008]

ringtone maker verizon ringtone US Cellular Ringtone bcbg shoes waterford crystal swarovski crystal bead mesothelioma lawsuits mesothelioma symptoms mesothelioma diagnosis Naturalizer Shoes Free Kyocera Ringtone Sexy Prom Dresses Naturalizer Shoes Aero Bed Free Sprint Ringtones Free Verizon Ringtones free nextel ringtones sexy prom dress Formal Prom Dresses cheap prom dresses Plus Size Prom Dresses tiffany prom dresses erotic games strip poker pokemon trading card game rom hoyle card games buy ativan online buy ativan buy alprazolam online buy alprazolam cheap tramadol buy bontril online fentermine how to buy fioricet on line cheap ultram without prescription buy ultram without prescription teen bra Bra Teen Cleavage Micro Bikini Teens Bra sexy bras bulma bra sheer bra auto loan calculator Federal Student Loan Consolidation private student loan consolidation acs student loans countrywide home loans refinance home loan st louis wacoal bras teen bra unsecured signature loan Countrywide Home Loans
































[We are delicate. We do not delete your content.] [l_sp20]


waterford crystal swarovski crystal bead mesothelioma lawsuits mesothelioma symptoms mesothelioma diagnosis wacoal bras teen bra unsecured signature loan Countrywide Home Loans Formal Prom Dresses Sexy Prom Dress cocktail dresses TMobile water softener tankless water heater rockport shoes reverse osmosis water filter merrell shoes oscar dresses easter dresses flyfone voip plus size prom dresses discount prom dresses Hooters Casino Las Vegas grand casino mille lacs las vegas casino coupons online poker aide pechanga casino grand victoria casino ball gowns rtg casino bonus

rtg casino bonus grand casino coushatta grand casino hinckley isle of capri casino mohegan sun casino pala casino roulette wheels winstar casino Cheap Prom Dresses informal wedding dresses oscar dresses evening gowns

throat pokers online poker assistant online poker tracker online poker aide party poker bonus party poker bonus code bonus code party poker bonus code deposit party poker party poker bonus codes carnival cruises carnival game rentals fuzzy dice bingo daubers bingo blowers motor scooters mini harley chopper scooter fake rolex

bextra vioxx zocor zithromax bextra lawyer new hampshire akane soma kyo soma prozac nation prozac withdrawal sim slots pachislo slot machines program cherries wild slot machine slot car racing ho slot cars

bingo cages bingo daubers bingo blowers bingo bags baccarat crystal nexium online pai gow poker leigh keno

tramadol 50mg tramadol saturday delivery tramadol er tramadol sales tramadol hcl 50 mg 120 tramadol acetaminophen hcl par tramadol plus size mother of the bride dresses cheap flower girl dresses discount flower girl dresses infant flower girl dresses bridal flower girl dresses