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.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21613814