Buildfile: /opt/OpenbravoERP/build.xml set.code.rev: code.rev: init: smartbuild: set.code.rev: code.rev: init: core.lib: init: compile: build.jar: build: copy.core.lib: update.database.if.no.local: set.code.rev: code.rev: init: core.lib: init: compile: build.jar: build: copy.core.lib: database.lib: compile: jar: buildvalidation: [sql] Executing commands [sql] 2 of 2 SQL statements executed successfully buildvalidation: [java] 0 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.buildvalidation.JdkVersionCheck [java] 28 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.buildvalidation.DatabaseDecimalNumberCheck [java] 37 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.buildvalidation.DatabaseVersionCheck [java] 144 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.retail.posterminal.buildvalidation.DuplicatedPosTerminalPaymentType update.database: [sql] Executing commands [sql] 2 of 2 SQL statements executed successfully update.database.java: [java] Executing database update process without checking changes in local files. [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/openbravo. User: tad [java] 1553 INFO - Executing full update.database [java] 1562 INFO - Reading tables... [java] 9828 INFO - Reading views... [java] 9934 INFO - Reading sequences... [java] 9948 INFO - Reading triggers... [java] 9983 INFO - Reading functions... [java] 10341 INFO - Sorting foreign keys, indexes and checks... [java] 10415 INFO - Starting function and trigger standardization. [java] 30739 INFO - Checking datatypes from the model loaded from the database [java] 30742 INFO - Original model loaded from database. [java] 30867 INFO - Reading model files... [java] 36782 INFO - Checking datatypes from the model loaded from XML files [java] 36834 INFO - Loading data from XML files [java] 45058 INFO - Loading and applying configuration scripts [java] 45068 INFO - Applying structure part of configuration script: org.openbravo.v3 [java] 45071 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.v3/src-db/database/configScript.xml [java] 45096 INFO - Applying structure part of configuration script: org.openbravo.retail.pack [java] 45103 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.retail.pack/src-db/database/configScript.xml [java] 45119 INFO - Applying structure part of configuration script: com.openbravo.but.template [java] 45124 INFO - Loading configuration script: /opt/OpenbravoERP/modules/com.openbravo.but.template/src-db/database/configScript.xml [java] 45143 INFO - Applying structure part of configuration script: org.openbravo.retail.deliveryconditions.template [java] 45148 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.retail.deliveryconditions.template/src-db/database/configScript.xml [java] Checking if database structure was modified locally. [java] Checking if data has changed in the application dictionary. [java] 46073 INFO - Executing default prescript [java] 46294 INFO - Executed 114 SQL command(s) successfully [java] 46310 INFO - Updating database model... [java] 46788 INFO - Executed 66 SQL command(s) successfully [java] 46797 INFO - Executed 5 forced SQL command(s) with 1 error(s) [java] 46802 INFO - Executed 1 forced SQL command(s) successfully [java] 46805 INFO - Model update complete. [java] 46830 INFO - Loading and applying configuration scripts [java] 46836 INFO - Applying data part of configuration script: org.openbravo.v3 [java] 46839 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.v3/src-db/database/configScript.xml [java] 47298 INFO - Applying data part of configuration script: org.openbravo.retail.pack [java] 47302 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.retail.pack/src-db/database/configScript.xml [java] 47332 INFO - Applying data part of configuration script: com.openbravo.but.template [java] 47336 INFO - Loading configuration script: /opt/OpenbravoERP/modules/com.openbravo.but.template/src-db/database/configScript.xml [java] 47598 INFO - Applying data part of configuration script: org.openbravo.retail.deliveryconditions.template [java] 47602 INFO - Loading configuration script: /opt/OpenbravoERP/modules/org.openbravo.retail.deliveryconditions.template/src-db/database/configScript.xml [java] 47608 INFO - Comparing databases to find differences [java] 50611 INFO - Disabling foreign keys [java] 50627 INFO - Executed 2 SQL command(s) successfully [java] 50630 INFO - Disabling triggers [java] 50696 INFO - Executed 388 SQL command(s) successfully [java] 1213746 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection. [java] 1214807 INFO - Executed 948 SQL command(s) successfully [java] 1214811 INFO - Running modulescripts... [java] 1214857 INFO - Executing moduleScript: org.openbravo.modulescript.HBFix [java] 1214875 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeCostingMigrationPreference [java] 1214962 INFO - Executing moduleScript: fr.phidias.localization.france.referencedata.masterdata.modulescript.BankAccountNoCalcul [java] 1214968 INFO - Executing moduleScript: fr.phidias.localization.france.referencedata.masterdata.modulescript.BankIbanCalcul [java] 1214973 INFO - Executing moduleScript: fr.phidias.openbravo.but.migration.modulescript.CreateSpecificDatabaseObjects [java] 1214998 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.InitializeAPRMReadyPreference [java] 1215021 INFO - Executing moduleScript: org.openbravo.module.remittance.modulescript.InvoiceWrongPaymentComplete [java] 1215030 INFO - Executing moduleScript: org.openbravo.module.remittance.modulescript.PopulateBankInstructions [java] 1215036 INFO - Executing moduleScript: org.openbravo.module.remittance.modulescript.UpdateIsPaymentPaidRem [java] 1215041 INFO - Executing moduleScript: org.openbravo.module.remittance.modulescript.UpdateProcessRemittance [java] 1215045 INFO - Executing moduleScript: org.openbravo.retail.giftcards.modulescript.UpdateProductGiftCardTypes [java] 1215060 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.EnableTerminalAuthForNewInstances [java] 1215065 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue24147 [java] 1215073 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue24409 [java] 1215077 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue25555 [java] 1215081 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue25963 [java] 1215086 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue26444 [java] 1215090 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue27695 [java] 1215094 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue28722 [java] 1215098 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue31842 [java] 1215103 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixErrorTableData [java] 1215111 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixWrongPaymentScheduled [java] 1215117 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.InitializeProposalTypeforServices [java] 1215130 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.InsertDiscountPreference [java] 1215135 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.InsertNewFlowDiscountPreference [java] 1215140 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.ModuleScriptPosterminal [java] 1215144 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.UpdateCashupReport [java] 1215146 INFO - Update CashUpReport structure ... [java] 1215276 INFO - Executing moduleScript: org.openbravo.retail.storeserver.synchronization.modulescript.SetAuthenticationKey [java] 1215282 INFO - Updating Application Dictionary data... [java] 1215290 ERROR - Error while updating in the database : ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] org.postgresql.util.PSQLException: ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) [java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622) [java] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472) [java] at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2002) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:728) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:227) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:48) [java] org.postgresql.util.PSQLException: ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) [java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622) [java] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472) [java] at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2002) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:728) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:227) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:48) [java] org.apache.ddlutils.DatabaseOperationException: Error while updating in the database : ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2010) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:728) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:227) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:48) [java] Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) [java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622) [java] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472) [java] at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2002) [java] ... 4 more [java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while updating in the database : ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:292) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:48) [java] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while updating in the database : ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2010) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:728) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:227) [java] ... 2 more [java] Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (7D53FD6311EA4D99B0E900F23DDACC6E, 0, 0, Y, 2017-03-29 17:30:39.86887, 0, 2017-03-30 10:23:47.276327, 0, B2FD366D1E274811A7E6AA05C53B3B7A, organizationName, Organization, null, 30, null, 10, 10, null, W, N, null, Y, null, null). [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) [java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622) [java] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472) [java] at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:429) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.update(PlatformImplBase.java:2002) [java] ... 4 more BUILD FAILED /opt/OpenbravoERP/build.xml:394: The following error occurred while executing this line: /opt/OpenbravoERP/build.xml:427: The following error occurred while executing this line: /opt/OpenbravoERP/build.xml:768: The following error occurred while executing this line: /opt/OpenbravoERP/src-db/database/build.xml:82: Java returned: 1 Total time: 20 minutes 20 seconds