Error when querying events (message CEIDS0060E)

My event consumer encounters an error when trying to query events from the event service, and message CEIDS0060E appears in the WebSphere® log file.

Cause

The event service uses metadata stored in the event database to map Common Base Event elements and attributes to database tables and columns. This information is read from the database the first time an application attempts to use the event service after startup.

The metadata tables are populated when the event database is created. This error occurs if the tables do not contain the required metadata at run time.

Remedy

To correct this problem, you need to re-create the required metadata. When the event database is created, the database configuration administrative command also generates a database script that can be used to repopulate the metadata at a later time. The name of this script depends on the database type:
Database type Script name
DB2® ins_metadata.db2
Informix® ins_metadata.sql
Oracle ins_metadata.ora
SQL Server ins_metadata.mssql
DB2 UDB for iSeries ins_metadata.db2

By default, the script is created in the profile_root/dbscripts/CEI_database_namenode directory. You can run this script at any time.

To re-create the metadata, use the appropriate SQL processor to run the script:
  • For UNIX operating systemFor Linux operating systemFor Windows operating systemDB2: db2
  • For UNIX operating systemFor Linux operating systemFor Windows operating systemOracle: SQL*Plus
  • For UNIX operating systemFor Linux operating systemFor Windows operating systemInformix: dbaccess
  • For Windows operating systemSQL Server: osql

After repopulating the metadata, restart the server.