Openbravo Issue Tracking System - Openbravo ERP
Then when going to Master Data Management || Import Data || Import Budget || Import Budget even if it is possible see the imported data, an error is thrown when Import Budget button is pressed.
[http-8380-7] ERROR org.openbravo.erpCommon.ad_process.ImportBudgetData - SQL error in query: UPDATE I_BudgetLine SET C_BudgetLine_ID=( SELECT MIN(C_BudgetLine_ID) FROM C_BudgetLine bl WHERE COALESCE(I_BudgetLine.C_ELEMENTVALUE_ID,-1) = COALESCE(bl.C_ELEMENTVALUE_ID,-1) AND COALESCE(I_BudgetLine.C_Period_ID,-1) = COALESCE(bl.C_Period_ID,-1) AND COALESCE(I_BudgetLine.C_Bpartner_ID,-1) = COALESCE(bl.C_Bpartner_ID,-1) AND COALESCE(I_BudgetLine.AD_OrgTrx_ID,-1) = COALESCE(bl.AD_OrgTrx_ID,-1) AND COALESCE(I_BudgetLine.C_SalesRegion_ID,-1) = COALESCE(bl.C_SalesRegion_ID,-1) AND COALESCE(I_BudgetLine.C_Project_ID,-1) = COALESCE(bl.C_Project_ID,-1) AND COALESCE(I_BudgetLine.C_Campaign_ID,-1) = COALESCE(bl.C_Campaign_ID,-1) AND COALESCE(I_BudgetLine.C_Activity_ID,-1) = COALESCE(bl.C_Activity_ID,-1) AND COALESCE(I_BudgetLine.C_BP_Group_ID,-1) = COALESCE(bl.C_BP_Group_ID,-1) AND COALESCE(I_BudgetLine.M_Product_ID,-1) = COALESCE(bl.M_Product_ID,-1) AND COALESCE(I_BudgetLine.M_Product_Category_ID,-1) = COALESCE(bl.M_Product_Category_ID,-1) AND COALESCE(I_BudgetLine.C_Currency_ID,-1) = COALESCE(bl.C_Currency_ID,-1) AND bl.C_Budget_ID = ? AND bl.AD_Client_ID = I_BudgetLine.AD_Client_ID ) WHERE I_IsImported='N' AND AD_Client_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: COALESCE types character varying and integer cannot be matched
Navigate to Master Data Management || Import Data || Import Budget || Import Budget.
Hit the Import Budget button.
| duplicate of | defect | 0015202 | 2.50MP25 | closed | adrianromero | Import Budget failure |
budget.csv (299) 2010-06-23 17:28https://issues.openbravo.com/file_download.php?file_id=2708&type=bug