4 Replies Latest reply on May 17, 2008 12:10 PM by vasyaod

    CMS File Creation Error

    dsulliva

      I ran into a similar error to the one below on trying to create a folder within the CMS area. I dropped the database and recreated the db. Then I created a new folder, which workded, but then I ran into the error below when trying create a file within this new folder.

      Any idea of what could be my problem.

      jboss-4.2.2.GA
      jboss-portal2.6.4
      postgresql 8.1

      javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (19f12e26-0a76-4bc2-a3d2-9ab560c7935b/{http://www.jcp.org/jcr/1.0}created, <stream of 56 bytes>, 34) was aborted. Call getNextException to see the cause.
      org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:276)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

      root cause

      java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (19f12e26-0a76-4bc2-a3d2-9ab560c7935b/{http://www.jcp.org/jcr/1.0}created, <stream of 56 bytes>, 34) was aborted. Call getNextException to see the cause.
      org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2515)
      org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1310)
      org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
      org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
      org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)
      org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
      org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
      org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
      org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
      org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
      org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
      org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
      org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.loadManagedNode(PortalCMSCacheLoader.java:755)
      org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.saveWSPPropNodeEntry(PortalCMSCacheLoader.java:558)
      org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.put(PortalCMSCacheLoader.java:303)
      org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.put(PortalCMSCacheLoader.java:387)
      org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.prepare(PortalCMSCacheLoader.java:477)
      org.jboss.cache.interceptors.CacheStoreInterceptor.prepareCacheLoader(CacheStoreInterceptor.java:258)
      org.jboss.cache.interceptors.CacheStoreInterceptor.invoke(CacheStoreInterceptor.java:131)
      org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:68)
      org.jboss.cache.interceptors.TxInterceptor.runPreparePhase(TxInterceptor.java:873)
      org.jboss.cache.interceptors.TxInterceptor$LocalSynchronizationHandler.beforeCompletion(TxInterceptor.java:1156)
      org.jboss.cache.interceptors.OrderedSynchronizationHandler.beforeCompletion(OrderedSynchronizationHandler.java:75)
      com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)
      com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)
      com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)
      com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
      com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
      com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
      com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
      org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
      org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
      org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:253)
      org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
      org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
      org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
      org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
      org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
      org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
      org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:69)
      org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:130)
      org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
      org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
      org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:250)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

      note

        • 1. Re: CMS File Creation Error
          dsulliva

          I see what's causing the problem, but not sure why this happening.

          After dropping the database and recreating it. I go in as admin and go to CMS page.

          As soon as I try to create a file I get the error noted in last post.

          In looking at the postgres logs I see:

          ERROR: duplicate key violates unique contriant "jbp_cms_version_pkey"

          But if I'm starting with a clean database then why does this happen.

          • 2. Re: CMS File Creation Error
            dsulliva

            Well, I gave up on this issue and decided to try out mysql.

            It seems to work with mysql so I'm happy now.

            • 3. Re: CMS File Creation Error
              vasyaod

              error in generation of PK (primary key)
              in the file jboss-portal.sar\portal-cms.sar\conf\hibernate\cms\domain.hbm.xml

              Replace all the elements , for example, in or other

              • 4. Re: CMS File Creation Error
                vasyaod

                 

                error in the generation of PK (primary key)
                in the file jboss-portal.sar \ portal-cms.sar \ conf \ hibernate \ cms \ domain.hbm.xml
                Replace all the elements <generator class="native">, for example, in <generator class="increment"> or other <generator class="...">