[jboss-user] [JBoss Portal] - 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 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4132581#4132581

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4132581