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

[Thomas Heute (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPORTAL-1294?page=all ]

Thomas Heute resolved JBPORTAL-1294.
------------------------------------

    Resolution: Cannot Reproduce Bug
      Assignee: Thomas Heute

As mark it as "Cannot reproduce bug" unless you have a way to reproduce it.

> 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: Thomas Heute
>             Fix For: 2.6.2 Final, 2.8 Final
>
>
> 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