IBM Support

psdi.util.MXSystemException: system#major during startup

Troubleshooting


Problem

Maximo fails to start due to a java.lang.NullPointerException when loading MboValues from the Data Dictionary

Symptom

Unable to start Maximo, systemout logs show the following stack trace. 
[FATAL] BMXAA6473E - Maximo failed to start.
psdi.util.MXSystemException: system#major
     at psdi.mbo.MaximoDD.init(MaximoDD.java:240)
     at psdi.server.MXServer.boot(MXServer.java:1247)
     at psdi.server.MXServer.start(MXServer.java:3080)
     at psdi.servlet.MAXIMOStartupServlet.init(MAXIMOStartupServlet.java:63)
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:226)
     at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.init(ServletWrapper.java:320)
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.initialize(ServletWrapper.java:1305)
     at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.initialize(ServletWrapper.java:153)
     at com.ibm.wsspi.webcontainer.extension.WebExtensionProcessor.createServletWrapper(WebExtensionProcessor.java:99)
     at com.ibm.ws.webcontainer.webapp.WebApp.getServletWrapper(WebApp.java:887)
     at com.ibm.ws.webcontainer.webapp.WebApp.getServletWrapper(WebApp.java:809)
     at com.ibm.ws.webcontainer.webapp.WebApp.initializeTargetMappings(WebApp.java:527)
     at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinish(WebApp.java:364)
     at com.ibm.ws.wswebcontainer.webapp.WebApp.initialize(WebApp.java:292)
     at com.ibm.ws.wswebcontainer.webapp.WebGroup.addWebApplication(WebGroup.java:92)
     at com.ibm.ws.wswebcontainer.VirtualHost.addWebApplication(VirtualHost.java:157)
     at com.ibm.ws.wswebcontainer.WebContainer.addWebApp(WebContainer.java:671)
     at com.ibm.ws.wswebcontainer.WebContainer.addWebApplication(WebContainer.java:624)
     at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:335)
     at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:551)
     at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1274)
     at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1138)
     at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:569)
     at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:817)
     at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:921)
     at com.ibm.ws.runtime.component.ApplicationMgrImpl$AppInitializer.run(ApplicationMgrImpl.java:2124)
     at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:342)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Caused by:
java.lang.NullPointerException
     at psdi.mbo.MaximoDD.loadMboValuesInfo(MaximoDD.java:1929)
     at psdi.mbo.MaximoDD.loadMboValuesInfo(MaximoDD.java:1616)
     at psdi.mbo.MaximoDD.loadDataDictionary(MaximoDD.java:629)
     at psdi.mbo.MaximoDD.init(MaximoDD.java:230)
... 27 more

Cause

This can be caused by the mxe.db.rowcount value being set to a value lower then the amount of rows to be returned

Diagnosing The Problem

To determine the current amount of rows that can be returned you can run the following select on the maxpropvalue table. 
select propname,propvalue from maxpropvalue where propname ='mxe.db.rowcount'

If this number is lower then the amount of attributes to be returned you will want to update it to a high number or set it to 0 for unlimited by running the following update statement.

Resolving The Problem

Update the rowcount to unlimited or a larger value then what was returned above 
update maxpropvalue set propvalue =0 where propname ='mxe.db.rowcount'

[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbCvAAK","label":"System->System Related"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.0;7.6.0;7.6.1"},{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"ARM Category":[{"code":"a8m500000008b3TAAQ","label":"Miscellaneous Category (Portal, UI, Maximo, Install)"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.0;7.6.0;7.6.1"}]

Document Information

Modified date:
21 October 2020

UID

swg21593021

Page Feedback