Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006502Openbravo ERP02. Master data managementpublic2008-12-11 18:282009-04-21 11:09
ReporterYoris 
Assigned Tovmromanos 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Versionubuntu intrepid
Product Version2.40 
Target VersionFixed 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
Summary0006502: Error: no existe la función concat(text,integer)
DescriptionThis error jumps when trying to add a "Bank Account" to a BPartner, it always happens in ubuntu intrepid and windows XP/Vista.
Steps To ReproduceMaster Data Management->BPartner->Bank Account->New
the correct length of a bk acc. in Argentina is 10-15 (usually 12) digits and the iban number is 24 digits long (including Country Code)
fill out all mandatory fields and iban & acc no fields and try to save the account.... (checking either "Show generic" or "Show IBAN" (or both just to try)
Proposed Solutionnone for the problem above, but incresing the digit limit number on Number Account Fields could be on track.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006640 closed vmromanos Error: no existe la función concat(text,integer) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-11 18:28YorisNew Issue
2008-12-11 18:28YorisAssigned To => rafaroda
2008-12-11 18:28Yorissf_bug_id0 => 2417799
2008-12-12 08:39pjuvaraIssue Monitored: rmorley
2008-12-12 08:42pjuvaraPrioritynormal => urgent
2008-12-12 08:42pjuvaraPriorityurgent => high
2008-12-12 20:07pjuvaraNote Added: 0011280
2008-12-12 20:07pjuvaraSeveritycritical => major
2008-12-12 20:07pjuvaraNote Edited: 0011280
2008-12-18 11:32rafarodaStatusnew => scheduled
2008-12-18 11:32rafarodaNote Added: 0011511
2008-12-18 11:32rafarodaAssigned Torafaroda => dalsasua
2008-12-18 11:32rafarodafix_in_branch => trunk
2008-12-23 12:49YorisIssue Monitored: Yoris
2008-12-31 11:58vmromanosAssigned Todalsasua => vmromanos
2008-12-31 12:52svnbotCheckin
2008-12-31 12:52svnbotNote Added: 0011788
2008-12-31 12:52svnbotStatusscheduled => resolved
2008-12-31 12:52svnbotResolutionopen => fixed
2008-12-31 12:52svnbotsvn_revision => 11623
2009-01-30 18:30YorisIssue End Monitor: Yoris
2009-04-21 11:09psarobeStatusresolved => closed

Notes
(0011280)
pjuvara   
2008-12-12 20:07   
Downgrading severity from critical to major as we reserve critical for issues that cause production systems to go down.
(0011511)
rafaroda   
2008-12-18 11:32   
This error message is displayed due to C_BP_BANKACCOUNTIBAN_TRG [1]. This trigger uses CONCAT(String 1, String 2) function [2] that exists in Oracle but not in PostgreSQL: Error: no existe la función concat(text,integer)

Proposed solution: change CONCAT function by PostgreSQL compatible concatenation using pipes ||

[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/triggers/C_BP_BANKACCOUNTIBAN_TRG.xml [^]
[2] http://www.techonthenet.com/oracle/functions/concat.php [^]
(0011788)
svnbot   
2008-12-31 12:52   
Repository: openbravo
Revision: 11623
Author: vmromanos
Date: 2008-12-31 12:52:29 +0100 (Wed, 31 Dec 2008)

Fixed bug 6502: Error in C_BP_BANKACCOUNTIBAN_TRG trigger

---
U trunk/src-db/database/model/triggers/C_BP_BANKACCOUNTIBAN_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11623&sc=1 [^]