1 Reply Latest reply on Mar 27, 2006 9:30 PM by Susitha Bandara

    CMS RDBMS Configuration error

    Susitha Bandara Newbie

      Hi..

      I am using JBServer-4.0.2 and JBPortal-2.0 and Oracle9i.. I have configured my CMS as in the Chapter5 of User guide and my configuration of jboss-service.xml is as follows.

      <!-- The slide configuration using the database. Uncomment this and comment the above tx store for Database usage. -->
      
      
       <definition>
       <store name="j2ee">
       <nodestore classname="org.apache.slide.store.impl.rdbms.J2EEStore">
       <parameter name="datasource">PortalDS</parameter>
       <parameter name="adapter">org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter</parameter>
       <parameter name="compress">true</parameter>
       </nodestore>
       <securitystore>
       <reference store="nodestore"/>
       </securitystore>
       <lockstore>
       <reference store="nodestore"/>
       </lockstore>
       <revisiondescriptorsstore>
       <reference store="nodestore"/>
       </revisiondescriptorsstore>
       <revisiondescriptorstore>
       <reference store="nodestore"/>
       </revisiondescriptorstore>
       <contentstore>
       <reference store="nodestore"/>
       </contentstore>
       </store>
       <scope match="/" store="j2ee"/>
       </definition>
      


      when I started the portal it gaves the following error...

      16:38:39,714 WARN [SlideTransaction] Commit failure: Resource manager org.apache.slide.store.impl.r
      dbms.J2EEStore@ff0d4b Error code XA_RBCOMMFAIL in Transaction 7 xid http-0.0.0.0-8080-1-114345591911
      3-7- in thread http-0.0.0.0-8080-1
      javax.transaction.xa.XAException
       at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore$TransactionId.commit(AbstractRDBMSSt
      ore.java:903)
       at org.apache.commons.transaction.util.xa.AbstractXAResource.commit(AbstractXAResource.java:
      89)
       at org.apache.slide.transaction.SlideTransaction.commit(SlideTransaction.java:300)
       at org.apache.slide.transaction.SlideTransactionManager.commit(SlideTransactionManager.java:
      186)
       at org.jboss.portal.common.transaction.Transactions.end(Transactions.java:401)
       at org.jboss.portal.common.transaction.Transactions.safeEnd(Transactions.java:366)
       at org.jboss.portal.core.portlet.cms.CMSPortlet.processAction(CMSPortlet.java:135)
       at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeAction(DispatcherIntercep
      tor.java:110)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.ja
      va:191)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.
      java:93)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextComma
      nd.execute(ContextDispatcherInterceptor.java:94)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
       at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539)
       at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
       at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextD
      ispatcherInterceptor.java:58)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor
      .java:125)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.jav
      a:74)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238
      )
       at org.jboss.portal.server.Component.invoke(Component.java:130)
       at org.jboss.portal.server.invocation.portal.TargetInterceptor.invokeWindow(TargetIntercepto
      r.java:167)
       at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java
      :67)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.jav
      a:117)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.jav
      a:92)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238
      )
       at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186)
       at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78)
       at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
       at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.ja
      va:153)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11P
      rotocol.java:744)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
       at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
       at java.lang.Thread.run(Thread.java:534)
      16:38:40,395 ERROR [Transactions] Problem when ending transaction
      javax.transaction.HeuristicMixedException
       at org.apache.slide.transaction.SlideTransaction.commit(SlideTransaction.java:332)
       at org.apache.slide.transaction.SlideTransactionManager.commit(SlideTransactionManager.java:
      186)
       at org.jboss.portal.common.transaction.Transactions.end(Transactions.java:401)
       at org.jboss.portal.common.transaction.Transactions.safeEnd(Transactions.java:366)
       at org.jboss.portal.core.portlet.cms.CMSPortlet.processAction(CMSPortlet.java:135)
       at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeAction(DispatcherIntercep
      tor.java:110)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.ja
      va:191)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.
      java:93)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextComma
      nd.execute(ContextDispatcherInterceptor.java:94)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
       at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539)
       at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
       at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextD
      ispatcherInterceptor.java:58)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor
      .java:125)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.jav
      a:74)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238
      )
       at org.jboss.portal.server.Component.invoke(Component.java:130)
       at org.jboss.portal.server.invocation.portal.TargetInterceptor.invokeWindow(TargetIntercepto
      r.java:167)
       at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(TargetInterceptor.java
      :67)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(ContentTypeInterceptor.jav
      a:117)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.jav
      a:92)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:238
      )
       at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186)
       at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:78)
       at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:71)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:79)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
      ava:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
       at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.ja
      va:153)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11P
      rotocol.java:744)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
       at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
       at java.lang.Thread.run(Thread.java:534)
      16:38:41,336 ERROR [Transactions]
      org.jboss.portal.common.transaction.TransactionException: javax.transaction.HeuristicMixedException
       at org.jboss.portal.common.transaction.Transactions.end(Transactions.java:415)
       at org.jboss.portal.common.transaction.Transactions.safeEnd(Transactions.java:366)
       at org.jboss.portal.core.portlet.cms.CMSPortlet.processAction(CMSPortlet.java:135)
       at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeAction(DispatcherIntercep
      tor.java:110)
       at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.ja
      va:191)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.
      java:93)
       at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:213
      )
       at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextComma
      nd.execute(ContextDispatcherInterceptor.java:94)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:49)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j


      Can somebody tell me how to fix this error?

      Thanx...