0015501: Import Budget failure - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015501

Openbravo ERP

09. Financial management

public

2010-12-21 13:41

2011-05-24 10:57

Reporter

adrianromero

Assigned To

adrianromero

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Community Appliance

Product Version

3.0RC3

Target Version

3.0RC4

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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"

Proposed Solution

Additional Information