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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008827
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminorhave not tried2009-04-29 13:132011-10-28 12:23
ReporterAinhoaPagolaView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.4Database version8.3Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008827: Not correctly treated exception in C_BANKSTATEMENT_POST

DescriptionIn C_BANKSTATEMENT_POST there is a exception raised with the following code:

RAISE_APPLICATION_ERROR(-20000, SUBSTR(SQLERRM,12,2000)) ;

This will only work in Oracle, as ORA-XXXXX string is added to the thrown SQLERRM. This way, the substr instruction removes the previous exceptions ORA-xxxxx, as it will be added again with raise_application_error instruction.

This 12 characters are not added in Postgre so it will not work properly.
Proposed SolutionJust change

RAISE_APPLICATION_ERROR(-20000, SUBSTR(SQLERRM,12,2000)) ;

for RAISE;
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0008395 closedAinhoaPagola Wrong error message when cannot complete POS order 

-  Notes
(0042217)
psarobe (manager)
2011-10-28 12:23

Openbravo provides community support only for the latest Openbravo version, which is Openbravo 3. This version has significantly improved financial flow and this issue is not present there. Upgrade path from Openbravo 2.50 to latest Openbravo version is available so we recommend to upgrade your instance to get this issue fixed.

Life cycle guarantee (backporting bug fixes to the previos to latest releases (Openbravo 2.40, 2.50)) is available for Professional Edition subscribers only. Please register your ticket through Openbravo Support Portal (http://support.openbravo.com/ [^]) if you have valid Professional subscription.

You can find more details about our Support policy in the following blog post
http://paolojuvara.blogspot.com/2009/12/maintenance-policy-for-openbravo-250.html [^]

- Issue History
Date Modified Username Field Change
2009-04-29 13:13 AinhoaPagola New Issue
2009-04-29 13:13 AinhoaPagola Assigned To => rafaroda
2009-04-29 13:13 AinhoaPagola Regression testing => No
2009-04-29 13:21 AinhoaPagola Relationship added related to 0008395
2009-04-29 17:42 psarobe Status new => scheduled
2009-04-29 17:42 psarobe fix_in_branch => pi
2009-05-15 18:09 rafaroda Assigned To rafaroda => shuehner
2011-10-28 12:23 psarobe Note Added: 0042217
2011-10-28 12:23 psarobe Status scheduled => closed
2011-10-28 12:23 psarobe Resolution open => no change required


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker