com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid

[preddy]

com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid

Any Idea About this Errors. We are getting the errors when we try to access the tasks. Finally it will gice the error saying that Server taking Excessive time to process your Request.

25 Apr 2008 10:11:15,903 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid. com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
25 Apr 2008 10:11:15,905 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid. com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
25 Apr 2008 10:11:15,923 [SEVERE] - [TE] setRoleFilterEntry: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid. com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
at com.jdedwards.database.impl.transaction.JDBClosedState.markBeforeOperation(Unknown Source)
at com.jdedwards.database.impl.transaction.JDBLogicalTransaction.markBeforeOperation(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.businessview.JDBBusinessViewAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.get(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.db.services.RoleFilterLookup.getRoleFilter(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.BeanCache.setRoleFilterEntry(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.BeanCache.<init>(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TETaskBuilder.buildMenuTask(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.getChildTasks(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.buildBean(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.services.LocalTEDataService.getMenu(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.Node.getAllChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.WebInteractiveTree.toStringBufferStatic(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doChildNode(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doService(Unknown Source)
at com.peoplesoft.e1.container.extensions.HiddenIframeMafletService.service(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doService(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136)
at com.jdedwards.base.JDEFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1936)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:114)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471)
25 Apr 2008 10:11:15,929 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid. com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
25 Apr 2008 10:11:15,929 [SEVERE] - [TE] BeanCache - getObjectEntry for objId: P40205: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid. com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid.
at com.jdedwards.database.impl.transaction.JDBClosedState.markBeforeOperation(Unknown Source)
at com.jdedwards.database.impl.transaction.JDBLogicalTransaction.markBeforeOperation(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.businessview.JDBBusinessViewAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.get(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.db.services.E1ObjectLookup.getE1Object(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.BeanCache.getObjectEntry(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.BeanCache.<init>(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TETaskBuilder.buildMenuTask(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.getChildTasks(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.buildBean(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.services.LocalTEDataService.getMenu(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.Node.getAllChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.WebInteractiveTree.toStringBufferStatic(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doChildNode(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doService(Unknown Source)
at com.peoplesoft.e1.container.extensions.HiddenIframeMafletService.service(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doService(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136)
at com.jdedwards.base.JDEFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1936)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:114)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471)
25 Apr 2008 10:11:15,957 [SEVERE] - [TE] Error encountered getting menu data: null java.lang.NullPointerException
java.lang.NullPointerException
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.servletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.processRequest(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.getPersonalSpec(Unknown Source)
at com.jdedwards.jas.net.NetManager.getSpec(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.BeanCache.getAppSpec(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TETaskBuilder.getEntryForm(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TETaskBuilder.getForm(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TETaskBuilder.buildMenuTask(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.getChildTasks(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.base.TEMenuRequest.buildBean(Unknown Source)
at com.jdedwards.taskexplorer.dataservice.services.LocalTEDataService.getMenu(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.TaskNode.getChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.Node.getAllChildren(Unknown Source)
at com.peoplesoft.e1.menu.tree.WebInteractiveTree.toStringBufferStatic(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doChildNode(Unknown Source)
at com.peoplesoft.e1.menu.services.MenuService.doService(Unknown Source)
at com.peoplesoft.e1.container.extensions.HiddenIframeMafletService.service(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doService(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136)
at com.jdedwards.base.JDEFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1936)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:114)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:207)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:109)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471)

 

[Beth Green]

Re: com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid

We just got the same message.
We are on 8.12 with tools 8.97.1.3. Enterprise is iSeries V5R4 with Windows 2003 Web server using Websphere 6.1.0.9
Did you ever determine the source/resolution of the error ? I restarted the web server and it was okay again.

 

[jccastro]

Re: com.jdedwards.database.base.JDBException: [TRANSACTION_STATE_NOT_VALID] Transaction state is not valid

I have the same error

How you resolve it ???

Thank's