IBM Support

Integrity Checker Error BMXAA0497E

Troubleshooting


Problem

Integrity Checker may report the following errors: BMXAA0443E - ERROR -- BMXAA0497E - The following columns are defined to be 'same-as', but have different definitions: PLUSTVR.GLACCOUNT GL(23) same as WORKORDER.GLACCOUNT GL(8) BMXAA0443E - ERROR -- BMXAA0497E - The following columns are defined to be 'same-as', but have different definitions: PLUSTVS.GLACCOUNT GL(23) same as WORKORDER.GLACCOUNT GL(8)

Symptom

In the Maximo tables, PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT are defined to the 'same as' WORKORDER.GLACCOUNT, but they are not defined the same. 'Same-as' means that the data type and length of PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT should be the same as WORKORDER.GLACCOUNT, but they are not.

Cause

Length of PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT is 23. Length of WORKORDER.GLACCOUNT is 8. The lengths are supposed to be the same values.

Environment

Windows. All database platforms.

Diagnosing The Problem

The results of this query "should" be the same for all columns, but are not:

Select objectname, attributename, maxtype, length From maxattribute Where (objectname='WORKORDER' And attributename='GLACCOUNT') Or (sameasobject='WORKORDER' And sameasattribute='GLACCOUNT')

Resolving The Problem

The lengths of PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT (23) are not the same as WORKORDER.GLACCOUNT (8). The solution is to alter the lengths of PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT to be the same (8). Since PLUSTVR.GLACCOUNT and PLUSTVS.GLACCOUNT are views of columns, and not actual columns, only their Maximo definitions need to be corrected. Execute the following 2 SQL statement, be sure to commit the database changes, and again run Integrity Checker in report mode in order to verify that the errors are no longer reported:


Update maxattribute Set length=8 Where objectname In ('PLUSTVR', 'PLUSTVS') And attributename='GLACCOUNT' ;
Update maxattributecfg Set length=8 Where objectname In ('PLUSTVR', 'PLUSTVS') And attributename='GLACCOUNT' ;

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Upgrade Integ Checker","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1;7.5","Edition":"","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:
17 June 2018

UID

swg21676684

Page Feedback