Sybase database won't stay loaded, throwing the following error:
Issue - *** ERROR *** Assertion failed: 200114 (220.127.116.1101)
Can't find values for row 1a1b:24 in index 'idx_zMessage_K7_K5_K6_K11_K2'
There is a corrupted index in the database, that being the reason why it won't stay loaded. Please go through the following steps to fix the corruption:
1) Load dbisql, and connect direct to the db file using these options:
User ID: zenadmin
Password: <zenadmin password>
Action: Start and connect to a database on this computer
Database file: navigate to the database file (Windows: %ZENWORKS_HOME%\database\<database_file>, Linux: /var/opt/novell/zenworks/database/<database_file>)
Database name: fill out the database name
2) Run the following SQL statement to drop the corrupted index:
drop index zMessage.idx_zMessage_K7_K5_K6_K11_K2
3) Run the following SQL statement to validate/health check the database:
4) Run the following SQL statement to recreate the index:
CREATE NONCLUSTERED INDEX idx_zMessage_K7_K5_K6_K11_K2 ON zMessage
NOTE: these steps may change depending on the index corrupted.
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.