Explanation on how to add a missing text search field index to an Oracle Maximo 7.x database
Getting error messages stating indexes are not indexed or stating you are missing an index
You may get a BMXAA4210E - Database error number 20000 has occurred, ORA-20000: Oracle Text error: DRG-10599: column is not indexed error at some stage if you try to do something in Maximo.
Say for example you try to search or do a query from the jobplan list screen.
It could be, after investigation, you find out that the text string index on the
job plan table was missing or the whole index.
In order to identify if you have a missing Oracle index , please see Technote 1403468
In order to ADD this missing text index back again, you need to run the following create index statement:
CREATE INDEX jobplandes_tidx on jobplan (description) indextype is ctxsys.context parameters ('lexer global_lexer language column
LANGCODE')
To use the above example,the same format counts for any text index you may need to re-add.
You just change jobplandes_tidx to index name, jobplan to table name, description to column name.
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Database Config","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.5","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":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"","label":"Windows 2003 server"},{"code":"","label":"Windows 2008 server"}],"Version":"7.1;7.1.1;7.5","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":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"","label":"Windows 2003 server"},{"code":"","label":"Windows 2008 server"}],"Version":"7.1;7.5","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":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF010","label":"HP-UX"},{"code":"","label":"Windows 2000"},{"code":"","label":"Windows 2003 server"},{"code":"","label":"Windows XP"}],"Version":"7.1;7.1.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]