Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0027440 | Openbravo ERP | 07. Sales management | public | 2014-08-23 17:03 | 2015-09-11 06:33 | |||||||
| Reporter | shuehner | |||||||||||
| Assigned To | AtulOpenbravo | |||||||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | dmiguelez | |||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0027440: pl-function c_order_status is broken: uuid bug | |||||||||||
| Description | This function is broken and fails if it is called and should return '2' for a process order with a line which has no associated shipment of invoice or payment. Technically error is the v_CountNotPaid variable being varchar2 where it should be NUMBER. Technically this is a regression as that variable was changed accidently when introducing uuid's in 2.50 (commit: 8a0fe0193bef). | |||||||||||
| Steps To Reproduce | Create a new sales order with one line and book it. Look up c_order_id of that order run select c_order_status('this-uuid'); See following error: ERROR: operator does not exist: character varying <> integer LINE 1: ...ed <> 0 AND v_CountNotInvoiced <> 0 AND v_CountNotPaid <> 0) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT (v_CountNotDelivered <> 0 AND v_CountNotInvoiced <> 0 AND v_CountNotPaid <> 0) CONTEXT: PL/pgSQL function c_order_status(character varying) line 80 at IF | |||||||||||
| Proposed Solution | Change variable back to NUMBER | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2014-08-23 17:03 | shuehner | New Issue | ||||||||||
| 2014-08-23 17:03 | shuehner | Assigned To | => dmiguelez | |||||||||
| 2014-08-23 17:03 | shuehner | Modules | => Core | |||||||||
| 2014-08-23 17:03 | shuehner | Triggers an Emergency Pack | => No | |||||||||
| 2014-08-23 17:06 | shuehner | Relationship added | related to 0027441 | |||||||||
| 2014-08-23 17:06 | shuehner | Note Added: 0069652 | ||||||||||
| 2014-09-03 13:55 | eduardo_Argal | Assigned To | dmiguelez => eduardo_Argal | |||||||||
| 2015-07-15 19:57 | AtulOpenbravo | Assigned To | eduardo_Argal => AtulOpenbravo | |||||||||
| 2015-07-15 19:57 | AtulOpenbravo | Status | new => scheduled | |||||||||
| 2015-09-09 18:09 | hgbot | Checkin | ||||||||||
| 2015-09-09 18:09 | hgbot | Note Added: 0080289 | ||||||||||
| 2015-09-09 18:09 | hgbot | Status | scheduled => resolved | |||||||||
| 2015-09-09 18:09 | hgbot | Resolution | open => fixed | |||||||||
| 2015-09-09 18:09 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/16ed86fcdf7f0c17d54790cfeeda0546617d7001 [^] | |||||||||
| 2015-09-09 18:10 | dmiguelez | Review Assigned To | => dmiguelez | |||||||||
| 2015-09-09 18:10 | dmiguelez | Note Added: 0080290 | ||||||||||
| 2015-09-09 18:10 | dmiguelez | Status | resolved => closed | |||||||||
| 2015-09-11 06:33 | hudsonbot | Checkin | ||||||||||
| 2015-09-11 06:33 | hudsonbot | Note Added: 0080322 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||