Novell Home

My Favorites

Close

Please to see your favorites.

Sybase database won't stay loaded

This document (7014011) is provided subject to the disclaimer at the end of this document.

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.

Disclaimer

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.

  • Document ID:7014011
  • Creation Date:28-OCT-13
  • Modified Date:28-OCT-13
    • NovellZENworks Configuration Management

Did this document solve your problem? Provide Feedback