Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0014388 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | major | always | 2010-08-31 11:50 | 2010-09-13 12:38 | |||
Reporter | sivaraman | View Status | public | |||||
Assigned To | adrianromero | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 88baea3562a9 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Oracle | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP20 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0014388: Print Record is not working for Sales Order | |||||||
Description | It is not possible to print Sales Order as it throws JRException. This misbehavior can be identified only with Oracle. | |||||||
Steps To Reproduce | 1. Log on to Openbravo with 'Openbravo Admin' role 2. Go to Sales Management || Transactions || Sales Order 3. Open any Sales Order 4. Click 'Print Record' 5. A dialog box will be appeared with 'Yes' and 'No, just print it' options 6.a. Click 'Yes' and realize JRException is displayed on the screen 6.b. Click 'No, just print it' and realize Report processing failed | |||||||
Tags | Regression | |||||||
Attached Files | ![]() ![]() | |||||||
![]() |
|
![]() |
|
(0030541) adrianromero (viewer) 2010-08-31 13:43 |
This error is a consequence of the following changeset: https://code.openbravo.com/erp/devel/pi/rev/13df5b8fc723 [^] |
(0030542) hgbot (developer) 2010-08-31 14:00 |
Repository: erp/devel/pi Changeset: 88baea3562a9f0bed9bbecf27db659a9f4129fcb Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue Aug 31 13:59:57 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/88baea3562a9f0bed9bbecf27db659a9f4129fcb [^] Fixes issue 0014388: Print Record is not working for Sales Order It has been wrapped the fields UOM, CURRENCY and VALUE with the TO_CHAR() function to unify the type accross the sentences in the UNION. This way the sentence works properly in Oracle. --- M src/org/openbravo/erpReports/C_OrderLinesJR.jrxml --- |
(0030543) adrianromero (viewer) 2010-08-31 14:03 |
* Testing the issue Using Oracle and PostgreSQL as database engine try to print a sales order. It should generate a PDF document with the details of the order. * Other areas affected It has only been modified the SQL sentence of the sales report executed when printing sales order documents. No other areas affected. |
(0030572) sureshbabu (viewer) 2010-09-02 09:51 |
verified, now sales order can be printed Note: in the PDF file, the BP address value (Mafalda\n\nShunny shunshine\n11111\n\n\n) not rightly printed, i will raise a new issue for this. |
(0030709) hudsonbot (viewer) 2010-09-07 09:18 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/88baea3562a9 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4390fe5213a4 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18274.obx [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2010-08-31 11:50 | sivaraman | New Issue | |
2010-08-31 11:50 | sivaraman | Assigned To | => adrianromero |
2010-08-31 11:50 | sivaraman | File Added: error1.png | |
2010-08-31 11:50 | sivaraman | OBNetwork customer | => No |
2010-08-31 11:51 | sivaraman | File Added: error2.png | |
2010-08-31 12:15 | adrianromero | Tag Attached: Regression | |
2010-08-31 12:30 | adrianromero | Status | new => scheduled |
2010-08-31 12:30 | adrianromero | fix_in_branch | => pi |
2010-08-31 12:30 | adrianromero | Priority | normal => immediate |
2010-08-31 12:30 | adrianromero | fix_in_branch | pi => |
2010-08-31 13:43 | adrianromero | Note Added: 0030541 | |
2010-08-31 14:00 | hgbot | Checkin | |
2010-08-31 14:00 | hgbot | Note Added: 0030542 | |
2010-08-31 14:00 | hgbot | Status | scheduled => resolved |
2010-08-31 14:00 | hgbot | Resolution | open => fixed |
2010-08-31 14:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/88baea3562a9f0bed9bbecf27db659a9f4129fcb [^] |
2010-08-31 14:03 | adrianromero | Note Added: 0030543 | |
2010-09-02 09:50 | sureshbabu | Note Added: 0030568 | |
2010-09-02 09:50 | sureshbabu | Status | resolved => closed |
2010-09-02 09:51 | sureshbabu | Note Deleted: 0030568 | |
2010-09-02 09:51 | sureshbabu | Note Added: 0030572 | |
2010-09-03 19:43 | psarobe | version | => 2.50MP20 |
2010-09-07 09:18 | hudsonbot | Checkin | |
2010-09-07 09:18 | hudsonbot | Note Added: 0030709 | |
2010-09-13 12:38 | anonymous | sf_bug_id | 0 => 3065192 |
Copyright © 2000 - 2009 MantisBT Group |