AnsweredAssumed Answered

Error of database synchronization

Question asked by fstnboy on Sep 22, 2008
Latest reply on Sep 22, 2008 by fstnboy
Hi all,

I have a local enviroment to develop alfresco web client. In order to prove it in client´s enterprise we use another database. When trying to deploy the application next error is shown:

2008-09-19 15:12:21,617 WARN  [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
2008-09-19 15:12:23,169 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
2008-09-19 15:12:23,169 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00001: restricción única (DES_ALFRESCO.SYS_C0016134) violada

2008-09-19 15:12:23,169 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
2008-09-19 15:12:23,169 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00001: restricción única (DES_ALFRESCO.SYS_C0016134) violada

2008-09-19 15:12:23,169 ERROR [org.hibernate.event.def.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)

…..

Caused by: java.sql.BatchUpdateException: ORA-00001: restricción única (DES_ALFRESCO.SYS_C0016134) violada

        at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
        … 206 more
2008-09-19 15:12:23,219 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by:
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)

They have asked me to export our database and send them the export and the alf_data directory. Nothing in the client entreprise has been modified (not database, nor alf_data directory), it should work, shouldn´t it?

¿What´s wrong?

Outcomes