Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015202
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-11-16 14:212011-05-24 10:57
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5bfe9f4aff42
ProjectionnoneETAnoneTarget Version2.50MP25
OSLinux 32 bitDatabaseAnyJava version1.6.0_18
OS VersionCommunity ApplianceDatabase versionAnt version1.7.1
Product Version2.50MP20SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015202: 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"
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0014699 closeddalsasua Import budget process fails 
has duplicate defect 0013754 closedadrianromero Error when importing Budgets 
blocks defect 00155013.0RC4 closedadrianromero Import Budget failure 

-  Notes
(0032878)
adrianromero (manager)
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 (manager)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2010-11-16 14:21 networkb New Issue
2010-11-16 14:21 networkb Assigned To => dalsasua
2010-11-16 14:22 networkb Issue Monitored: emartinez
2010-11-16 14:24 networkb Relationship added related to 0014699
2010-11-16 14:25 networkb Relationship added related to 0013754
2010-11-17 13:20 adrianromero Target Version 2.50MP24 => 2.50MP25
2010-11-24 13:20 networkb Priority high => immediate
2010-11-25 12:46 adrianromero Assigned To dalsasua => adrianromero
2010-11-26 14:25 adrianromero Note Added: 0032878
2010-11-26 14:25 adrianromero Status new => scheduled
2010-11-26 14:26 adrianromero Status scheduled => resolved
2010-11-26 14:26 adrianromero Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/98e90bfa0c54 [^]
2010-11-26 14:26 adrianromero Resolution open => fixed
2010-11-26 14:27 adrianromero Note Added: 0032879
2010-12-21 13:36 hgbot Checkin
2010-12-21 13:36 hgbot Note Added: 0033341
2010-12-21 13:36 hgbot Fixed in SCM revision https://code.openbravo.com/erp/devel/pi/rev/98e90bfa0c54 [^] => http://code.openbravo.com/erp/stable/2.50/rev/5bfe9f4aff42360ce7c1db84500f39f66fe73cf0 [^]
2010-12-21 13:41 adrianromero Issue cloned 0015501
2010-12-21 13:41 adrianromero Relationship added blocks 0015501
2010-12-21 13:49 adrianromero Relationship replaced has duplicate 0014699
2010-12-21 13:49 adrianromero Relationship replaced has duplicate 0013754
2011-05-24 10:02 dalsasua Tag Attached: closingMay2011
2011-05-24 10:57 dalsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker