Buildfile: build.xml init: code.rev: update.database: init: database.lib: clean: [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/classes [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/lib [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/docs init: [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/classes [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/lib [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/docs compile: [javac] Compiling 4 source files to /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/classes build.jar: [jar] Building jar: /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/build/lib/dbmanager.jar jar: [copy] Copying 1 file to /home/openbravo/work/ob_branches/r2.40pg_generator_test/src-db/database/lib update.database: [alterdatabasedata] Executing default prescript [alterdatabasedata] Executed 109 SQL command(s) with 0 error(s) [alterdatabasedata] Reading tables... [alterdatabasedata] Reading views... [alterdatabasedata] Reading sequences... [alterdatabasedata] Reading triggers... [alterdatabasedata] Reading functions... [alterdatabasedata] Sorting foreign keys and checks... [alterdatabasedata] Starting function and trigger standardization. [alterdatabasedata] Original model loaded from database. [alterdatabasedata] Disabling foreign keys [alterdatabasedata] Executed 2152 SQL command(s) with 0 error(s) [alterdatabasedata] Disabling triggers [alterdatabasedata] Executed 326 SQL command(s) with 0 error(s) [alterdatabasedata] Processing Trigger Trigger [name=C_BP_BANKACCOUNTIBAN_TRG; ] (removed from database PostgreSql server) [alterdatabasedata] Processing Trigger Trigger [name=C_BP_BANKACCOUNTIBAN_TRG; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Column NAME of table AD_ACCOUNTINGRPT_ELEMENT (changed because of the size) [alterdatabasedata] Processing Column ISINITIALBALANCE (created for table AD_ACCOUNTINGRPT_ELEMENT) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the type) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the scale) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the default value) [alterdatabasedata] Processing Column AMORTIZATION_PERCENTAGE of table A_AMORTIZATIONLINE (changed because of the onCreateDefault value) [alterdatabasedata] Processing Column ANNUALAMORTIZATIONPERCENTAGE of table A_ASSET (changed because of the onCreateDefault value) [alterdatabasedata] Processing Column ALLOWNEGATIVE (created for table C_ACCTSCHEMA) [alterdatabasedata] Processing Column C_ACCTSCHEMA_GL_ID of table C_ACCTSCHEMA_GL (changed because of the onCreateDefault value) [alterdatabasedata] Processing Table C_ACCTSCHEMA_TABLE_DOCTYPE (added) [alterdatabasedata] Processing Unique C_BPSALCAT_SALCAT_DFROM_UN_KEY (removed from table C_BP_SALCATEGORY) [alterdatabasedata] Processing Unique C_BPSALCAT_SALCAT_DFROM_UN_KEY (created for table C_BP_SALCATEGORY) [alterdatabasedata] Processing Index C_INVOICETAX_INVOICEID (created for table C_INVOICETAX) [alterdatabasedata] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) [alterdatabasedata] Processing View View [name=S_TIMEEXPENSELINE_V; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_COMMISSIONRUN_PROCESS(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_YEARPERIODS(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_PURCHASEORDER(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_WORKREQUIREMENT(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_INOUT_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_POST(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_CREATE_TESTDATA(NUMERIC, NUMERIC, CHAR, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_WRITE_LOG(VARCHAR); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_COMMISSIONRUN_PROCESS(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_YEARPERIODS(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_PURCHASEORDER(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_WORKREQUIREMENT(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_INOUT_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_POST(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_CREATE_TESTDATA(NUMERIC, NUMERIC, CHAR, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_WRITE_LOG(VARCHAR); ] (created for the database PostgreSql server) [alterdatabasedata] Executed 94 SQL command(s) with 0 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] There are still 1 forced commands not executed sucessfully. [alterdatabasedata] Executed 68 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 133 SQL command(s) with 0 error(s) [alterdatabasedata] Processing Trigger Trigger [name=C_BP_BANKACCOUNTIBAN_TRG; ] (removed from database PostgreSql server) [alterdatabasedata] Processing Trigger Trigger [name=C_BP_BANKACCOUNTIBAN_TRG; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Column NAME of table AD_ACCOUNTINGRPT_ELEMENT (changed because of the size) [alterdatabasedata] Processing Column ISINITIALBALANCE (created for table AD_ACCOUNTINGRPT_ELEMENT) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the type) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the scale) [alterdatabasedata] Processing Column CODE_REVISION of table AD_SYSTEM_INFO (changed because of the default value) [alterdatabasedata] Processing Column AMORTIZATION_PERCENTAGE of table A_AMORTIZATIONLINE (changed because of the onCreateDefault value) [alterdatabasedata] Processing Column ANNUALAMORTIZATIONPERCENTAGE of table A_ASSET (changed because of the onCreateDefault value) [alterdatabasedata] Processing Column ALLOWNEGATIVE (created for table C_ACCTSCHEMA) [alterdatabasedata] Processing Column C_ACCTSCHEMA_GL_ID of table C_ACCTSCHEMA_GL (changed because of the onCreateDefault value) [alterdatabasedata] Processing Table C_ACCTSCHEMA_TABLE_DOCTYPE (added) [alterdatabasedata] Processing Unique C_BPSALCAT_SALCAT_DFROM_UN_KEY (removed from table C_BP_SALCATEGORY) [alterdatabasedata] Processing Unique C_BPSALCAT_SALCAT_DFROM_UN_KEY (created for table C_BP_SALCATEGORY) [alterdatabasedata] Processing Index C_INVOICETAX_INVOICEID (created for table C_INVOICETAX) [alterdatabasedata] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) [alterdatabasedata] Processing View View [name=S_TIMEEXPENSELINE_V; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_COMMISSIONRUN_PROCESS(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_YEARPERIODS(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_PURCHASEORDER(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_WORKREQUIREMENT(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_INOUT_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_POST(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_CREATE_TESTDATA(NUMERIC, NUMERIC, CHAR, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_WRITE_LOG(VARCHAR); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_COMMISSIONRUN_PROCESS(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=C_YEARPERIODS(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_PURCHASEORDER(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_WORKREQUIREMENT(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_INOUT_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_POST(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_CREATE_TESTDATA(NUMERIC, NUMERIC, CHAR, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=P_WRITE_LOG(VARCHAR); ] (created for the database PostgreSql server) [alterdatabasedata] SQL Command failed with: ERROR: column "y" does not exist [alterdatabasedata] -- END [alterdatabasedata] UPDATE C_ACCTSCHEMA SET ALLOWNEGATIVE=(Y) WHERE EXISTS (SELECT 1 FROM C_ACCTSCHEMA_ WHERE C_ACCTSCHEMA.C_ACCTSCHEMA_ID::text=C_ACCTSCHEMA_.C_ACCTSCHEMA_ID::text) AND ALLOWNEGATIVE IS NULL [alterdatabasedata] Executed 102 SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] SQL Command failed with: ERROR: cannot change number of columns in view [alterdatabasedata] Executed 1 forced SQL command(s) with 1 error(s) [alterdatabasedata] There are still 1 forced commands not executed sucessfully. [alterdatabasedata] Enabling foreign keys [alterdatabasedata] Executed 2154 SQL command(s) with 0 error(s) [alterdatabasedata] Enabling triggers [alterdatabasedata] Executed 326 SQL command(s) with 0 error(s) [alterdatabasedata] Executing default postscript [alterdatabasedata] Executed 6 SQL command(s) with 0 error(s) database.postcreate.POSTGRE: [sql] Executing commands [sql] 8 of 8 SQL statements executed successfully BUILD SUCCESSFUL Total time: 5 minutes 43 seconds