This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Maximo 7.5 Websphere
Following this post:
http://www-01.ibm.com/support/docview.wss?uid=swg21432944
I decided to comment out a few lines (attributes) that pertained to the work/communication log in the Library.xml
I was able to import the Library.xml without any errors. When I tried to restart the app server I received the following error. Since i cannot start the Maximo application I decided to go into the MAXPRESENTATIONS object from the back end and replace the data in the PRESENTATION attribute with my original out of the box Library.xml.
I converted it to a single line and copy and pasted it into the BLOB attribute, but the Maximo app server will not restart.
I wish I would have never tried this.
From the Systemerr.log
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R java.lang.NullPointerException
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DBManager.getDBConnUsed(DBManager.java:2011)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DBManager.getDBConnTotal(DBManager.java:2004)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.printDBManagerLog(DbConnectionWatchDog.java:517)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.log(DbConnectionWatchDog.java:437)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.log(DbConnectionWatchDog.java:317)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.run(DbConnectionWatchDog.java:195)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at java.util.Timer$TimerImpl.run(Timer.java:295)
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R java.lang.OutOfMemoryError: native memory exhausted
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R at java.lang.ClassLoader.defineClassImpl(Native Method)
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R at java.lang.ClassLoader.defineClass(ClassLoader.java:275)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:69)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader._defineClass(CompoundClassLoader.java:773)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.localFindClass(CompoundClassLoader.java:688)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:511)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at java.lang.ClassLoader.loadClass(ClassLoader.java:619)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at psdi.util.logging.MXLoggerFactory.getFactory(MXLoggerFactory.java:77)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at psdi.util.logging.MXLoggerFactory.getLogger(MXLoggerFactory.java:174)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at psdi.iface.jms.JMSListenerBean.<clinit>(JMSListenerBean.java:53)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initializeImpl(Native Method)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initialize(J9VMInternals.java:167)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.newInstanceImpl(Native Method)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.Class.newInstance(Class.java:1345)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.loadBeanMetaData(EJSContainer.java:1998)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at com.ibm.ejs.container.HomeOfHomes.loadBeanMetaData(HomeOfHomes.java:1140)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.HomeRecord.getHomeAndInitialize(HomeRecord.java:444)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.getHomeWrapperCommon(EJSContainer.java:1549)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.getHomeInstance(EJSContainer.java:1289)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.startBean(EJSContainer.java:1273)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.startBean(EJBContainerImpl.java:3489)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.startModule(EJBContainerImpl.java:2681)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.start(EJBContainerImpl.java:3826)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1122)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1319)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:610)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:944)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:725)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl$1.run(ApplicationMgrImpl.java:1266)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4672)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4760)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplicationDynamically(ApplicationMgrImpl.java:1271)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2043)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:439)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:382)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.startCompositionUnit(CompositionUnitMgrImpl.java:653)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.startCompositionUnit(CompositionUnitMgrImpl.java:615)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:1177)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:49)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:256)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1085)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:966)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1332)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1225)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:181)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.CallRouter.route(CallRouter.java:242)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.IPCConnectorInboundLink.doWork(IPCConnectorInboundLink.java:353)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.IPCConnectorInboundLink$IPCConnectorReadCallback.complete(IPCConnectorInboundLink.java:595)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[2/10/14 8:12:28:157 EST] 00000021 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
It’s a binary object
You could try asking your dba to connect to another database and update the record from the other database
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 10 February 2014 13:21
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Error after changing Library.xml
Maximo 7.5 Websphere
Following this post:
http://www-01.ibm.com/support/docview.wss?uid=swg21432944
I decided to comment out a few lines (attributes) that pertained to the work/communication log in the Library.xml
I was able to import the Library.xml without any errors. When I tried to restart the app server I received the following error. Since i cannot start the Maximo application I decided to go into the MAXPRESENTATIONS object from the back end and replace the data in the PRESENTATION attribute with my original out of the box Library.xml.
I converted it to a single line and copy and pasted it into the BLOB attribute, but the Maximo app server will not restart.
I wish I would have never tried this.
From the Systemerr.log
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R java.lang.NullPointerException
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R &n! bsp; at psdi.server.DBManager.getDBConnUsed(DBManager.java:2011)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DBManager.getDBConnTotal(DBManager.java:2004)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.printDBManagerLog(DbConnectionWatchDog.java:517)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.log(DbConnectionWatchDog.java:437)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.log(DbConnectionWatchDog.java:317)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at psdi.server.DbConnectionWatchDog.run(DbConnectionWatchDog.java:195)
[2/10/14 8:09:26:135 EST] 00000053 SystemErr R at java! .util.Timer$TimerImpl.run(Timer.java:295)
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R java.lang.OutOfMemoryError: native memory exhausted
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R at java.lang.ClassLoader.defineClassImpl(Native Method)
[2/10/14 8:12:28:147 EST] 00000021 SystemErr R at java.lang.ClassLoader.defineClass(ClassLoader.java:275)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:69)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader._defineClass(CompoundClassLoader.java:773)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.localFindClass(CompoundClassLoad! er.java:688)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:511)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at java.lang.ClassLoader.loadClass(ClassLoader.java:619)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at psdi.util.logging.MXLoggerFactory.getFactory(MXLoggerFactory.java:77)
[2/10/14 8:12:28:148 EST] 00000021 SystemErr R at psdi.util.logging.MXLoggerFactory.getLogger(MXLoggerFactory.java:174)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at psdi.iface.jms.JMSListenerBean.<clinit>(JMSListenerBean.java:53)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initializeImpl(Native Method! )
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.initialize(J9VMInternals.java:167)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.J9VMInternals.newInstanceImpl(Native Method)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at java.lang.Class.newInstance(Class.java:1345)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.loadBeanMetaData(EJSContainer.java:1998)
[2/10/14 8:12:28:149 EST] 00000021 SystemErr R at com.ibm.ejs.container.HomeOfHomes.loadBeanMetaData(HomeOfHomes.java:1140)
[2/10/14 8:12:28:150 EST] 00000021 Syste! mErr R at com.ibm.ejs.container.HomeRecord.getHomeAndInitialize(HomeRecord.java:444)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.getHomeWrapperCommon(EJSContainer.java:1549)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.getHomeInstance(EJSContainer.java:1289)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ejs.container.EJSContainer.startBean(EJSContainer.java:1273)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.startBean(EJBContainerImpl.java:3489)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.startModule(EJBContainerImp! l.java:2681)
[2/10/14 8:12:28:150 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.EJBContainerImpl.start(EJBContainerImpl.java:3826)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1122)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1319)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:610)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:944)
[2/10/14 8:12:28:151 EST] 00000021 System! Err R at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:725)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl$1.run(ApplicationMgrImpl.java:1266)
[2/10/14 8:12:28:151 EST] 00000021 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4672)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4760)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.Appli! cationMgrImpl.startApplicationDynamically(ApplicationMgrImpl.java:1271)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2043)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:439)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123)
[2/10/14 8:12:28:152 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:382)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.startCompositionUnit(CompositionUn! itMgrImpl.java:653)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.startCompositionUnit(CompositionUnitMgrImpl.java:615)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:1177)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr ! ; R at java.lang.reflect.Method.invoke(Method.java:611)
[2/10/14 8:12:28:153 EST] 00000021 SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:49)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:256)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at javax.management.modelmb! ean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1085)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:966)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848)
[2/10/14 8:12:28:154 EST] 00000021 SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1332)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[2/10/14 8:12:28:155 EST] 0000! 0021 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1225)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:181)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.CallRouter.route(CallRouter.java:242)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.IPCConnectorInboundLink.doWork(IPCConnectorInboundLink.java:353)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr R at com.ibm.ws.management.connector.ipc.IPCConnectorInboundLink$IPCConnectorReadCallback.complete(IPCConnectorInboundLink.java:595)
[2/10/14 8:12:28:155 EST] 00000021 SystemErr ! R at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler.c! omplete(ResultHandler.java:204)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[2/10/14 8:12:28:156 EST] 00000021 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[2/10/14 8:12:28:157 EST] 00000021 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Thanks Ian.
My database tool has a BLOB editor. Will this not work to copy and paste the single line .xml?
http://www.sqlmaestro.com/products/anysql/maestro/help/05_03_00_blob_editor/
You might want to take a look at the install scripts to see if you can lift the syntax they use from there or, if now, maybe create a second schema MAXTEMP and run the installer to build the tables there and copy it over. Do you have another database? The cleanest way to restore this is an INSERT INTO ... SELECT FROM to get things working again. Chris.
On February 10, 2014 at 7:34:15 AM MST, mlevinson@ledgesoft.com wrote: Thanks Ian. My database tool has a BLOB editor. Will this not work to copy and paste the single line .xml?http://www.sqlmaestro.com/products/anysql/maestro/help/05_03_00_blob_editor/
Chris,
I do have another database but unfortunately it is an Oracle DB. We converted that instance from Oracle to DB2 some time ago.
Can you install another DB2 or have a dba restore the table from a backup?
On February 10, 2014 at 7:48:11 AM MST, mlevinson@ledgesoft.com wrote: Chris,I do have another database but unfortunately it is an Oracle DB. We converted that instance from Oracle to DB2 some time ago.
Chris,
Is it possible to restore that table from a backup but only where the APP = "LIBRARY"?
I can't speak for db2 but I'd say it should be possible, yes. For example on Oracle you could restore the table to a different schema or a different name then delete the offending row in your primary table and replace it with an insert into ... Select from backup table where APP='LIBRARY'
On February 10, 2014 at 8:03:59 AM MST, wrote: Chris, Is it possible to restore that table from a backup but only where the APP = "LIBRARY"?
Do this
Go here
\\ you server \your drive\apps\ibm\SMP\maximo\tools\maximo\en<file:///\\ABZ-WMSdev-01.gdfbrit.local\e$\apps\ibm\SMP\maximo\tools\maximo\en>
Open
Maximo.db2
select maxpresentationid from maxpresentation where app = 'LIBRARY'
it should return 20191
find the first entry
should be an insert highlight everything down to the last entry
where maxpresentation id = 20191
paste into your sql tool
add this at the very beginning
delete from maxpresentation where maxpresentationid = 20191
;
commit
;
Take a back up of your datebase
Run the whole script
Ps I’ve sent you the file direct but follow the above if you don’t get it
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 10 February 2014 15:04
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: Error after changing Library.xml
Chris,
Is it possible to restore that table from a backup but only where the APP = "LIBRARY"?
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
BACK UP YOUR DATABASE –
Also make sure you do a final
commit:
at the very end of the script
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 10 February 2014 15:29
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] RE: Error after changing Library.xml
Do this
Go here
\\ you server \your drive\apps\ibm\SMP\maximo\tools\maximo\en<file:///\\ABZ-WMSdev-01.gdfbrit.local\e$\apps\ibm\SMP\maximo\tools\maximo\en>
Open
Maximo.db2
select maxpresentationid from maxpresentation where app = 'LIBRARY'
it should return 20191
find the first entry
should be an insert highlight everything down to the last entry
where maxpresentation id = 20191
paste into your sql tool
add this at the very beginning
delete from maxpresentation where maxpresentationid = 20191
;
commit
;
Take a back up of your datebase
Run the whole script
Ps I’ve sent you the file direct but follow the above if you don’t get it
Rgds Ian
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com<mailto:mlevinson@ledgesoft.com>
Sent: 10 February 2014 15:04
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] RE: Error after changing Library.xml
Chris,
Is it possible to restore that table from a backup but only where the APP = "LIBRARY"?
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
****************************************************************************************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
****************************************************************************************************************************************************************************************