TIM不能修改密码问题之表空间清理

字数 62414阅读 4252评论 0赞 0

<DIV><STRONG>
<P> </P>问题：TIM4.6突然不能修改账户密码</STRONG></DIV>
<DIV>如图</DIV>
<DIV><a class="example-image-link" href="http://www.tivolichina.net/home/attachment/201102/23/356_12984446398G9n.jpg" data-lightbox="example-set"><img class="example-image" src="http://www.tivolichina.net/home/attachment/201102/23/356_12984446398G9n.jpg"   ></a></DIV>
<DIV> </DIV>
<DIV><STRONG>trace中报类似如下错误：</STRONG></DIV>
<DIV><Trace Level="MIN"><BR> <Time Millis="1283842804048"> 2010.09.07 15:00:04.048+08:00</Time><BR> <Server Format="IP">tim.**.**.**</Server><BR> <ProductId>CTGIM</ProductId><BR> <Component>com.ibm.itim.messaging.mdb</Component><BR> <ProductInstance>server1</ProductInstance><BR> <LogText><![CDATA[Caught exception, will mark for rollback]]></LogText><BR> <Source FileName="com.ibm.itim.messaging.mdb.CompletionListenerRegistryBean" Method="beforeCompletion"/><BR> <Thread>Servlet.Engine.Transports : 14</Thread><BR> <Exception><![CDATA[Process ID: 0<BR>Activity ID: 0<BR>com.ibm.itim.workflow.engine.RemoteServiceFailure: CTGIMO006E The following SQL error occurred.<BR>Error: -289 <BR>SQL State: 57011</DIV>
<DIV> at com.ibm.itim.workflow.engine.RemoteServiceFailure.wrapException(RemoteServiceFailure.java:66)<BR> at com.ibm.itim.workflow.engine.ProcessWriteOperation.execute(ProcessWriteOperation.java:65)<BR> at com.ibm.itim.workflow.engine.DeferredWriteManager.flush(DeferredWriteManager.java:119)<BR> at com.ibm.itim.workflow.engine.WorkflowDataMediator.flushChanges(WorkflowDataMediator.java:557)<BR> at com.ibm.itim.workflow.engine.WorkflowDataMediator.beforeCompletion(WorkflowDataMediator.java:570)<BR> at com.ibm.itim.messaging.mdb.CompletionListenerRegistryBean.beforeCompletion(CompletionListenerRegistryBean.java:202)<BR> at com.ibm.ejs.container.CMStatefulBeanO.beforeCompletion(CMStatefulBeanO.java:356)<BR> at com.ibm.ejs.container.ContainerTx.beforeCompletion(ContainerTx.java(Compiled Code))<BR> at com.ibm.ejs.util.tran.SyncDriver.beforeCompletion(SyncDriver.java(Compiled Code))<BR> at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java(Compiled Code))<BR> at com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java(Compiled Code))<BR> at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java(Compiled Code))<BR> at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java(Compiled Code))<BR> at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java(Compiled Code))<BR> at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java(Compiled Code))<BR> at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled Code))<BR> at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java(Compiled Code))<BR> at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled Code))<BR> at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2946)<BR> at com.ibm.itim.apps.ejb.organization.account.EJSRemoteStatelessenroleejb_PasswordManagerHome_0020c63d.submitPasswordSynchronize(Unknown Source)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)<BR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))<BR> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)<BR> at java.security.AccessController.doPrivileged1(Native Method)<BR> at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)<BR> at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1179)<BR> at $Proxy5.submitPasswordSynchronize(Unknown Source)<BR> at com.ibm.itim.apps.ejb.organization.account._PasswordManager_Stub.submitPasswordSynchronize(_PasswordManager_Stub.java:580)<BR> at com.ibm.itim.apps.provisioning.PasswordManager$7.run(PasswordManager.java:769)<BR> at com.ibm.itim.apps.impl.websphere.WebSpherePlatformContextImpl.doAs(WebSpherePlatformContextImpl.java:117)<BR> at com.ibm.itim.apps.provisioning.PasswordManager.submitPasswordSynchronize(PasswordManager.java:765)<BR> at com.ibm.itim.apps.provisioning.PasswordManager.synchPasswords(PasswordManager.java:556)<BR> at com.mdcl.mocha.utils.Loginsms.login(Loginsms.java:99)<BR> at org.apache.jsp._respwd._jspService(_respwd.java:82)<BR> at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:388)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:745)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:843)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)<BR> at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)<BR> at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)<BR> at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)<BR> at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:120)<BR> at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:250)<BR> at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)<BR> at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)<BR> at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)<BR> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)<BR>Caused by: com.ibm.itim.workflow.model.type.EntityServiceFailure: CTGIMO006E The following SQL error occurred.<BR>Error: -289 <BR>SQL State: 57011</DIV>
<DIV> at com.ibm.itim.workflow.model.type.EntityServiceFailure.wrapEntityServiceFailure(EntityServiceFailure.java:63)<BR> at com.ibm.itim.workflow.model.type.ProcessStore.create(ProcessStore.java:221)<BR> at com.ibm.itim.workflow.engine.ProcessWriteOperation.execute(ProcessWriteOperation.java:45)<BR> ... 62 more<BR>Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0289N  不能在表空间 "ENROLE_INDEXES" 中分配新页。  SQLSTATE=57011</DIV>
<DIV> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)<BR> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)<BR> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)<BR> at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)<BR> at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown Source)<BR> at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:496)<BR> at com.ibm.itim.workflow.model.type.ProcessStore.create(ProcessStore.java:206)<BR> ... 63 more<BR>]]></Exception><BR></Trace></DIV>
<DIV> </DIV>
<DIV><STRONG>was日志报类似如下错误：</STRONG></DIV>
<DIV> </DIV>
<DIV>[10-9-7 14:54:54:239 CST] 77ee13da ExceptionUtil E CNTR0020E: 在 bean“BeanId(enRole#wf_ejb.jar#wf_ejb.enroleejb.ProcessManagerHome, null)”上处理方法“getProcessInfo”时发生非应用程序异常。异常数据：javax.ejb.EJBException: nested exception is: com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708392560376214419 <BR>com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708392560376214419 <BR> at com.ibm.itim.workflow.model.type.ProcessStore.getInfo(ProcessStore.java:556)<BR> at com.ibm.itim.workflow.admin.ejb.ProcessManagerBean.getProcessInfo(ProcessManagerBean.java:268)<BR> at com.ibm.itim.workflow.admin.ejb.EJSRemoteStatelesswf_ejb_enroleejb_ProcessManagerH_24f4087f.getProcessInfo(Unknown Source)<BR> at com.ibm.itim.workflow.admin.ejb._ProcessManager_Stub.getProcessInfo(_ProcessManager_Stub.java:593)<BR> at com.ibm.itim.workflow.model.ProcessManager.getProcess(ProcessManager.java:171)<BR> at com.ibm.itim.apps.ejb.request.RequestManagerBean.getWorkflowProcess(RequestManagerBean.java:1930)<BR> at com.ibm.itim.apps.ejb.request.EJSRemoteStatelessenroleejb_RequestManagerHome_84f2fd0e.getWorkflowProcess(Unknown Source)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)<BR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))<BR> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)<BR> at java.security.AccessController.doPrivileged1(Native Method)<BR> at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)<BR> at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1179)<BR> at $Proxy7.getWorkflowProcess(Unknown Source)<BR> at com.ibm.itim.apps.ejb.request._RequestManager_Stub.getWorkflowProcess(_RequestManager_Stub.java:794)<BR> at com.ibm.itim.apps.Request$2.run(Request.java:215)<BR> at com.ibm.itim.apps.impl.websphere.WebSpherePlatformContextImpl.doAs(WebSpherePlatformContextImpl.java:117)<BR> at com.ibm.itim.apps.Request.getProcess(Request.java:210)<BR> at com.ibm.itim.apps.Request.getStatus(Request.java:143)<BR> at com.mdcl.mocha.utils.Loginsms.login(Loginsms.java:101)<BR> at org.apache.jsp._respwd._jspService(_respwd.java:82)<BR> at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:388)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:745)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:843)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)<BR> at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)<BR> at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)<BR> at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)<BR> at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)<BR> at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)<BR> at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)<BR> at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)<BR> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)<BR>javax.ejb.EJBException: nested exception is: com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708392560376214419 <BR> at com.ibm.itim.workflow.admin.ejb.ProcessManagerBean.getProcessInfo(ProcessManagerBean.java:274)<BR> at com.ibm.itim.workflow.admin.ejb.EJSRemoteStatelesswf_ejb_enroleejb_ProcessManagerH_24f4087f.getProcessInfo(Unknown Source)<BR> at com.ibm.itim.workflow.admin.ejb._ProcessManager_Stub.getProcessInfo(_ProcessManager_Stub.java:593)<BR> at com.ibm.itim.workflow.model.ProcessManager.getProcess(ProcessManager.java:171)<BR> at com.ibm.itim.apps.ejb.request.RequestManagerBean.getWorkflowProcess(RequestManagerBean.java:1930)<BR> at com.ibm.itim.apps.ejb.request.EJSRemoteStatelessenroleejb_RequestManagerHome_84f2fd0e.getWorkflowProcess(Unknown Source)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)<BR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))<BR> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)<BR> at java.security.AccessController.doPrivileged1(Native Method)<BR> at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)<BR> at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1179)<BR> at $Proxy7.getWorkflowProcess(Unknown Source)<BR> at com.ibm.itim.apps.ejb.request._RequestManager_Stub.getWorkflowProcess(_RequestManager_Stub.java:794)<BR> at com.ibm.itim.apps.Request$2.run(Request.java:215)<BR> at com.ibm.itim.apps.impl.websphere.WebSpherePlatformContextImpl.doAs(WebSpherePlatformContextImpl.java:117)<BR> at com.ibm.itim.apps.Request.getProcess(Request.java:210)<BR> at com.ibm.itim.apps.Request.getStatus(Request.java:143)<BR> at com.mdcl.mocha.utils.Loginsms.login(Loginsms.java:101)<BR> at org.apache.jsp._respwd._jspService(_respwd.java:82)<BR> at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:388)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:745)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:843)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)<BR> at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)<BR> at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)<BR> at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)<BR> at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)<BR> at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)<BR> at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)<BR> at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)<BR> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)</DIV>
<DIV>[10-9-7 14:56:13:585 CST] 77ebd3da ExceptionUtil E CNTR0020E: 在 bean“BeanId(enRole#wf_ejb.jar#wf_ejb.enroleejb.ProcessManagerHome, null)”上处理方法“getProcessInfo”时发生非应用程序异常。异常数据：javax.ejb.EJBException: nested exception is: com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708733403262704062 <BR>com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708733403262704062 <BR> at com.ibm.itim.workflow.model.type.ProcessStore.getInfo(ProcessStore.java:556)<BR> at com.ibm.itim.workflow.admin.ejb.ProcessManagerBean.getProcessInfo(ProcessManagerBean.java:268)<BR> at com.ibm.itim.workflow.admin.ejb.EJSRemoteStatelesswf_ejb_enroleejb_ProcessManagerH_24f4087f.getProcessInfo(Unknown Source)<BR> at com.ibm.itim.workflow.admin.ejb._ProcessManager_Stub.getProcessInfo(_ProcessManager_Stub.java:593)<BR> at com.ibm.itim.workflow.model.ProcessManager.getProcess(ProcessManager.java:171)<BR> at com.ibm.itim.apps.ejb.request.RequestManagerBean.getWorkflowProcess(RequestManagerBean.java:1930)<BR> at com.ibm.itim.apps.ejb.request.EJSRemoteStatelessenroleejb_RequestManagerHome_84f2fd0e.getWorkflowProcess(Unknown Source)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)<BR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))<BR> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)<BR> at java.security.AccessController.doPrivileged1(Native Method)<BR> at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)<BR> at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1179)<BR> at $Proxy7.getWorkflowProcess(Unknown Source)<BR> at com.ibm.itim.apps.ejb.request._RequestManager_Stub.getWorkflowProcess(_RequestManager_Stub.java:794)<BR> at com.ibm.itim.apps.Request$2.run(Request.java:215)<BR> at com.ibm.itim.apps.impl.websphere.WebSpherePlatformContextImpl.doAs(WebSpherePlatformContextImpl.java:117)<BR> at com.ibm.itim.apps.Request.getProcess(Request.java:210)<BR> at com.ibm.itim.apps.Request.getStatus(Request.java:143)<BR> at com.mdcl.mocha.utils.Loginsms.login(Loginsms.java:101)<BR> at org.apache.jsp._respwd._jspService(_respwd.java:82)<BR> at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:388)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:745)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:843)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)<BR> at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)<BR> at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)<BR> at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)<BR> at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)<BR> at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)<BR> at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)<BR> at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)<BR> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))<BR>javax.ejb.EJBException: nested exception is: com.ibm.itim.workflow.model.type.MissingEntity: CTGIMA416E The following process cannot be found in the database.<BR>Process ID: 7708733403262704062 <BR> at com.ibm.itim.workflow.admin.ejb.ProcessManagerBean.getProcessInfo(ProcessManagerBean.java:274)<BR> at com.ibm.itim.workflow.admin.ejb.EJSRemoteStatelesswf_ejb_enroleejb_ProcessManagerH_24f4087f.getProcessInfo(Unknown Source)<BR> at com.ibm.itim.workflow.admin.ejb._ProcessManager_Stub.getProcessInfo(_ProcessManager_Stub.java:593)<BR> at com.ibm.itim.workflow.model.ProcessManager.getProcess(ProcessManager.java:171)<BR> at com.ibm.itim.apps.ejb.request.RequestManagerBean.getWorkflowProcess(RequestManagerBean.java:1930)<BR> at com.ibm.itim.apps.ejb.request.EJSRemoteStatelessenroleejb_RequestManagerHome_84f2fd0e.getWorkflowProcess(Unknown Source)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)<BR> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)<BR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))<BR> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:727)<BR> at java.security.AccessController.doPrivileged1(Native Method)<BR> at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))<BR> at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:725)<BR> at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1179)<BR> at $Proxy7.getWorkflowProcess(Unknown Source)<BR> at com.ibm.itim.apps.ejb.request._RequestManager_Stub.getWorkflowProcess(_RequestManager_Stub.java:794)<BR> at com.ibm.itim.apps.Request$2.run(Request.java:215)<BR> at com.ibm.itim.apps.impl.websphere.WebSpherePlatformContextImpl.doAs(WebSpherePlatformContextImpl.java:117)<BR> at com.ibm.itim.apps.Request.getProcess(Request.java:210)<BR> at com.ibm.itim.apps.Request.getStatus(Request.java:143)<BR> at com.mdcl.mocha.utils.Loginsms.login(Loginsms.java:101)<BR> at org.apache.jsp._respwd._jspService(_respwd.java:82)<BR> at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:388)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:745)<BR> at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:843)<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)<BR> at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)<BR> at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)<BR> at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)<BR> at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)<BR> at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)<BR> at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)<BR> at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)<BR> at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)<BR> at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)<BR> at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)<BR> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))</DIV>
<DIV> </DIV>
<DIV><STRONG>综合以上现象，判断表空间可能有问题</STRONG></DIV>
<DIV><STRONG>查看数据库表空间状态：</STRONG></DIV>
<DIV> </DIV>
<DIV>db2 => connect to ITIMDB </DIV>
<DIV>   Database Connection Information</DIV>
<DIV> Database server        = DB2/AIX64 8.2.7<BR> SQL authorization ID   = DB2TIM<BR> Local database alias   = ITIMDB</DIV>
<DIV>db2 => list tablespaces show detail</DIV>
<DIV>           Tablespaces for Current Database</DIV>
<DIV> Tablespace ID                        = 0<BR> Name                                 = SYSCATSPACE<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 6546<BR> Useable pages                        = 6546<BR> Used pages                           = 6546<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 1<BR> Name                                 = TEMPSPACE1<BR> Type                                 = System managed space<BR> Contents                             = System Temporary data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 1<BR> Useable pages                        = 1<BR> Used pages                           = 1<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 2<BR> Name                                 = USERSPACE1<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 34<BR> Useable pages                        = 34<BR> Used pages                           = 34<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 3<BR> Name                                 = SYSTOOLSPACE<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 97<BR> Useable pages                        = 97<BR> Used pages                           = 97<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 4<BR> Name                                 = ENROLE_DATA<BR> Type                                 = Database managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 16384<BR> Useable pages                        = 16352<BR> Used pages                           = 16000<BR> Free pages                           = 352<BR> High water mark (pages)              = 16000<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 5<BR> Name                                 = ENROLE_INDEXES<BR> Type                                 = Database managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 8192<BR> Useable pages                        = 8160<BR> Used pages                           = 4864<BR> Free pages                           = 3296<BR> High water mark (pages)              = 4864<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 6<BR> Name                                 = TEMP_DATA<BR> Type                                 = Database managed space<BR> Contents                             = System Temporary data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 8192<BR> Useable pages                        = 8160<BR> Used pages                           = 64<BR> Free pages                           = 8096<BR> High water mark (pages)              = 64<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV> </DIV>
<DIV><STRONG>发现已满，因为TIM数据里存在的都是TIM日志信息，所以可以清理，重新配置。</STRONG></DIV>
<DIV> </DIV>
<DIV><STRONG>清理表空间如下：</STRONG></DIV>
<DIV> </DIV>
<DIV>数据库所在机器（）</DIV>
<DIV>list tablespaces show detail</DIV>
<DIV>quiesce database immediate</DIV>
<DIV>connect reset</DIV>
<DIV>backup database ITIMDB to /appdata/back/ITIMDBbackup</DIV>
<DIV><BR>connect to ITIMDB</DIV>
<DIV>unquiesce database</DIV>
<DIV>在TIM安装机器（）</DIV>
<DIV>/opt/IBM/itim/bin<BR>. /home/db2tim/sqllib/db2profile<BR>./DBConfig</DIV>
<DIV>在显示的界面中仅输入下面三个域的信息，其它的不要动：<BR>数据库名字：  如 ITIMDB<BR>数据库实例用户：  如 db2inst1<BR>数据库实例用户口令：  如 pwdXXX</DIV>
<DIV>点 test按钮，成功后，点 continue<BR>系统会提示数据库已经存在，是否Drop,回答YES<BR>经过若干分钟成功后（时间可能很长，建议周六晚上做），窗口自动关闭</DIV>
<DIV>完成后检查表空间，已经为初始化状态</DIV>
<DIV>重启数据库，重启TIM</DIV>
<DIV> </DIV>
<DIV>清理后</DIV>
<DIV>db2 => connect to ITIMDB</DIV>
<DIV>   Database Connection Information</DIV>
<DIV> Database server        = DB2/AIX64 8.2.7<BR> SQL authorization ID   = DB2TIM<BR> Local database alias   = ITIMDB</DIV>
<DIV>db2 => list tablespaces show detail</DIV>
<DIV>           Tablespaces for Current Database</DIV>
<DIV> Tablespace ID                        = 0<BR> Name                                 = SYSCATSPACE<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 6546<BR> Useable pages                        = 6546<BR> Used pages                           = 6546<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 1<BR> Name                                 = TEMPSPACE1<BR> Type                                 = System managed space<BR> Contents                             = System Temporary data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 1<BR> Useable pages                        = 1<BR> Used pages                           = 1<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 2<BR> Name                                 = USERSPACE1<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 34<BR> Useable pages                        = 34<BR> Used pages                           = 34<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 3<BR> Name                                 = SYSTOOLSPACE<BR> Type                                 = System managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 97<BR> Useable pages                        = 97<BR> Used pages                           = 97<BR> Free pages                           = Not applicable<BR> High water mark (pages)              = Not applicable<BR> Page size (bytes)                    = 4096<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 32<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 4<BR> Name                                 = ENROLE_DATA<BR> Type                                 = Database managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 16384<BR> Useable pages                        = 16352<BR> Used pages                           = 5408<BR> Free pages                           = 10944<BR> High water mark (pages)              = 5408<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 5<BR> Name                                 = ENROLE_INDEXES<BR> Type                                 = Database managed space<BR> Contents                             = Any data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 8192<BR> Useable pages                        = 8160<BR> Used pages                           = 2656<BR> Free pages                           = 5504<BR> High water mark (pages)              = 2656<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV> Tablespace ID                        = 6<BR> Name                                 = TEMP_DATA<BR> Type                                 = Database managed space<BR> Contents                             = System Temporary data<BR> State                                = 0x0000<BR>   Detailed explanation:<BR>     Normal<BR> Total pages                          = 8192<BR> Useable pages                        = 8160<BR> Used pages                           = 64<BR> Free pages                           = 8096<BR> High water mark (pages)              = 64<BR> Page size (bytes)                    = 32768<BR> Extent size (pages)                  = 32<BR> Prefetch size (pages)                = 16<BR> Number of containers                 = 1</DIV>
<DIV>结果TIM恢复应用。</DIV>

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

TIM不能修改密码问题之表空间清理

添加新评论0 条评论

作者其他文章