Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015202Openbravo ERP09. Financial managementpublic2010-11-16 14:212011-05-24 10:57
Reporternetworkb 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP20 
Target Version2.50MP25Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015202: Import Budget failure
DescriptionWhen 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 Reproduce1) 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"
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
has duplicate defect 0014699 closed dalsasua Import budget process fails 
has duplicate defect 0013754 closed adrianromero Error when importing Budgets 
blocks defect 00155013.0RC4 closed adrianromero Import Budget failure 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-16 14:21networkbNew Issue
2010-11-16 14:21networkbAssigned To => dalsasua
2010-11-16 14:22networkbIssue Monitored: emartinez
2010-11-16 14:24networkbRelationship addedrelated to 0014699
2010-11-16 14:25networkbRelationship addedrelated to 0013754
2010-11-17 13:20adrianromeroTarget Version2.50MP24 => 2.50MP25
2010-11-24 13:20networkbPriorityhigh => immediate
2010-11-25 12:46adrianromeroAssigned Todalsasua => adrianromero
2010-11-26 14:25adrianromeroNote Added: 0032878
2010-11-26 14:25adrianromeroStatusnew => scheduled
2010-11-26 14:26adrianromeroStatusscheduled => resolved
2010-11-26 14:26adrianromeroFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/98e90bfa0c54 [^]
2010-11-26 14:26adrianromeroResolutionopen => fixed
2010-11-26 14:27adrianromeroNote Added: 0032879
2010-12-21 13:36hgbotCheckin
2010-12-21 13:36hgbotNote Added: 0033341
2010-12-21 13:36hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/devel/pi/rev/98e90bfa0c54 [^] => http://code.openbravo.com/erp/stable/2.50/rev/5bfe9f4aff42360ce7c1db84500f39f66fe73cf0 [^]
2010-12-21 13:41adrianromeroIssue cloned0015501
2010-12-21 13:41adrianromeroRelationship addedblocks 0015501
2010-12-21 13:49adrianromeroRelationship replacedhas duplicate 0014699
2010-12-21 13:49adrianromeroRelationship replacedhas duplicate 0013754
2011-05-24 10:02dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0032878)
adrianromero   
2010-11-26 14:25   
0015202: Import Budget failure
It has been fixed the sql sentences that caused the errors
src/org/openbravo/erpCommon/ad_process/ImportBudget_data.xsql
(0032879)
adrianromero   
2010-11-26 14:27   
* 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.
(0033341)
hgbot   
2010-12-21 13:36   
Repository: erp/stable/2.50
Changeset: 5bfe9f4aff42360ce7c1db84500f39f66fe73cf0
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Dec 21 13:30:15 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/5bfe9f4aff42360ce7c1db84500f39f66fe73cf0 [^]

Fixes issue 0015202: Import Budget failure
One more point of failure has been fixed for the organization field

---
M src/org/openbravo/erpCommon/ad_process/ImportBudget_data.xsql
---