IBM Support

Integrity Checker error BMXAA0494E

Troubleshooting


Problem

Running Integrity Checker returns this error: BMXAA0443E - ERROR -- BMXAA0494E - The Maximo definition of this column does not match the actual column: BMXAA6841I - REPORT.USEWHEREWITHPARAM, Maximo definition is YORN, Database column is int

Cause

Database column REPORT.USEWHEREWITHPARAM is integer. But in Maximo (MaxAttribute) the column is defined as datatype YORN. Maximo type YORN is not compatible with integer.

Environment

This problem typically occurs on SQL Server databases only.

Diagnosing The Problem

Do NOT run Integrity Checker in repair mode, which is what is recommended in similar cases. Repair mode will resolve the inconsistency by modifying the Maximo definition of the column to match the actual database column. But in this instance, the Maximo definition is correct; the database column was created/upgraded incorrectly.

Resolving The Problem

The native database column should be altered.


On a SQL Server database, alter the column to datatype smallint with this SQL:
Alter Table report Alter Column usewherewithparam Not Null



Re-run Integrity Checker in report mode, in order to verify the error is resolved.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Upgrade Integ Checker","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.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;7.1;7.1.1;7.5","Edition":"All Editions","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":" ","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":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21613814

Page Feedback