Do you run Export and Import on the same database?
Emmanuel
Thomas Recloux a écrit :
Hi,
I have got the following error during the builds import with the migration
tool.
It looks like the migration tool tries to delete 'BUILDDEFINITION' entries
but a child entry blocks the statement.
If you give me the child table, I could delete it manually.
I do not undestand why the BUILDDEFINITION table is not empty.
Thanks, Thomas
ERROR 23503: DELETE on table 'BUILDDEFINITION' caused a violation of foreign
key constraint 'BUILDDEFINITCE_FK2' for key (3). The statement has been
rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown
Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(
RDBMSManager.java:572)
at org.jpox.store.rdbms.request.DeleteRequest.execute(
DeleteRequest.java:274)
at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java
:2611)
at org.jpox.store.StoreManager.delete(StoreManager.java:981)
at org.jpox.state.StateManagerImpl.internalDeletePersistent(
StateManagerImpl.java:4395)
at org.jpox.state.StateManagerImpl.deletePersistent(
StateManagerImpl.java:4350)
at org.jpox.AbstractPersistenceManager.internalDeletePersistent(
AbstractPersistenceManager.java:1473)
at org.jpox.AbstractPersistenceManager.deletePersistentAll(
AbstractPersistenceManager.java:1516)
at org.jpox.store.rdbms.scostore.ElementContainerStore.clear(
ElementContainerStore.java:659)
at org.jpox.store.mapping.CollectionMapping.deleteDependent(
CollectionMapping.java:334)
at org.jpox.store.rdbms.table.ClassTable.deleteDependent(
ClassTable.java:2651)
at org.jpox.store.StoreManager.deleteDependent(StoreManager.java
:1019)
at org.jpox.state.StateManagerImpl.deletePersistent(
StateManagerImpl.java:4332)
at org.jpox.AbstractPersistenceManager.internalDeletePersistent(
AbstractPersistenceManager.java:1473)
at org.jpox.AbstractPersistenceManager.deletePersistentAll(
AbstractPersistenceManager.java:1516)
at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(
JDOQLQuery.java:687)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049)
at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(
PlexusJdoUtils.java:444)
at org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase(
JdoContinuumStore.java:1961)
at
org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(
JdoDataManagementTool.java:127)
at
org.apache.maven.continuum.management.DataManagementCli.processDatabase(
DataManagementCli.java:254)
at org.apache.maven.continuum.management.DataManagementCli.main(
DataManagementCli.java:158)
