IBM Support

"ORA-00936: missing expression" when configdb rebuilds indexes

Troubleshooting


Problem

When running configdb it fails with an oracle missing expressions error.

Symptom

Unable to run configdb or start Maximo

Cause

This is caused by configdb trying to refresh the indexes based on what is in the maxsysindexes keys table and the columns associated in the maxsyskeys table. It is finding an index in maxsysindexes that does not have associated keys in maxsyskeys and trying to create it without a column

Diagnosing The Problem

This is caused by configdb trying to refresh the indexes based on what is in the maxsysindexes keys table and the columns associated in the maxsyskeys table.

Review the configdb log file and search for the error, right before the error there should be a statement creating an index with empty values.

For example CREATE INDEX PO_NDX5()

This shows the index has no associated values in the maxsyskeys table.

Resolving The Problem

To resolve this issue you can either remove the line from the maxsysindexes table for the faulty index as it is not needed. If the index is needed follow the same steps to remove and then recreate the index correctly through the database and run configdb again.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Database Config","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21498915

Page Feedback