IBM Support

Manage fails to start after upgrading to MAS 8.9/Manage 8.5 with BMXAA6838E MAXAPPDATA not found

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"}]

Document Information

Modified date:
22 March 2023

UID

ibm16965334

Page Feedback