Troubleshooting
Problem
When you run Integrity Checker on a TSRM 7.2.1 database, this error may be reported: BMXAA0443E - ERROR -- BMXAA6238E - These views should be removed from Maximo because they do not exist in the database: PMSCCRCART
Cause
View PMSCCRCART is defined in the Maximo tables, but the view does not exist on the native database.
Environment
TSRM 7.2.1 and subsequent versions. Issue is known to occur on DB2; may occur on other database platforms.
Diagnosing The Problem
These two queries will confirm that the view is defined in Maximo:
Select objectname, description, entityname, extendsobject, imported, isview, persistent, servicename, siteorgtype, userdefined From maxobject Where objectname='PMSCCRCART' ;
Select viewname, autoselect, viewselect, viewfrom, viewwhere From maxview Where viewname='PMSCCRCART' ;
The following query will confirm that view PMSCCRCART does not exist on the DB2 database. If your database is other than DB2, the query will need to be tailored for that database:
Select * From syscat.views Where viewname='PMSCCRCART'
Resolving The Problem
The view needs to be added to the database. On DB2 this can be done with this SQL:
Create View pmsccrcart (changeby, changedate, description, droppoint, hasld, historyflag, langcode, location, orgid, origrecordclass, origrecordid, pluspcustomer, pmsccrid, pmsccrnum, priority, requestedby, requesteddate, requestedfor, rowstamp, shipto, siteid, status, statusdate)
As Select pmsccr.changeby, pmsccr.changedate, pmsccr.description, pmsccr.droppoint, pmsccr.hasld, pmsccr.historyflag, pmsccr.langcode, pmsccr.location, pmsccr.orgid, pmsccr.origrecordclass, pmsccr.origrecordid, pmsccr.pluspcustomer, pmsccr.pmsccrid, pmsccr.pmsccrnum, pmsccr.priority, pmsccr.requestedby, pmsccr.requesteddate, pmsccr.requestedfor, pmsccr.rowstamp, pmsccr.shipto, pmsccr.siteid, pmsccr.status, pmsccr.statusdate
From pmsccr Where pmsccr.status in (Select value From synonymdomain Where domainid='PMSCCRSTATUS' And maxvalue ='DRAFT')
And pmsccr.pmsccrnum in (Select ticket.pmsccrid From ticket) ;
After adding the view, again run Integrity Checker in report mode in order to verify that the error is no longer reported.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21962835