set.code.rev: code.rev: init: core.lib: init: [mkdir] Created dir: /opt/OpenbravoERP/src-core/build/classes [mkdir] Created dir: /opt/OpenbravoERP/src-core/docs compile: [javac] Compiling 122 source files to /opt/OpenbravoERP/src-core/build/classes build.jar: [jar] Building jar: /opt/OpenbravoERP/src-core/lib/openbravo-core.jar build: copy.core.lib: [copy] Copying 1 file to /opt/OpenbravoERP/lib/runtime database.lib: init: [mkdir] Created dir: /opt/OpenbravoERP/src-db/build/classes [mkdir] Created dir: /opt/OpenbravoERP/src-db/build/lib [mkdir] Created dir: /opt/OpenbravoERP/src-db/docs compile: [javac] Compiling 4 source files to /opt/OpenbravoERP/src-db/build/classes build.jar: [jar] Building jar: /opt/OpenbravoERP/src-db/build/lib/dbmanager.jar jar: [copy] Copying 1 file to /opt/OpenbravoERP/src-db/database/lib buildvalidation: buildvalidation: [java] 0 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.Cbpvendoracct update.database: 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] 1273 INFO - Executing full update.database [java] 1460 INFO - Reading tables... [java] 42243 INFO - Reading views... [java] 43171 INFO - Reading sequences... [java] 43179 INFO - Reading triggers... [java] 43547 INFO - Reading functions... [java] 44445 INFO - Sorting foreign keys, indexes and checks... [java] 44612 INFO - Starting function and trigger standardization. [java] 134236 INFO - Original model loaded from database. [java] 142603 INFO - Loading data from XML files [java] 151245 INFO - Loading and applying configuration scripts [java] Checking if database structure was modified locally. [java] Checking if data has changed in the application dictionary. [java] 152668 INFO - Executing default prescript [java] 154457 INFO - Executed 116 SQL command(s) successfully [java] 154529 INFO - Updating database model... [java] 200247 ERROR - Error while executing SQL -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW FIN_PAYMENT_DETAIL_V [java] -- ----------------------------------------------------------------------- [java] -- SCRIPT OPTIONS (FORCE = TRUE) [java] CREATE OR REPLACE VIEW FIN_PAYMENT_DETAIL_V AS SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname [java] FROM fin_payment p, fin_payment_detail pd [java] JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id [java] LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id [java] LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id [java] LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id [java] LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id [java] LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id [java] WHERE p.fin_payment_id = pd.fin_payment_id [java] org.postgresql.util.PSQLException: ERROR: relation "fin_payment_sched_inv_v" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:324) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:668) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:645) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:149) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34) [java] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW FIN_PAYMENT_DETAIL_V [java] -- ----------------------------------------------------------------------- [java] -- SCRIPT OPTIONS (FORCE = TRUE) [java] CREATE OR REPLACE VIEW FIN_PAYMENT_DETAIL_V AS SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname [java] FROM fin_payment p, fin_payment_detail pd [java] JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id [java] LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id [java] LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id [java] LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id [java] LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id [java] LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id [java] WHERE p.fin_payment_id = pd.fin_payment_id [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:357) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:668) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:645) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:149) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34) [java] Caused by: org.postgresql.util.PSQLException: ERROR: relation "fin_payment_sched_inv_v" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:324) [java] ... 5 more [java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW FIN_PAYMENT_DETAIL_V [java] -- ----------------------------------------------------------------------- [java] -- SCRIPT OPTIONS (FORCE = TRUE) [java] CREATE OR REPLACE VIEW FIN_PAYMENT_DETAIL_V AS SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname [java] FROM fin_payment p, fin_payment_detail pd [java] JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id [java] LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id [java] LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id [java] LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id [java] LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id [java] LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id [java] WHERE p.fin_payment_id = pd.fin_payment_id [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:202) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34) [java] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW FIN_PAYMENT_DETAIL_V [java] -- ----------------------------------------------------------------------- [java] -- SCRIPT OPTIONS (FORCE = TRUE) [java] CREATE OR REPLACE VIEW FIN_PAYMENT_DETAIL_V AS SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname [java] FROM fin_payment p, fin_payment_detail pd [java] JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id [java] LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id [java] LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id [java] LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id [java] LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id [java] LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id [java] WHERE p.fin_payment_id = pd.fin_payment_id [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:357) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:668) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:645) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:149) [java] ... 2 more [java] Caused by: org.postgresql.util.PSQLException: ERROR: relation "fin_payment_sched_inv_v" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:324) [java] ... 5 more [java] --- Nested Exception --- [java] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW FIN_PAYMENT_DETAIL_V [java] -- ----------------------------------------------------------------------- [java] -- SCRIPT OPTIONS (FORCE = TRUE) [java] CREATE OR REPLACE VIEW FIN_PAYMENT_DETAIL_V AS SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname [java] FROM fin_payment p, fin_payment_detail pd [java] JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id [java] LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id [java] LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id [java] LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id [java] LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id [java] LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id [java] WHERE p.fin_payment_id = pd.fin_payment_id [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:357) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:668) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:645) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:149) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34) [java] Caused by: org.postgresql.util.PSQLException: ERROR: relation "fin_payment_sched_inv_v" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) [java] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:324) [java] ... 5 more