IBM Support

Integrity Checker error BMXAA0478E

Troubleshooting


Problem

After installing or upgrading to Mobile 7.1.1, if you run Integrity Checker you may see this error reported: BMXAA0443E - ERROR -- BMXAA0478E - The ROWSTAMP trigger was not found for the following tables: MOBILEADHOCQUERY

Symptom

Database fails Integrity Checker due to errors reported.

Cause

The rowstamp trigger does indeed exist on the database for table MOBILEADHOCQUERY. But it is misspelled in the Maximo definition of table MOBILEADHOCQUERY.

Environment

Maximo 7.1, Mobile 7.1.1, Oracle database

Diagnosing The Problem

This query will return the value 'MOBILEAHOCQUERY'. That value is incorrect. It should be 'MOBILEADHOCQUERY'.

Select trigroot From maxtable Where tablename='MOBILEADHOCQUERY'

Resolving The Problem

Need to correct the value of TRIGROOT. Execute these two SQL update statements, be sure to commit the database changes, then run Integrity Checker again in report mode in order to verify that the error is resolved:

Update maxtable Set trigroot='MOBILEADHOCQUERY' Where tablename='MOBILEADHOCQUERY' ;
Update maxtablecfg Set trigroot='MOBILEADHOCQUERY' Where tablename='MOBILEADHOCQUERY' ;

[{"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.1.1","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":"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":"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

swg21671387