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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013754
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2010-06-23 17:282010-12-22 00:00
ReporterXpandIT_ALinoView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSWindowsDatabasePostgreSQLJava version
OS Version2008Database version8.4Ant version
Product Version2.50MP18SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013754: Error when importing Budgets

DescriptionImporting a .csv file with a budget works fine.
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
Steps To ReproduceImport a .csv file with a budget.
Navigate to Master Data Management || Import Data || Import Budget || Import Budget.
Hit the Import Budget button.
TagsNo tags attached.
Attached Filescsv file icon budget.csv [^] (299 bytes) 2010-06-23 17:28

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 00152022.50MP25 closedadrianromero Import Budget failure 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2010-06-23 17:28 XpandIT_ALino New Issue
2010-06-23 17:28 XpandIT_ALino Assigned To => adrianromero
2010-06-23 17:28 XpandIT_ALino File Added: budget.csv
2010-11-16 14:25 networkb Relationship added related to 0015202
2010-12-21 13:49 adrianromero Relationship replaced duplicate of 0015202
2010-12-21 13:49 adrianromero Status new => closed
2010-12-21 13:49 adrianromero Resolution open => duplicate
2010-12-22 00:00 anonymous sf_bug_id 0 => 3141451

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker