Buildfile: build.xml init: code.rev: update.database: init: database.lib: clean: [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/build/classes [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/build/lib [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/docs init: [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/build/classes [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/build/lib [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/docs compile: [javac] Compiling 4 source files to /home/openbravo/work/ob_branches/r2.40/src-db/build/classes build.jar: [jar] Building jar: /home/openbravo/work/ob_branches/r2.40/src-db/build/lib/dbmanager.jar jar: [copy] Copying 1 file to /home/openbravo/work/ob_branches/r2.40/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] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (removed from database PostgreSql server) [alterdatabasedata] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Table AD_MONTH_TRL (added) [alterdatabasedata] Processing Column C_ACCTSCHEMA_GL_ID (created for table C_ACCTSCHEMA_GL) [alterdatabasedata] The primary key of table C_ACCTSCHEMA_GL will be changed [alterdatabasedata] Processing Column UPC of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column SKU of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column UPC of table M_PRODUCT_CUSTOMER (changed because of the type) [alterdatabasedata] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, 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=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (removed from database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, 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=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (created for the database PostgreSql server) [alterdatabasedata] Executed 226 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 326 SQL command(s) with 0 error(s) [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_adclientinfo" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE AD_CLIENTINFO [alterdatabasedata] DROP CONSTRAINT MPRODUCT_ADCLIENTINFO [alterdatabasedata] SQL Command failed with: ERROR: constraint "adclient_admonthtrl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE AD_MONTH_TRL [alterdatabasedata] DROP CONSTRAINT ADCLIENT_ADMONTHTRL [alterdatabasedata] SQL Command failed with: ERROR: constraint "adlanguage_admonthtrl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE AD_MONTH_TRL [alterdatabasedata] DROP CONSTRAINT ADLANGUAGE_ADMONTHTRL [alterdatabasedata] SQL Command failed with: ERROR: constraint "admonth_admonthtrl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE AD_MONTH_TRL [alterdatabasedata] DROP CONSTRAINT ADMONTH_ADMONTHTRL [alterdatabasedata] SQL Command failed with: ERROR: constraint "adorg_admonthtrl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE AD_MONTH_TRL [alterdatabasedata] DROP CONSTRAINT ADORG_ADMONTHTRL [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_aasset" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE A_ASSET [alterdatabasedata] DROP CONSTRAINT MPRODUCT_AASSET [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_caschemaelement" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_ELEMENT [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CASCHEMAELEMENT [alterdatabasedata] SQL Command failed with: ERROR: constraint "adclient_cacctschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT ADCLIENT_CACCTSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "adorg_cacctschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT ADORG_CACCTSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "cacctschema_cacctschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT CACCTSCHEMA_CACCTSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_currencybalancing_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_CURRENCYBALANCING_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_incomesummary_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_INCOMESUMMARY_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_intercompanyduefrom_cschema" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_INTERCOMPANYDUEFROM_CSCHEMA [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_intercompanydueto_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_INTERCOMPANYDUETO_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_ppvoffset_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_PPVOFFSET_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_retainedearning_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_RETAINEDEARNING_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_suspensebalancing_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_SUSPENSEBALANCING_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "vc_suspenseerror_cschemagl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ACCTSCHEMA_GL [alterdatabasedata] DROP CONSTRAINT VC_SUSPENSEERROR_CSCHEMAGL [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_c_budgetline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_BUDGETLINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_C_BUDGETLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_ccommission" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_COMMISSION [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_CCOMMISSION [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_ccommissionline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_COMMISSIONLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CCOMMISSIONLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "cdiscount_fk_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_DISCOUNT [alterdatabasedata] DROP CONSTRAINT CDISCOUNT_FK_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_c_externalpos_prod" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_EXTERNALPOS_PRODUCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_C_EXTERNALPOS_PROD [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cinvoiceline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_INVOICELINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CINVOICELINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_corderline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_ORDERLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CORDERLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cphase" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PHASE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CPHASE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cprojectissue" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PROJECTISSUE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CPROJECTISSUE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cprojectline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PROJECTLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CPROJECTLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cprojectphase" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PROJECTPHASE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CPROJECTPHASE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_c_projectproposalline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PROJECTPROPOSALLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_C_PROJECTPROPOSALLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cprojecttask" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_PROJECTTASK [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CPROJECTTASK [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_cservicelevel" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_SERVICELEVEL [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CSERVICELEVEL [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_ctask" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_TASK [alterdatabasedata] DROP CONSTRAINT MPRODUCT_CTASK [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_vc" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE C_VALIDCOMBINATION [alterdatabasedata] DROP CONSTRAINT MPRODUCT_VC [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_fact_acct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE FACT_ACCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_FACT_ACCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_i_budgetline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_BUDGETLINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_I_BUDGETLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_ogljournal" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_GLJOURNAL [alterdatabasedata] DROP CONSTRAINT MPRODUCT_OGLJOURNAL [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_iinventory" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_INVENTORY [alterdatabasedata] DROP CONSTRAINT MPRODUCT_IINVENTORY [alterdatabasedata] SQL Command failed with: ERROR: constraint "nproduct_iinvoice" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_INVOICE [alterdatabasedata] DROP CONSTRAINT NPRODUCT_IINVOICE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_iorder" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_ORDER [alterdatabasedata] DROP CONSTRAINT MPRODUCT_IORDER [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_iproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE I_PRODUCT [alterdatabasedata] DROP CONSTRAINT MPRODUCT_IPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_maglobaluse" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MA_GLOBALUSE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MAGLOBALUSE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mapccase" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MA_PC_CASE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MAPCCASE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_masequenceproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MA_SEQUENCEPRODUCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_MASEQUENCEPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_mawrphaseproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MA_WRPHASEPRODUCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_MAWRPHASEPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_run_production" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MRP_RUN_PRODUCTION [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_RUN_PRODUCTION [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_run_productionline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MRP_RUN_PRODUCTIONLINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_RUN_PRODUCTIONLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_run_purchase" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MRP_RUN_PURCHASE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_RUN_PURCHASE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_run_purchaseline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MRP_RUN_PURCHASELINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_RUN_PURCHASELINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_mrpsalesforecastline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE MRP_SALESFORECASTLINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_MRPSALESFORECASTLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mcosting_fk_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_COSTING [alterdatabasedata] DROP CONSTRAINT MCOSTING_FK_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mdiscountsline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_DISCOUNTSCHEMALINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MDISCOUNTSLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_minoutline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_INOUTLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MINOUTLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mintconsumptionline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_INTERNAL_CONSUMPTIONLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MINTCONSUMPTIONLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_minventoryline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_INVENTORYLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MINVENTORYLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mlot" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_LOT [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MLOT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mmatchinv" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_MATCHINV [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MMATCHINV [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mmatchpo" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_MATCHPO [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MMATCHPO [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mmovementline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_MOVEMENTLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MMOVEMENTLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_offer_product_product" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_OFFER_PRODUCT [alterdatabasedata] DROP CONSTRAINT M_OFFER_PRODUCT_PRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "ad_org_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT AD_ORG_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "adclient_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT ADCLIENT_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "adimage_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT ADIMAGE_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "cbpartner_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT CBPARTNER_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "ctaxcategory_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT CTAXCATEGORY_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "cuom_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT CUOM_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "ma_processplan_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MA_PROCESSPLAN_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mattributeset_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MATTRIBUTESET_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mattrsetinst_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MATTRSETINST_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mfreightcategory_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MFREIGHTCATEGORY_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mlocator_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MLOCATOR_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproductcategory" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTCATEGORY [alterdatabasedata] SQL Command failed with: ERROR: constraint "sexpensetype_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT SEXPENSETYPE_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "sresource_mproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT [alterdatabasedata] DROP CONSTRAINT SRESOURCE_MPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproductionline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCTIONLINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTIONLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproductionplan" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCTIONPLAN [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTIONPLAN [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproductprice" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCTPRICE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTPRICE [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_m_product_acct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_ACCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_M_PRODUCT_ACCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_bomproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_BOM [alterdatabasedata] DROP CONSTRAINT MPRODUCT_BOMPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproductbom" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_BOM [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTBOM [alterdatabasedata] SQL Command failed with: ERROR: constraint "adclient_mprodcust" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_CUSTOMER [alterdatabasedata] DROP CONSTRAINT ADCLIENT_MPRODCUST [alterdatabasedata] SQL Command failed with: ERROR: constraint "adorg_mprodcust" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_CUSTOMER [alterdatabasedata] DROP CONSTRAINT ADORG_MPRODCUST [alterdatabasedata] SQL Command failed with: ERROR: constraint "cbpartner_mprodcust" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_CUSTOMER [alterdatabasedata] DROP CONSTRAINT CBPARTNER_MPRODCUST [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mprodcust" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_CUSTOMER [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODCUST [alterdatabasedata] SQL Command failed with: ERROR: constraint "product_fk_productorg" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_ORG [alterdatabasedata] DROP CONSTRAINT PRODUCT_FK_PRODUCTORG [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_productpo" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_PO [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_PRODUCTPO [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproducttemplate" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_TEMPLATE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTTEMPLATE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mproducttrl" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_TRL [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MPRODUCTTRL [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_uomproduct" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_PRODUCT_UOM [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_UOMPRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_m_rappel_product" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_RAPPEL_PRODUCT [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_M_RAPPEL_PRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_replenish" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_REPLENISH [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_REPLENISH [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_product_m_requisitionline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_REQUISITIONLINE [alterdatabasedata] DROP CONSTRAINT M_PRODUCT_M_REQUISITIONLINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mstoragedetail" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_STORAGE_DETAIL [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MSTORAGEDETAIL [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_mstoragepending" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_STORAGE_PENDING [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MSTORAGEPENDING [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_substitute" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_SUBSTITUTE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_SUBSTITUTE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_substitutesub" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_SUBSTITUTE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_SUBSTITUTESUB [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_minventorycount" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_TRANSACTION [alterdatabasedata] DROP CONSTRAINT MPRODUCT_MINVENTORYCOUNT [alterdatabasedata] SQL Command failed with: ERROR: constraint "m_wh_sp_product" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE M_WH_SCHEDULE_PRODUCT [alterdatabasedata] DROP CONSTRAINT M_WH_SP_PRODUCT [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_rrequest" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE R_REQUEST [alterdatabasedata] DROP CONSTRAINT MPRODUCT_RREQUEST [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_rrequestaction" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE R_REQUESTACTION [alterdatabasedata] DROP CONSTRAINT MPRODUCT_RREQUESTACTION [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_stimeexpenseline" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE S_TIMEEXPENSELINE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_STIMEEXPENSELINE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_test" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE TEST [alterdatabasedata] DROP CONSTRAINT MPRODUCT_TEST [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_tinventoryvalue" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE T_INVENTORYVALUE [alterdatabasedata] DROP CONSTRAINT MPRODUCT_TINVENTORYVALUE [alterdatabasedata] SQL Command failed with: ERROR: constraint "mproduct_treplenish" does not exist [alterdatabasedata] -- END [alterdatabasedata] ALTER TABLE T_REPLENISH [alterdatabasedata] DROP CONSTRAINT MPRODUCT_TREPLENISH [alterdatabasedata] Executed 2152 SQL command(s) with 104 error(s) [alterdatabasedata] Executed 68 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 133 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 326 SQL command(s) with 0 error(s) [alterdatabasedata] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END [alterdatabasedata] ALTER TABLE AD_CLIENTINFO [alterdatabasedata] ADD CONSTRAINT MPRODUCT_ADCLIENTINFO FOREIGN KEY (M_PRODUCTFREIGHT_ID) REFERENCES M_PRODUCT (M_PRODUCT_ID) [alterdatabasedata] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(Unknown Source) [alterdatabasedata] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(Unknown Source) [alterdatabasedata] at org.apache.ddlutils.io.DataToDatabaseSink.end(Unknown Source) [alterdatabasedata] at org.apache.ddlutils.io.DatabaseDataIO.writeDataToDatabase(Unknown Source) [alterdatabasedata] at org.openbravo.ddlutils.task.AlterDatabaseData.execute(Unknown Source) [alterdatabasedata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [alterdatabasedata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [alterdatabasedata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [alterdatabasedata] at java.lang.reflect.Method.invoke(Method.java:585) [alterdatabasedata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [alterdatabasedata] at org.apache.tools.ant.Task.perform(Task.java:348) [alterdatabasedata] at org.apache.tools.ant.Target.execute(Target.java:357) [alterdatabasedata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [alterdatabasedata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [alterdatabasedata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) [alterdatabasedata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [alterdatabasedata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) [alterdatabasedata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [alterdatabasedata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source) [alterdatabasedata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [alterdatabasedata] at java.lang.reflect.Method.invoke(Method.java:585) [alterdatabasedata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [alterdatabasedata] at org.apache.tools.ant.Task.perform(Task.java:348) [alterdatabasedata] at org.apache.tools.ant.Target.execute(Target.java:357) [alterdatabasedata] at org.apache.tools.ant.Target.performTasks(Target.java:385) [alterdatabasedata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) [alterdatabasedata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306) [alterdatabasedata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [alterdatabasedata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189) [alterdatabasedata] at org.apache.tools.ant.Main.runBuild(Main.java:758) [alterdatabasedata] at org.apache.tools.ant.Main.startAnt(Main.java:217) [alterdatabasedata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) [alterdatabasedata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) [alterdatabasedata] Caused by: org.postgresql.util.PSQLException: ERROR: there is no unique constraint matching given keys for referenced table "m_product" [alterdatabasedata] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) [alterdatabasedata] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) [alterdatabasedata] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) [alterdatabasedata] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) [alterdatabasedata] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) [alterdatabasedata] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283) [alterdatabasedata] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) [alterdatabasedata] ... 33 more BUILD FAILED /home/openbravo/work/ob_branches/r2.40/build.xml:290: The following error occurred while executing this line: /home/openbravo/work/ob_branches/r2.40/src-db/database/build.xml:155: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key Total time: 4 minutes 37 seconds