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