When any column value is accessed in a database table, Adaptive Server version 12.5.2 has been enhanced to validate the length of the row and the length of the column value within the row, using information stored within the system catalogs in that database. Any discrepancy is reported in the error log with the message:
Invalid column length: <length>. Value must be between 0 and <max col length> for '<row type>' row with minimum row length of <min row length>.
This check requires accurate information within the system catalogs. It is important to verify the accuracy of this information before any database activity occurs after the upgrade to Adaptive Server version 12.5.2 to prevent any false alarms.
To verify the information, run dbcc checkcatalog(<database name>) for all databases. If any errors are reported, fix them by running dbcc checkcatalog(<database name>, "fixall").
Dump the database after the fixes have been made. If an older dump is loaded into Adaptive Server 12.5.2, then any fixes that dbcc checkcatalog has applied to system catalogs is lost by the load. Rerun dbcc checkcatalog after the load has completed.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
