IBM Support

Integrity Checker error BMXAA0494E

Technote (troubleshooting)


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


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.


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.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT Not Applicable
Systems and Asset Management Tivoli Change and Configuration Management Database
Systems and Asset Management Tivoli Service Request Manager

Document information

More support for: Maximo Asset Management
Upgrade Integ Checker

Software 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

Operating system(s): Platform Independent

Software edition: All Editions

Reference #: 1613814

Modified date: 25 September 2013

Translate this page: