import.sample.data: [echo] Importing sample reference data [importsampledata] 0 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into AD_Client (AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, Description, IsMultiLingualDocument, IsSmtpAuthorization, C_Currency_ID, AD_Client_ID) values (0, Y, 2009-10-25 18:47:37.979000 +0000, 0, 2009-10-25 18:47:37.979000 +0000, 0, Accounting Test, Accounting Test, Accounting Test, N, N, 100, FF808181248D05E101248D0668FA0003) was aborted. Call getNextException to see the cause. [importsampledata] 18 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "ad_client_name" [importsampledata] 21 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session [importsampledata] org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update [importsampledata] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) [importsampledata] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2654) [importsampledata] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) [importsampledata] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) [importsampledata] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) [importsampledata] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) [importsampledata] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) [importsampledata] at org.openbravo.dal.service.OBDal.flush(OBDal.java:108) [importsampledata] at org.openbravo.service.db.DataImportService.importClientData(DataImportService.java:224) [importsampledata] at org.openbravo.service.db.ImportReferenceDataTask.doExecute(ImportReferenceDataTask.java:52) [importsampledata] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306) [importsampledata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.Main.runBuild(Main.java:758) [importsampledata] at org.apache.tools.ant.Main.startAnt(Main.java:217) [importsampledata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) [importsampledata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) [importsampledata] Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into AD_Client (AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, Description, IsMultiLingualDocument, IsSmtpAuthorization, C_Currency_ID, AD_Client_ID) values (0, Y, 2009-10-25 18:47:37.979000 +0000, 0, 2009-10-25 18:47:37.979000 +0000, 0, Accounting Test, Accounting Test, Accounting Test, N, N, 100, FF808181248D05E101248D0668FA0003) was aborted. Call getNextException to see the cause. [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2533) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350) [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592) [importsampledata] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) [importsampledata] ... 44 more [importsampledata] org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update [importsampledata] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) [importsampledata] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2654) [importsampledata] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) [importsampledata] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) [importsampledata] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) [importsampledata] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) [importsampledata] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) [importsampledata] at org.openbravo.dal.service.OBDal.flush(OBDal.java:108) [importsampledata] at org.openbravo.service.db.DataImportService.importClientData(DataImportService.java:224) [importsampledata] at org.openbravo.service.db.ImportReferenceDataTask.doExecute(ImportReferenceDataTask.java:52) [importsampledata] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306) [importsampledata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.Main.runBuild(Main.java:758) [importsampledata] at org.apache.tools.ant.Main.startAnt(Main.java:217) [importsampledata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) [importsampledata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) [importsampledata] Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into AD_Client (AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, Description, IsMultiLingualDocument, IsSmtpAuthorization, C_Currency_ID, AD_Client_ID) values (0, Y, 2009-10-25 18:47:37.979000 +0000, 0, 2009-10-25 18:47:37.979000 +0000, 0, Accounting Test, Accounting Test, Accounting Test, N, N, 100, FF808181248D05E101248D0668FA0003) was aborted. Call getNextException to see the cause. [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2533) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350) [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592) [importsampledata] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) [importsampledata] ... 44 more [importsampledata] 61 [main] ERROR org.openbravo.base.exception.OBException - org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update [importsampledata] 61 [main] ERROR org.openbravo.base.exception.OBException - Exception (org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update) while importing from file /home/miguel/Projectos/Openbravo/sources/pi/referencedata/sampledata/Accounting_Test.xml [importsampledata] org.openbravo.base.exception.OBException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update [importsampledata] at org.openbravo.service.db.ImportReferenceDataTask.doExecute(ImportReferenceDataTask.java:58) [importsampledata] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) [importsampledata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [importsampledata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [importsampledata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [importsampledata] at java.lang.reflect.Method.invoke(Method.java:597) [importsampledata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [importsampledata] at org.apache.tools.ant.Task.perform(Task.java:348) [importsampledata] at org.apache.tools.ant.Target.execute(Target.java:357) [importsampledata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [importsampledata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [importsampledata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306) [importsampledata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [importsampledata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [importsampledata] at org.apache.tools.ant.Main.runBuild(Main.java:758) [importsampledata] at org.apache.tools.ant.Main.startAnt(Main.java:217) [importsampledata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) [importsampledata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) [importsampledata] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update [importsampledata] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) [importsampledata] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224) [importsampledata] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2654) [importsampledata] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) [importsampledata] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) [importsampledata] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) [importsampledata] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) [importsampledata] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) [importsampledata] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) [importsampledata] at org.openbravo.dal.service.OBDal.flush(OBDal.java:108) [importsampledata] at org.openbravo.service.db.DataImportService.importClientData(DataImportService.java:224) [importsampledata] at org.openbravo.service.db.ImportReferenceDataTask.doExecute(ImportReferenceDataTask.java:52) [importsampledata] ... 29 more [importsampledata] Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into AD_Client (AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, Description, IsMultiLingualDocument, IsSmtpAuthorization, C_Currency_ID, AD_Client_ID) values (0, Y, 2009-10-25 18:47:37.979000 +0000, 0, 2009-10-25 18:47:37.979000 +0000, 0, Accounting Test, Accounting Test, Accounting Test, N, N, 100, FF808181248D05E101248D0668FA0003) was aborted. Call getNextException to see the cause. [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2533) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) [importsampledata] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350) [importsampledata] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592) [importsampledata] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) [importsampledata] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) [importsampledata] ... 44 more BUILD FAILED /home/miguel/Projectos/Openbravo/sources/pi/build.xml:431: The following error occurred while executing this line: /home/miguel/Projectos/Openbravo/sources/pi/src/build.xml:190: org.openbravo.base.exception.OBException: Exception (org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update) while importing from file /home/miguel/Projectos/Openbravo/sources/pi/referencedata/sampledata/Accounting_Test.xml