dbTalk Databases Forums  

Re: Urgent Help needed

sybase.public.ase.nt sybase.public.ase.nt


Discuss Re: Urgent Help needed in the sybase.public.ase.nt forum.

Reply
 
Thread Tools Display Modes
  #21  
Old   
Bret Halford
 
Posts: n/a

Default Re: Urgent Help needed - 07-03-2008 , 10:29 AM






Xavier Maillard wrote:
Quote:
May be due to CR 277087, fixed in 12.5.0.2

"A 1530 error, "Create index with sorted_data was aborted
because of row out of order. Primary key of first out of
order row is '<value>'", may occassionally be reported
when an ALTER TABLE MODIFY command is executed on a
data-only locked table and the table has a clustered
index."

As a quick workaround/alternative to applying the current
rollup, you could try dropping
the clustered index, then add the column, then recreate
the index.

Can this occur also on a ASE 12.0.0.4 release ?

Regards
I think so. The fix was also provided in 12.0.0.6 IR.

-bret




Reply With Quote
  #22  
Old   
Bret Halford
 
Posts: n/a

Default Re: Urgent Help needed - 07-03-2008 , 10:29 AM






Xavier Maillard wrote:
Quote:
May be due to CR 277087, fixed in 12.5.0.2

"A 1530 error, "Create index with sorted_data was aborted
because of row out of order. Primary key of first out of
order row is '<value>'", may occassionally be reported
when an ALTER TABLE MODIFY command is executed on a
data-only locked table and the table has a clustered
index."

As a quick workaround/alternative to applying the current
rollup, you could try dropping
the clustered index, then add the column, then recreate
the index.

Can this occur also on a ASE 12.0.0.4 release ?

Regards
I think so. The fix was also provided in 12.0.0.6 IR.

-bret


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.