Troubleshooting
Problem
MIC service will not start after applying the 7.5.0.5 fix pack or later.
Symptom
Error Initializing MicService:BMXAA7733E - Failed to load the null
object structure cache when the server was starting up.
null
psdi.util.MXSystemException: BMXAA7733E - Failed to load the null
object structure cache when the server was starting up.
The following stack trace can be seen in the systemout.log:
[ERROR] [maximo_mif] []
java.lang.NullPointerException
at psdi.iface.mos.MosDetailInfo.setAltKeys(MosDetailInfo.java:410) at psdi.iface.mos.ObjectStructureCache.loadMosDetails(ObjectStructureCache.java:298)
at psdi.iface.mos.ObjectStructureCache.loadIntegrationDictionary(ObjectStructureCache.java:196)
at psdi.iface.mos.ObjectStructureCache.init(ObjectStructureCache.java:115)
at psdi.iface.mos.ObjectStructureCache.<init>(ObjectStructureCache.java:87)
at psdi.iface.mos.ObjectStructureCache.getInstance(ObjectStruct
ureCache.java:76)
at psdi.iface.mic.MicService.init(MicService.java:129)
Cause
An alternate key is defined in maxtable.altixname or maxobjdetail.altkey however the index is not defined in Maximo.
Resolving The Problem
Run the following SQL statements from the backend using a SQL tool:
1. maxtable
select tablename, altixname from maxtable where altixname not in (select name from maxsysindexes);
If the query returns any rows, the index does not exist in maxsysindexes.
Go to Database Configuration - Select Action - Refresh Index tables
If the query still retrieves rows, determine if altixname is valid. If it is not, delete the value in altixname. Replace 'xxx' with the tablename selected above:
update maxtable set altixname=null where tablename='xxx;
update maxtablecfg set altixname=null where tablename='xxx';
commit;
2. maxintobjdetail
select intobjectname, objectname, altkey from maxintobjdetail where altkey not in (select name from maxsysindexes);
If the query returns any rows, remove the alternate key.
Go to - Integration - Object Structures application. Query the object structure and update the alternate key as needed for each MBO.
If that is not possible, you can delete or replace the value in altkey. Replace 'xxx' with the altkey selected above:
update maxintobjdetail set altkey =null where intobjectname='yyy' and objectname='zzz' and altkey ='xxx';
commit;
3. Restart the server.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21654883