Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Executing default prescript
- Executed 118 SQL command(s) successfully
- Executing creation script
- for the complete database
- Executed 11026 SQL command(s) successfully
- Executed 4 forced SQL command(s) successfully
- Executing default postscript
- Executed 18 SQL command(s) successfully
- Writing checksum info
- Inserting data into the database.
- Executed 570 SQL command(s) successfully
- Executed 2373 SQL command(s) successfully
- Executed 63 SQL command(s) successfully
- Loading config script for module System Customization. Path: /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/../../modules/mySystem.CustomizationTemplate/src-db/database/configScript.xml
- Error. We couldn't find configuration script for template System Customization. Path: /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/../../modules/mySystem.CustomizationTemplate/src-db/database/configScript.xml
- Loading config script for module Openbravo 3.0. Path: /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/../../modules/org.openbravo.v3/src-db/database/configScript.xml
- Executed 450 SQL command(s) successfully
- Executed 143 SQL command(s) successfully
- Executed 5655 SQL command(s) successfully
- Executed 570 SQL command(s) successfully
- Error while executing SQL -- END
- ALTER TABLE AD_DATASET_COLUMN
- ADD CONSTRAINT AD_DATASET_COLUMN_AD_COLUMN FOREIGN KEY (AD_COLUMN_ID) REFERENCES AD_COLUMN (AD_COLUMN_ID)
- [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
- [createdatabase] ALTER TABLE AD_DATASET_COLUMN
- [createdatabase] ADD CONSTRAINT AD_DATASET_COLUMN_AD_COLUMN FOREIGN KEY (AD_COLUMN_ID) REFERENCES AD_COLUMN (AD_COLUMN_ID)
- [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
- [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
- [createdatabase] at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
- [createdatabase] at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
- [createdatabase] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- [createdatabase] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
- [createdatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.Main.runBuild(Main.java:801)
- [createdatabase] at org.apache.tools.ant.Main.startAnt(Main.java:218)
- [createdatabase] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
- [createdatabase] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
- [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_dataset_column" violates foreign key constraint "ad_dataset_column_ad_column"
- [createdatabase] Dettaglio: Key (ad_column_id)=(8AB06B902F913992012F914C831D0013) is not present in table "ad_column".
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
- [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
- [createdatabase] ... 45 more
- Error while enabling foreign key
- [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
- [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:315)
- [createdatabase] at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
- [createdatabase] at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
- [createdatabase] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- [createdatabase] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- [createdatabase] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
- [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
- [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:390)
- [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:411)
- [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- [createdatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
- [createdatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
- [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- [createdatabase] at org.apache.tools.ant.Main.runBuild(Main.java:801)
- [createdatabase] at org.apache.tools.ant.Main.startAnt(Main.java:218)
- [createdatabase] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
- [createdatabase] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
- [createdatabase] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
- [createdatabase] ALTER TABLE AD_DATASET_COLUMN
- [createdatabase] ADD CONSTRAINT AD_DATASET_COLUMN_AD_COLUMN FOREIGN KEY (AD_COLUMN_ID) REFERENCES AD_COLUMN (AD_COLUMN_ID)
- [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
- [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
- [createdatabase] ... 44 more
- [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_dataset_column" violates foreign key constraint "ad_dataset_column_ad_column"
- [createdatabase] Dettaglio: Key (ad_column_id)=(8AB06B902F913992012F914C831D0013) is not present in table "ad_column".
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
- [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
- [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
- [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
- [createdatabase] ... 45 more
- BUILD FAILED
- /opt/OpenbravoERP-3.0/openbravo-erp/build.xml:707: The following error occurred while executing this line:
- /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/build-create.xml:52: The following error occurred while executing this line:
- /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/build-create.xml:228: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
- at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:315)
- at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
- at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
- at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
- at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- at org.apache.tools.ant.Task.perform(Task.java:348)
- at org.apache.tools.ant.Target.execute(Target.java:390)
- at org.apache.tools.ant.Target.performTasks(Target.java:411)
- at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
- at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- at org.apache.tools.ant.Task.perform(Task.java:348)
- at org.apache.tools.ant.Target.execute(Target.java:390)
- at org.apache.tools.ant.Target.performTasks(Target.java:411)
- at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
- at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
- at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- at org.apache.tools.ant.Task.perform(Task.java:348)
- at org.apache.tools.ant.Target.execute(Target.java:390)
- at org.apache.tools.ant.Target.performTasks(Target.java:411)
- at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
- at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
- at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
- at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
- at org.apache.tools.ant.Main.runBuild(Main.java:801)
- at org.apache.tools.ant.Main.startAnt(Main.java:218)
- at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
- at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
- Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
- ALTER TABLE AD_DATASET_COLUMN
- ADD CONSTRAINT AD_DATASET_COLUMN_AD_COLUMN FOREIGN KEY (AD_COLUMN_ID) REFERENCES AD_COLUMN (AD_COLUMN_ID)
- at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
- at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
- ... 44 more
- Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_dataset_column" violates foreign key constraint "ad_dataset_column_ad_column"
- Dettaglio: Key (ad_column_id)=(8AB06B902F913992012F914C831D0013) is not present in table "ad_column".
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
- at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
- at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
- at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
- at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
- ... 45 more
- Total time: 2 minutes 40 seconds
Add Comment
Please, Sign In to add comment