BMXAA6445E - Cache INTOBJECT could not be initialized. Log out and then log in again to refresh your database connection #BMXAA6445E #BMXAA7733E

INTOBJECT could not be initialized can occur while 

1. Restarting the instance,

2. Trying to save Object Structure.

Error can be as below :

BMXAA6445E - Cache INTOBJECT could not be initialized. Log out and then log in again to refresh your database connection.

BMXAA7733E - There was an error loading the Object Structure cache: null

Reason : There can be a component referenced in the object structure which is no more present in the db.

Run the below queries to identify orphan entries and components that need not be linked with the Object Structure.

Restart the instance after clearing the orphan entries.

1. Check for inconsistent MAXINTOBJCOLS entries and remove the orphan ones.

select * from maximo.maxintobjcols where intobjectname not in (select intobjectname from maximo.maxintobject);

select * from maximo.maxintobjcols where (intobjectname,objectname) not in (select intobjectname,objectname from maximo.maxintobjdetail) ;

select * from maximo.maxintobjcols where (objectname,name) not in (select objectname,attributename from maximo.maxattribute);

2. Check if Objects used in the Object structure exist in the object table

select intobjectname, objectname from maxintobjdetail where objectname

not in (select objectname from maxobject);

select * from maximo.maxintobjdetail where intobjectname not in (select intobjectname from maximo.maxintobject);

3.  Alias

Check for inconsistent Alias entries present in maxintobjalias table for intobject.

select * from maximo.maxintobjalias where intobjectname not in (select intobjectname from maximo.maxintobject);

4. Indexes

An alternative key can be present in maxtable or maxintobjdetail or associated with an Object under Object structure and not present in Indexes table.

select tablename, altixname from maxtable where altixname not in (select name from maxsysindexes);

select intobjectname, objectname, altkey from maxintobjdetail where altkey not in (select name from maxsysindexes);

5. Relationships

Check for relationship used in the Object Structure but not present in Relationships table.

select intobjectname, objectname, relation from maxintobjdetail where relation not in (select name from maxrelationship);

6. OSLC queries

Check for scripts associated within query definition of an Object structure, that do not exist anymore in AUTOSCRIPT object. Remove the anomaly.

select app, clausename, scriptname, usage, method, clause, ispublic, owner, role, oslcqueryid from maximo.oslcquery where intobjectname=?

select scriptname from oslcquery where scriptname not in ( select autoscript from autoscript);