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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006502
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2008-12-11 18:282009-04-21 11:09
ReporterYorisView Statuspublic 
Assigned Tovmromanos 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11623
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version6
OS Versionubuntu intrepidDatabase version8.3Ant version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006502: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0006640 closedvmromanos Error: no existe la función concat(text,integer) 

-  Notes
(0011280)
pjuvara (reporter)
2008-12-12 20:07
edited on: 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 (developer)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-12-11 18:28 Yoris New Issue
2008-12-11 18:28 Yoris Assigned To => rafaroda
2008-12-11 18:28 Yoris sf_bug_id 0 => 2417799
2008-12-12 08:39 pjuvara Issue Monitored: rmorley
2008-12-12 08:42 pjuvara Priority normal => urgent
2008-12-12 08:42 pjuvara Priority urgent => high
2008-12-12 20:07 pjuvara Note Added: 0011280
2008-12-12 20:07 pjuvara Severity critical => major
2008-12-12 20:07 pjuvara Note Edited: 0011280
2008-12-18 11:32 rafaroda Status new => scheduled
2008-12-18 11:32 rafaroda Note Added: 0011511
2008-12-18 11:32 rafaroda Assigned To rafaroda => dalsasua
2008-12-18 11:32 rafaroda fix_in_branch => trunk
2008-12-23 12:49 Yoris Issue Monitored: Yoris
2008-12-31 11:58 vmromanos Assigned To dalsasua => vmromanos
2008-12-31 12:52 svnbot Checkin
2008-12-31 12:52 svnbot Note Added: 0011788
2008-12-31 12:52 svnbot Status scheduled => resolved
2008-12-31 12:52 svnbot Resolution open => fixed
2008-12-31 12:52 svnbot svn_revision => 11623
2009-01-30 18:30 Yoris Issue End Monitor: Yoris
2009-04-21 11:09 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker