com.ibm.wps.util.DataBackendException: EJPDB0099E: Error occurred during database access. Last SQL statement is [SELECT RES_TYPE, EXTERNAL_OID, EXTERNAL_UID FROM customization.PROT_RES WHERE (OWNER_UID = ?)]. Transaction has status [STATUS_MARKED_ROLLBACK], global ID [0000011d8bb4b81b000000010000151a224d217b30407647b15f4413a13f72ae081ba2f80000011d8bb4b81b000000010000151a224d217b30407647b15f4413a13f72ae081ba2f800000001] and local ID [5402].

lotus.com | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Lotus Quickr Forum : RE: Cant Add/Delete Portlets in Websphere Portal Server

    lotus.com | 6 months ago
    com.ibm.wps.util.DataBackendException: EJPDB0099E: Error occurred during database access. Last SQL statement is [SELECT RES_TYPE, EXTERNAL_OID, EXTERNAL_UID FROM customization.PROT_RES WHERE (OWNER_UID = ?)]. Transaction has status [STATUS_MARKED_ROLLBACK], global ID [0000011d8bb4b81b000000010000151a224d217b30407647b15f4413a13f72ae081ba2f80000011d8bb4b81b000000010000151a224d217b30407647b15f4413a13f72ae081ba2f800000001] and local ID [5402].
  2. 0

    Occasional XA resource errors with WAS+Oracle

    Google Groups | 9 years ago | Tuft
    java.sql.SQLException: enlist: caught Exception
  3. 0

    Hibernate: java.sql.SQLException: Attempt to continue working after transaction rolledback

    Stack Overflow | 5 years ago | BobadKanda
    java.sql.SQLException: Attempt to continue working after transaction rolledback !
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error on Expression Query - java.sql.SQLException: DSRA9420E

    Oracle Community | 5 years ago | amehta5
    java.sql.SQLException: DSRA9420E: Connection cannot be reassociated because child objects are still open.

    Root Cause Analysis

    1. java.sql.SQLException

      enlist: caught Exception

      at com.ibm.ws.rsadapter.AdapterUtil.toSQLException()
    2. com.ibm.ws
      WSJdbcConnection.prepareStatement
      1. com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1322)
      2. com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:681)
      3. com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2043)
      4. com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1998)
      4 frames
    3. com.ibm.wps
      PortletDelegateImpl.dispatch
      1. com.ibm.wps.datastore.impl.DataStoreContext.prepareStatement(DataStoreContext.java:517)
      2. com.ibm.wps.datastore.impl.ResourcePersister.executeSelect(ResourcePersister.java:2298)
      3. com.ibm.wps.datastore.impl.ResourcePersister.findObjectIDs(ResourcePersister.java:1804)
      4. com.ibm.wps.datastore.ac.impl.ProtectedResourcePersister.findOIDsByOwner(ProtectedResourcePersister.java:301)
      5. com.ibm.wps.datastore.ac.impl.ProtectedResourceHomeImpl.findOIDsByOwner(ProtectedResourceHomeImpl.java:140)
      6. com.ibm.wps.ac.impl.ResourceManagerDataAccess.loadResourceOIDsByOwner(ResourceManagerDataAccess.java:494)
      7. com.ibm.wps.ac.impl.ResourceManager.loadOwnedResourceOIDs(ResourceManager.java:942)
      8. com.ibm.wps.ac.impl.AccessControlConfigImpl.loadOwnedResources(AccessControlConfigImpl.java:1996)
      9. com.ibm.wps.ac.impl.AccessControlConfigFederator.loadOwnedResources(AccessControlConfigFederator.java:454)
      10. com.ibm.wps.command.ac.QueryOwnedResourcesCommand.execute(QueryOwnedResourcesCommand.java:106)
      11. com.ibm.wps.model.content.impl.ContentModelImpl.loadCustomizationMapping(ContentModelImpl.java:427)
      12. com.ibm.wps.model.content.impl.TopologyInvalidatorTask.doItYourself(TopologyInvalidatorTask.java:149)
      13. com.ibm.wps.model.content.impl.ConcurrentTaskSynchronizer.synchronizeTask(ConcurrentTaskSynchronizer.java:133)
      14. com.ibm.wps.model.content.impl.SmartTopologyValidator.makeValid(SmartTopologyValidator.java:193)
      15. com.ibm.wps.model.content.impl.ContentModelImpl.makeValid(ContentModelImpl.java:1065)
      16. com.ibm.wps.model.content.impl.ContentModelImpl.readBegin(ContentModelImpl.java:2131)
      17. com.ibm.wps.model.content.impl.ThreadsafeContentModelImpl.readBegin(ThreadsafeContentModelImpl.java:96)
      18. com.ibm.wps.model.content.impl.ContentModelImpl.getParent(ContentModelImpl.java:1636)
      19. com.ibm.wps.command.composition.AddPortletListCommand.execute(AddPortletListCommand.java:501)
      20. com.ibm.wps.portlets.contentlayout.PageComposer.addControls(PageComposer.java:1498)
      21. com.ibm.wps.portlets.contentlayout.PageComposer.actionPerformed(PageComposer.java:728)
      22. com.ibm.wps.pe.pc.legacy.SPIPortletInterceptorImpl.handleEvents(SPIPortletInterceptorImpl.java:337)
      23. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl._dispatch(PortletDelegateImpl.java:382)
      24. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl.access$200(PortletDelegateImpl.java:70)
      25. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl$Context.callPortlet(PortletDelegateImpl.java:550)
      26. com.ibm.wps.pe.pc.legacy.services.PortletFilterServiceImpl.doFilter(PortletFilterServiceImpl.java:367)
      27. com.ibm.wps.pe.pc.legacy.services.PortletFilter.doFilter(PortletFilter.java:42)
      28. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl.dispatch(PortletDelegateImpl.java:141)
      28 frames
    4. org.apache.jetspeed
      Portlet.doGet
      1. org.apache.jetspeed.portlet.Portlet.doGet(Portlet.java:499)
      1 frame
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
      1 frame
    6. com.ibm.wps
      CacheablePortlet.service
      1. com.ibm.wps.pe.pc.legacy.cache.CacheablePortlet.service(CacheablePortlet.java:120)
      1 frame
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    8. org.apache.jetspeed
      Portlet.service
      1. org.apache.jetspeed.portlet.Portlet.service(Portlet.java:493)
      1 frame
    9. WebSphere
      ServletWrapper.handleRequest
      1. com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1068)
      2. com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:543)
      2 frames
    10. com.ibm.ws
      ServletWrapper.handleRequest
      1. com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
      1 frame
    11. WebSphere
      WebAppRequestDispatcher.include
      1. com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
      1 frame
    12. com.ibm.wps
      Servlet.doGet
      1. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletInvokerImpl.callMethod(PortletInvokerImpl.java:370)
      2. com.ibm.wps.pe.pc.legacy.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:78)
      3. com.ibm.wps.pe.pc.legacy.PortletContainerImpl.callPortletMethod(PortletContainerImpl.java:1125)
      4. com.ibm.wps.pe.pc.legacy.EventEnvironmentImpl.includePortlet(EventEnvironmentImpl.java:171)
      5. com.ibm.wps.pe.pc.legacy.event.ActionEventImpl.prepare(ActionEventImpl.java:201)
      6. com.ibm.wps.pe.pc.legacy.event.EventQueueManager.processEventLoop(EventQueueManager.java:88)
      7. com.ibm.wps.pe.pc.legacy.PortletContainerImpl.performEvents(PortletContainerImpl.java:218)
      8. com.ibm.wps.pe.pc.PortletContainerImpl.performEvents(PortletContainerImpl.java:296)
      9. com.ibm.wps.engine.phases.WPActionPhase.processPortlets(WPActionPhase.java:2461)
      10. com.ibm.wps.engine.phases.WPActionPhase.execute(WPActionPhase.java:678)
      11. com.ibm.wps.state.phases.AbstractActionPhase.next(AbstractActionPhase.java:130)
      12. com.ibm.wps.engine.Servlet.callPortal(Servlet.java:800)
      13. com.ibm.wps.engine.Servlet.doGet(Servlet.java:607)
      13 frames
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
      1 frame
    14. com.ibm.wps
      Servlet.service
      1. com.ibm.wps.engine.Servlet.doFilter(Servlet.java:1184)
      2. com.ibm.wps.resolver.servlet.ContentHandlerCleanup.doFilter(ContentHandlerCleanup.java:648)
      3. com.ibm.wps.resolver.servlet.AbstractFilter.doFilter(AbstractFilter.java:82)
      4. com.ibm.wps.engine.Servlet.service(Servlet.java:1175)
      4 frames
    15. WebSphere
      WebAppFilterChain.doFilter
      1. com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1068)
      2. com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1009)
      3. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
      3 frames
    16. com.ibm.wps
      ExtendedLocaleFilter.doFilter
      1. com.ibm.wps.engine.ExtendedLocaleFilter.doFilter(ExtendedLocaleFilter.java:93)
      1 frame
    17. WebSphere
      WebAppFilterChain.doFilter
      1. com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      2. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      2 frames
    18. com.ibm.wps
      StateCleanup.doFilter
      1. com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java:89)
      1 frame
    19. WebSphere
      WebAppFilterChain.doFilter
      1. com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      2. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      2 frames
    20. com.ibm.wps
      FriendlySelectionFilter.doFilter
      1. com.ibm.wps.resolver.friendly.servlet.FriendlySelectionFilter.doFilter(FriendlySelectionFilter.java:189)
      1 frame
    21. WebSphere
      WebAppFilterChain.doFilter
      1. com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      2. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      2 frames
    22. com.ibm.wps
      VirtualPortalFilter.doFilter
      1. com.ibm.wps.engine.VirtualPortalFilter.doFilter(VirtualPortalFilter.java:88)
      1 frame
    23. WebSphere
      WebAppFilterChain.doFilter
      1. com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      2. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      2 frames
    24. com.ibm.wps
      URLAnalyzer.doFilter
      1. com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java:282)
      1 frame
    25. WebSphere
      ServletWrapper.handleRequest
      1. com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      2. com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      3. com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
      4. com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:771)
      5. com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
      6. com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:539)
      6 frames
    26. com.ibm.ws
      ServletWrapper.handleRequest
      1. com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
      1 frame
    27. WebSphere
      WebContainer.handleRequest
      1. com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3365)
      2. com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:267)
      3. com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:814)
      3 frames
    28. com.ibm.ws
      WCChannelLink.ready
      1. com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
      2. com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:115)
      2 frames
    29. WebSphere
      AioReadCompletionListener.futureCompleted
      1. com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
      2. com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
      3. com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
      4. com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
      4 frames
    30. com.ibm.io
      ResultHandler$2.run
      1. com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
      2. com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
      3. com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
      4. com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
      5. com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
      6. com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
      6 frames
    31. com.ibm.ws
      ThreadPool$Worker.run
      1. com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
      1 frame