IBM Support

Resolving Common Maximo 6 Upgrade Errors

Troubleshooting


Problem

List of common upgrade errors, including cause and fix action.

Resolving The Problem

The attached document contains both cause and action for common upgrade errors.
Integrity Checker Utility errors
ERROR – 0078 The database has a different UNIQUE property for the following original index definition(s)
ERROR – 0084 No unique index found for primary key sequence on table(s):
ERROR – 0109 The Maximo definition of this column does not match the actual column:
ERROR – 0145 This column is mapped to a MAXIMO value list but the value list does not exist
ERROR -- 0150 MAXTABLES definition differs from MAXTABLESCFG for
ERROR -- 0155 Remarks must be added to the following Maximo column definitions:
ERROR -- 0163 Need to have existing properties file to upgrade workflow auto-accept tasks completely.
ERROR – 0166 A record exist in MaxTables but not MaxTables2 for table
ERROR – 0178 Orphan long descriptions exists against tables run repair mode to remove.
ERROR -- 0191 The same index name is used on different tables in the native database.
ERROR – 0193 Key record of doclinks does not exist in the database(keyValue-tableName- keyColumn-siteId-orgId):
ERROR – 0215 Table <table> references long description <number> but the long description does not exist.
Validation Utility errors
ERROR -- A list defined in valuelistdomain has wrong type values in valuelist.
ERROR -- All workflow processes must be stopped before upgrading.
ERROR -- An invalid record was found while searching for circular references.
ERROR -- Bookmarked records does not exist in the database(userName-appName-keyValue-tableName-keyColumn-siteId-orgId):
ERROR -- Configurable Startcenter found.
ERROR -- Maxrelationship cannot be added because it already exists in the database:
ERROR -- MXES requires delimiters for all GL accounts stored in the database.
ERROR -- The following GL Components contain a character that is also used as a delimiter for that component, which is not permitted.
ERROR – 0156 The following menu options are mapped to the same position:
ERROR -- 0162 Occurrences of MeterLabel1 and MeterLabel2 cannot be null.
ERROR – 0198 Maxdomain cannot be added because it already exists in the database:
ERROR – 0201 Table <table> has more than one owner for LongDescription
Upgrade Utility errors
ERROR -- The connection was closed after OutOfMemoryError
ERROR -- The tablespace MAXIMO does not exist, it is misspelled, Maximo has not been granted quota on the tablespace, or it is not online.
ERROR -- The object '<constraint name>' is dependent on column '<column>'.
ERROR -- Msg 5074, Level 16, State 8, Line 1, Sqlstate 01000: The statistics '<statistic>' is dependent on column '<column>'.
ERROR -- String or binary data would be truncated.
ERROR -- Cannot insert the value NULL into column '<column>', table ‘<table>’; column does not allow nulls.
ERROR -- 0115 The Maximo-defined length for this column is invalid:
ORA-01400: cannot insert NULL into ("MAXIMO"."<table."."column")
ORA-01439: column to be modified must be empty to change datatype
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found



5.2 to 6 Upgrade Errors.doc 5.2 to 6 Upgrade Errors.doc

5.2 to 6 Upgrade Errors.doc

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Upgrade Utility","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.1;5.2;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8","Edition":"Standard","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":"","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":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","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":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
13 April 2021

UID

swg21294275