Pinned topic BMXAA6531E-EventTopic exregister :unable to register extended object - null

Was this ever resolved? If so, how? Thanks!

• L2MAXIMO 270003WTA7
• ‏2016-12-10T17:10:55Z

Was this ever resolved? If so, how? Thanks!

More...

****Update: We were able to resolve the issue. It turned out to be a data issue where an object in the maxattribute and maxattributecfg tables was not specified as a table or anywhere in the maximo database dictionary tables.

This was our specific error:

[12/11/16 2:44:31:183 GMT] 00000090 SystemOut     O 11 Dec 2016 02:44:31:176 [ERROR] [] [] system#major
psdi.util.MXSystemException: system#major
    at psdi.mbo.MaximoDD.init(MaximoDD.java:244)
    at psdi.mbo.MaximoDD.reload(MaximoDD.java:282)
    at psdi.mbo.MaximoDDFactory.getCache(MaximoDDFactory.java:167)
    at psdi.mbo.MaximoDDFactory.init(MaximoDDFactory.java:66)
    at psdi.server.MXServer.boot(MXServer.java:1329)
    at psdi.server.MXServer.start(MXServer.java:3422)
    at psdi.servlet.MAXIMOStartupServlet.init(MAXIMOStartupServlet.java:70)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:342)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.loadOnStartupCheck(ServletWrapper.java:1366)
    at com.ibm.ws.webcontainer.webapp.WebApp.doLoadOnStartupActions(WebApp.java:617)
    at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinally(WebApp.java:587)
    at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:425)
    at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88)
    at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:169)
    at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:749)
    at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:634)
    at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:426)
    at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:718)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1177)
    at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1370)
    at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:639)
    at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:968)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:776)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2195)
    at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5474)
    at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5600)
    at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2200)
    at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:389)
    at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123)
    at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:332)
    at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:119)
    at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:938)
    at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:502)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
Caused by: java.lang.NullPointerException
    at psdi.mbo.MaximoDD.createMboValueInfo(MaximoDD.java:2086)
    at psdi.mbo.MaximoDD.loadMboValuesInfo(MaximoDD.java:1738)
    at psdi.mbo.MaximoDD.loadMboValuesInfo(MaximoDD.java:1693)
    at psdi.mbo.MaximoDD.loadDataDictionary(MaximoDD.java:638)
    at psdi.mbo.MaximoDD.init(MaximoDD.java:234)
    ... 35 more

Things to consider to get to the bottom of this:

- If any database configurations occurred before getting this error and maximo not starting, review the logs, make sure all configs ended without error, review the changes that were made. They are found under <maximo home>/tools/maximo/log or under your specific WebSphere Application Server home folder

- Add additional logging to the classes to determine what objects and /or attributes are being referenced that are inconsistent in the MaximoDD, MaximoDD$PropertyListener and SqlFormat classes.

- run the integrity checker utility and review the resulting log. Pay particular attention to the part where it checks for attributes or objects that don't exist in the database. If the checker fails with the below error, check the line immediately above the error to determine the nonexistent object, it'll be something like select 1 from <table> where <column> is not null and <column> not in (select value from alndomain where domainid = <SITE>) 
;

Make sure <TABLE> exists in the data dictionry (maxattribute, maxattributecfg, maxobject, maxobjectcfg, etc., etc.) and that it is in fact a table in the database and not just referenced in the maximo data dictionary. 

ORA-00942: table or view does not exist

    at oracle.jdbc.driver.SQLStateMapping(SQLStateMapping.java: 74)
    at oracle.jdbc.driver.DatabaseError(DatabaseError.java: 131)
    at oracle.jdbc.driver.DatabaseError(DatabaseError.java: 204)
    at oracle.jdbc.driver.T4CTTIoer(T4CTTIoer.java: 455)
    at oracle.jdbc.driver.T4CTTIoer(T4CTTIoer.java: 413)
    at oracle.jdbc.driver.T4C8Oall(T4C8Oall.java: 1034)
    at oracle.jdbc.driver.T4CStatement(T4CStatement.java: 183)
    at oracle.jdbc.driver.T4CStatement(T4CStatement.java: 780)
    at oracle.jdbc.driver.T4CStatement(T4CStatement.java: 855)
    at oracle.jdbc.driver.OracleStatement(OracleStatement.java: 1186)
    at oracle.jdbc.driver.OracleStatement(OracleStatement.java: 1377)
    at oracle.jdbc.driver.OracleStatementWrapper(OracleStatementWrapper.java: 387)
    at com.ibm.tivoli.maximo.dbmanage.connection.LoggingStatement(LoggingStatement.java: 251)
    at com.ibm.tivoli.maximo.dbmanage.SQLUtility(SQLUtility.java: 205)
    at com.ibm.tivoli.maximo.integrity.check.VerifyValueListColumns(VerifyValueListColumns.java: 271)
    at com.ibm.tivoli.maximo.integrity.check.CheckTenantData(CheckTenantData.java: 100)
    at com.ibm.tivoli.maximo.integrity.IntegrityCheck(IntegrityCheck.java: 114)
    at psdi.configure.Validate(Validate.java: 6292)
    at psdi.configure.Validate(Validate.java: 1085)
    at psdi.configure.UpgradeUI(UpgradeUI.java: 434)
    at psdi.configure.UpgradeUI(UpgradeUI.java: 340)
    at javax.swing.AbstractButton(AbstractButton.java: 2029)
    at javax.swing.AbstractButton$Handler(AbstractButton.java: 2352)
    at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 413)
    at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 270)
    at javax.swing.plaf.basic.BasicButtonListener(BasicButtonListener.java: 263)
    at java.awt.Component(Component.java: 6520)
    at javax.swing.JComponent(JComponent.java: 3332)
    at java.awt.Component(Component.java: 6285)
    at java.awt.Container(Container.java: 2240)
    at java.awt.Component(Component.java: 4876)
    at java.awt.Container(Container.java: 2298)
    at java.awt.Component(Component.java: 4702)
    at java.awt.LightweightDispatcher(Container.java: 4843)
    at java.awt.LightweightDispatcher(Container.java: 4503)
    at java.awt.LightweightDispatcher(Container.java: 4433)
    at java.awt.Container(Container.java: 2284)
    at java.awt.Window(Window.java: 2730)
    at java.awt.Component(Component.java: 4702)
    at java.awt.EventQueue(EventQueue.java: 740)
    at java.awt.EventQueue(EventQueue.java: 114)
    at java.awt.EventQueue$3(EventQueue.java: 699)
    at java.awt.EventQueue$3(EventQueue.java: 697)
    at java.security.AccessController(AccessController.java: 252)
    at java.security.ProtectionDomain$1(ProtectionDomain.java: 87)
    at java.security.ProtectionDomain$1(ProtectionDomain.java: 98)
    at java.awt.EventQueue$4(EventQueue.java: 713)
    at java.awt.EventQueue$4(EventQueue.java: 711)
    at java.security.AccessController(AccessController.java: 252)
    at java.security.ProtectionDomain$1(ProtectionDomain.java: 87)
    at java.awt.EventQueue(EventQueue.java: 710)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 253)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 172)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 161)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 157)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 149)
    at java.awt.EventDispatchThread(EventDispatchThread.java: 102)

ORA-00942: table or view does not exist

BMXAA6847I - Validate -- Integrity checking completed with errors.