Sybase database won't stay loaded

  • 7014011
  • 28-Oct-2013
  • 28-Oct-2013


Novell ZENworks Configuration Management 11.2 Database


Sybase database won't stay loaded, throwing the following error:
Issue - *** ERROR *** Assertion failed: 200114 (
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:
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

NOTE: these steps may change depending on the index corrupted.