0015501: Import Budget failure

Description

When importing Budgets from "Import Budget" window, there is an error from the SQL Query:

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

In Oracle the error is:
Exception:java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

Steps To Reproduce

1) Go to Financial Management || Accounting || Transactions || Budget || Header and Export the budget in excel
2) Edit it and save it to CSV
3) Then go to Master Data Management || Import Data || Import File Loader || Import File Loader and import the file (and process)
4) Finally go to any register of Master Data Management || Import Data || Import Budget || Import Budget, and click on "Import Budget"

See the error message is: "Process failed during execution"

Tags

closingMay2011

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

defect

0015202

2.50MP25

closed

adrianromero

Import Budget failure

Notes
(0033344) adrianromero (manager) 2010-12-21 13:47 edited on: 2010-12-21 13:47	author Adrián Romero <adrian romero at openbravo.com> Tue Dec 21 13:42:55 2010 +0100 (2 minutes ago) changeset 9281 f7e969d5f864 parent 9257 977963e2daf8 child 9282 baf91bb87e64 Fixes issue 001501: Import Budget failure One more point of failure has been fixed for the organization field src/org/openbravo/erpCommon/ad_process/ImportBudget_data.xsql

(0033345) adrianromero (manager) 2010-12-21 13:48	* Testing the issue Just follow the steps to test and verify that budget records has been properly imported. It is required to test the issue in Posgresql and Oracle * Other areas affected Only the Budged import process is affected.

Issue History
Date Modified	Username	Field	Change
2010-12-21 13:41	adrianromero	New Issue
2010-12-21 13:41	adrianromero	Assigned To	=> adrianromero
2010-12-21 13:41	adrianromero	Modules	=> Core
2010-12-21 13:41	adrianromero	Issue generated from	0015202
2010-12-21 13:41	adrianromero	Relationship added	depends on 0015202
2010-12-21 13:46	adrianromero	Status	new => scheduled
2010-12-21 13:47	adrianromero	Note Added: 0033344
2010-12-21 13:47	adrianromero	Resolution	open => fixed
2010-12-21 13:47	adrianromero	Fixed in SCM revision	=> https://code.openbravo.com/erp/devel/pi/rev/f7e969d5f864 [^]
2010-12-21 13:47	adrianromero	Note Edited: 0033344	View Revisions
2010-12-21 13:48	adrianromero	Status	scheduled => resolved
2010-12-21 13:48	adrianromero	Note Added: 0033345
2011-05-24 10:02	dalsasua	Tag Attached: closingMay2011
2011-05-24 10:57	dalsasua	Status	resolved => closed