[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-1294) JBP_CMS_WSP_PROP.PK unique contraint violated

[Ian White (JIRA)]

JBP_CMS_WSP_PROP.PK unique contraint violated
---------------------------------------------

                 Key: JBPORTAL-1294
                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1294
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Portal CMS
    Affects Versions: 2.6.Alpha2
         Environment: AS 4.0.5.GA
Oracle 9i
            Reporter: Ian White
         Assigned To: Roy Russo


Try to create a content item using the CMS Admin Portlet.
Get oracle sql exception - primary key unique contraint violated - JBP_CMS_SWP_PROP.PK:

16:32:14,171 INFO  [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-80
16:32:14,328 INFO  [ChannelSocket] JK: ajp13 listening on /0.0.0.0:9
16:32:14,343 INFO  [JkMain] Jk running ID=0 time=0/78  config=null
16:32:14,359 INFO  [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 1m:12s:797ms
16:32:57,671 WARN  [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
16:32:57,671 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (JBPORTAL26.SYS_C0032370) violated

16:32:57,671 WARN  [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
16:32:57,671 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (JBPORTAL26.SYS_C0032370) violated

16:32:57,671 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
        at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.loadManagedNode(PortalCMSCacheLoader.java:757)
        at org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.saveWSPPropNodeEntry(PortalCMSCacheLoader.java:560)
        at org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.put(PortalCMSCacheLoader.java:305)
        at org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.put(PortalCMSCacheLoader.java:389)
        at org.jboss.portal.cms.hibernate.state.PortalCMSCacheLoader.prepare(PortalCMSCacheLoader.java:479)
        at org.jboss.cache.interceptors.CacheStoreInterceptor.prepareCacheLoader(CacheStoreInterceptor.java:296)
        at org.jboss.cache.interceptors.CacheStoreInterceptor.invoke(CacheStoreInterceptor.java:130)
        at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:68)
        at org.jboss.cache.interceptors.TxInterceptor.runPreparePhase(TxInterceptor.java:804)
        at org.jboss.cache.interceptors.TxInterceptor$LocalSynchronizationHandler.beforeCompletion(TxInterceptor.java:1069)
        at org.jboss.cache.interceptors.OrderedSynchronizationHandler.beforeCompletion(OrderedSynchronizationHandler.java:75)
        at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1491)
        at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1110)
        at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:324)
        at org.jboss.tm.TxManager.commit(TxManager.java:240)
        at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
        at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
        at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
        at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
        at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira