Troubleshooting
Problem
Manage application fails to start after the upgrade from Manage 8.4 or earlier to Manage 8.5 or later.
Symptom
Manage fails to start successfully and gives error when trying to log in to Manage.
Pod shows as started in Red Hat OpenShift, but application is not available.
Manage log shows an error message related to MAXAPPDATA object missing.
Cause
The Anywhere application was removed from Manage 8.5 and future versions going forward. The MAXAPPDATA object in Manage is part of this product and was removed.
The error message BMXAA6838E comes from having an object structure that is referencing the missing object. Anything that uses or references the MAXAPPDATA object causes similar errors.
Environment
Manage 8.5 or later, with previous version of Manage referencing a removed object.
Diagnosing The Problem
Manage log shows an error message related to MAXAPPDATA object missing.
[ERROR] [integration] BMXAA6838E - The MAXAPPDATA table is missing.
psdi.util.MXApplicationException: BMXAA6838E - The MAXAPPDATA table is missing.
at psdi.iface.mic.MicUtil.getEntityName(MicUtil.java:397) ~[businessobjects.jar:?]
at psdi.iface.mic.MicUtil.getKeyArray(MicUtil.java:322) ~[businessobjects.jar:?]
at psdi.iface.mos.ObjectStructureCacheImpl.loadMosDetails(ObjectStructureCacheImpl.java:311) ~[businessobjects.jar:?]
at psdi.iface.mos.ObjectStructureCacheImpl.loadIntegrationDictionary(ObjectStructureCacheImpl.java:203) [businessobjects.jar:?]
at psdi.iface.mos.ObjectStructureCacheImpl.init(ObjectStructureCacheImpl.java:78) [businessobjects.jar:?]
at psdi.mbo.AbstractMaximoMTEnabledCache.getCache(AbstractMaximoMTEnabledCache.java:81) [businessobjects.jar:?]
at psdi.mbo.AbstractMaximoMTEnabledCache.init(AbstractMaximoMTEnabledCache.java:49) [businessobjects.jar:?]
at psdi.iface.mos.ObjectStructureCache.<init>(ObjectStructureCache.java:83) [businessobjects.jar:?]
at psdi.iface.mos.ObjectStructureCache.<clinit>(ObjectStructureCache.java:55) [businessobjects.jar:?]
at psdi.iface.mic.MicService.init(MicService.java:170) [businessobjects.jar:?]
at psdi.iface.mic.EntMicService.init(EntMicService.java:135) [businessobjects.jar:?]
at psdi.server.ServiceCoordinator.init(ServiceCoordinator.java:154) [businessobjects.jar:?]
at psdi.server.MXServer.init(MXServer.java:2724) [businessobjects.jar:?]
at psdi.server.MXServer.start(MXServer.java:3870) [businessobjects.jar:?]
Resolving The Problem
This error means that there is an object structure using the MAXAPPDATA object after it was removed.
To find the object structure using this object, you can run the query:
SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA';
If there is at least one row returned, we can select all entries of these object structures and save the results as an informal backup:
SELECT * FROM MAXINTOBJDETAIL WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
SELECT * FROM MAXINTOBJECT WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
SELECT * FROM MAXINTOBJCOLS WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
After saving the results, then the named object structures need be removed with the queries:
DELETE FROM MAXINTOBJDETAIL WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
DELETE FROM MAXINTOBJECT WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
DELETE FROM MAXINTOBJCOLS WHERE INTOBJECTNAME IN (SELECT INTOBJECTNAME FROM MAXINTOBJDETAIL WHERE OBJECTNAME = 'MAXAPPDATA');
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m0z000000cwZDAAY","label":"Maximo Application Suite"}],"ARM Case Number":"TS012471093","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.9.0"}]
Was this topic helpful?
Document Information
Modified date:
22 March 2023
UID
ibm16965334