Environment
Novell ZENworks Configuration Management 11.2 Database
Situation
Sybase database won't stay loaded, throwing the following error:
Issue - *** ERROR *** Assertion failed: 200114 (12.0.0.2601)
Can't find values for row 1a1b:24 in index 'idx_zMessage_K7_K5_K6_K11_K2'
Aborted
Resolution
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:
CALL sa_validate()
4) Run the following SQL statement to recreate the index:
CREATE NONCLUSTERED INDEX idx_zMessage_K7_K5_K6_K11_K2 ON zMessage
(
messagetype ASC,
acktime ASC,
raisedBy ASC,
relatedUID ASC,
messageid ASC
);
GO
NOTE: these steps may change depending on the index corrupted.