Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008827Openbravo ERPZ. Otherspublic2009-04-29 13:132011-10-28 12:23
AinhoaPagola 
shuehner 
normalminorhave not tried
closedno change required 
20Ubuntu 8.4
pi 
 
Core
No
0008827: Not correctly treated exception in C_BANKSTATEMENT_POST
In 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.
Just change

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

for RAISE;
No tags attached.
related to defect 0008395 closed AinhoaPagola Wrong error message when cannot complete POS order 
Issue History
2009-04-29 13:13AinhoaPagolaNew Issue
2009-04-29 13:13AinhoaPagolaAssigned To => rafaroda
2009-04-29 13:13AinhoaPagolaRegression testing => No
2009-04-29 13:21AinhoaPagolaRelationship addedrelated to 0008395
2009-04-29 17:42psarobeStatusnew => scheduled
2009-04-29 17:42psarobefix_in_branch => pi
2009-05-15 18:09rafarodaAssigned Torafaroda => shuehner
2011-10-28 12:23psarobeNote Added: 0042217
2011-10-28 12:23psarobeStatusscheduled => closed
2011-10-28 12:23psarobeResolutionopen => no change required

Notes
(0042217)
psarobe   
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 [^]