Cannot insert rows into sysstatistics

[breen]

Hi,

I'm running sybase adaptive server 11.9.2

and I get this error when I try to create a clustered index on a table:

Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support

Does any know why this occurs or how to resolve it?

Thanks for any time spent on responses,
Breen.

 

[JMCraig]

A search of the on-line 11.9.2 Error Message and Troubleshooting Guide:

http://manuals.sybase.com/onlinebooks/group-as/asg1192e/svrtsg/@Generic__BookView

Reveals this relatively unhelpful information:

Error Number 1763
Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Techn ical Support

Explanation:

Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator. (Introduced in 11.9.2).

I'd try running full DBCC checks against the database in question (put it in single-user mode so you can use the FIX option on CHECKALLOC). If you have any indexes on the table at the moment, you might try dropping them.

If you get no joy from that, I'd definitely open a case with Sybase (if you have a support contract). While you're waiting to hear back on that, I'd probably try BCP'ing out the data, rename the table (don't drop it just yet), recreate the table (without indexes), enable the SELECT/INTO BULK COPY db option, BCP the data back in. Run DBCC checks and then try recreating the indexes.

HTH,

John
J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net

 

[breen]

Thanks for your help John,

I'll give it a whizz.