update.database.java: [java] Executing database update process without checking changes in local files. [java] 1 INFO - Database connection: jdbc:postgresql://localhost:5432/erp_upgrade_to_latest_obx_mm_console. User: erp_upgrade_to_latest_obx_mm_console [java] 828 INFO - Executing full update.database [java] 865 INFO - Reading tables... [java] 38161 INFO - Reading views... [java] 38667 INFO - Reading sequences... [java] 38675 INFO - Reading triggers... [java] 38786 INFO - Reading functions... [java] 39093 INFO - Sorting foreign keys, indexes and checks... [java] 39356 INFO - Starting function and trigger standardization. [java] 123155 INFO - Original model loaded from database. [java] 128506 INFO - Loading data from XML files [java] 133922 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] 134171 INFO - Executing default prescript [java] 134603 INFO - Executed 116 SQL command(s) with 0 error(s) [java] 134624 INFO - Updating database model... [java] 167175 WARN - SQL Command failed with: ERROR: invalid reference to FROM-clause entry for table "fin_payment" [java] 167184 WARN - -- END [java] INSERT INTO FIN_PAYMENT (FIN_PAYMENT_ID,AD_CLIENT_ID,AD_ORG_ID,CREATED,CREATEDBY,UPDATED,UPDATEDBY,ISACTIVE,ISRECEIPT,C_BPARTNER_ID,PAYMENTDATE,C_CURRENCY_ID,AMOUNT,WRITEOFFAMT,FIN_PAYMENTMETHOD_ID,DOCUMENTNO,REFERENCENO,STATUS,PROCESSED,PROCESSING,POSTED,DESCRIPTION,FIN_FINANCIAL_ACCOUNT_ID,C_DOCTYPE_ID) SELECT FIN_PAYMENT_ID,AD_CLIENT_ID,AD_ORG_ID,CREATED,CREATEDBY,UPDATED,UPDATEDBY,ISACTIVE,ISRECEIPT,C_BPARTNER_ID,PAYMENTDATE,C_CURRENCY_ID,AMOUNT,WRITEOFFAMT,FIN_PAYMENTMETHOD_ID,DOCUMENTNO,REFERENCENO,STATUS,PROCESSED,PROCESSING,POSTED,DESCRIPTION,FIN_FINANCIAL_ACCOUNT_ID,(SELECT max(C_DocType_ID) from C_DocType WHERE c_doctype.ad_client_id = fin_payment.ad_client_id AND AD_ISORGINCLUDED(FIN_Payment.AD_Org_ID,C_DocType.AD_Org_ID, FIN_Payment.AD_Client_ID) <> -1 AND C_DocType.DocBaseType IN ('APP', 'ARR') AND C_DocType.IsSOTrx=Fin_Payment.isreceipt) FROM FIN_PAYMENT_ [java] 168351 INFO - Executed 1246 SQL command(s) with 1 error(s) [java] 168378 INFO - Executed 2 forced SQL command(s) with 0 error(s) [java] 168382 INFO - Model update complete. [java] 168390 INFO - Disabling foreign keys [java] 177522 INFO - Executed 2053 SQL command(s) with 0 error(s) [java] 177526 INFO - Disabling triggers [java] 179102 INFO - Executed 462 SQL command(s) with 0 error(s) [java] 193252 INFO - Executed 4709 SQL command(s) with 0 error(s) [java] 193259 INFO - Comparing databases to find differences [java] 199277 INFO - Updating database data... [java] 204506 INFO - Removing invalid rows. [java] 205399 INFO - Executed 165 SQL command(s) with 0 error(s) [java] 205402 INFO - Recreating Primary Keys [java] 206512 INFO - Executed 31 SQL command(s) with 0 error(s) [java] 206516 INFO - Executing update final script (NOT NULLs and dropping temporary tables [java] 207871 INFO - Executed 141 SQL command(s) with 0 error(s) [java] 223883 INFO - Executed 5449 SQL command(s) with 0 error(s) [java] 227831 INFO - Executed 463 SQL command(s) with 0 error(s) [java] 227883 INFO - Executed 10 forced SQL command(s) with 0 error(s) [java] 227886 INFO - Enabling Foreign Keys and Triggers [java] 242292 INFO - Executed 2053 SQL command(s) with 0 error(s) [java] 275275 INFO - Executed 462 SQL command(s) with 0 error(s) [java] 275282 INFO - Executing default postscript [java] 275400 INFO - Executed 22 SQL command(s) with 0 error(s)