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.
|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|