Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0027868 | Openbravo ERP | 05. Production management | public | 2014-10-14 19:22 | 2016-06-24 22:11 |
|
| Reporter | fsoto82 | |
| Assigned To | fsoto82 | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR16Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 42570 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0027868: The "Create Standards" process throws a "ORA-01403: no data found" exception. |
| Description | When using Oracle the "Create Standards" process throws a "ORA-01403: no data found" exception. |
| Steps To Reproduce | Create a work effort for a work requirement, using only the obligatory fields.
Run "Create Standards" on "Production Run" tab on "Work Effort" window. |
| Proposed Solution | Use the patch in attachemnts. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0027486 | 3.0PR15Q2 | closed | VictorVillar | The error message should be different for not having the Storage Bin defined, after executing the Create Standards |
|
| Attached Files |  27868.diff (2,151) 2014-10-14 19:33
https://issues.openbravo.com/file_download.php?file_id=7364&type=bug
MA_PRODUCTIONRUN_STANDARD.diff (1,413) 2016-06-23 18:15
https://issues.openbravo.com/file_download.php?file_id=9573&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-10-14 19:22 | fsoto82 | New Issue | |
| 2014-10-14 19:22 | fsoto82 | Assigned To | => dmiguelez |
| 2014-10-14 19:22 | fsoto82 | OBNetwork customer | => No |
| 2014-10-14 19:22 | fsoto82 | Modules | => Core |
| 2014-10-14 19:22 | fsoto82 | Triggers an Emergency Pack | => No |
| 2014-10-14 19:23 | fsoto82 | Status | new => scheduled |
| 2014-10-14 19:23 | fsoto82 | Assigned To | dmiguelez => fsoto82 |
| 2014-10-14 19:23 | fsoto82 | fix_in_branch | => pi |
| 2014-10-14 19:32 | fsoto82 | fix_in_branch | pi => |
| 2014-10-14 19:32 | fsoto82 | Proposed Solution updated | |
| 2014-10-14 19:33 | fsoto82 | Relationship added | related to 0027486 |
| 2014-10-14 19:33 | fsoto82 | File Added: 27868.diff | |
| 2015-05-13 15:46 | plujan | Assigned To | fsoto82 => Triage Finance |
| 2015-05-13 15:47 | plujan | Note Added: 0077386 | |
| 2016-06-22 18:37 | egoitz | Support ticket | => 42570 |
| 2016-06-22 18:37 | egoitz | Resolution time | => 1466805600 |
| 2016-06-22 18:37 | egoitz | Priority | normal => immediate |
| 2016-06-22 18:38 | egoitz | OBNetwork customer | No => Yes |
| 2016-06-23 18:15 | egoitz | File Added: MA_PRODUCTIONRUN_STANDARD.diff | |
| 2016-06-23 18:17 | egoitz | Note Added: 0087860 | |
| 2016-06-24 14:37 | hgbot | Checkin | |
| 2016-06-24 14:37 | hgbot | Note Added: 0087907 | |
| 2016-06-24 14:37 | hgbot | Status | scheduled => resolved |
| 2016-06-24 14:37 | hgbot | Resolution | open => fixed |
| 2016-06-24 14:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2514ec7e686abedcd8efb94e75853a0e417238da [^] |
| 2016-06-24 14:40 | aferraz | Assigned To | Triage Finance => fsoto82 |
| 2016-06-24 14:41 | aferraz | Review Assigned To | => aferraz |
| 2016-06-24 14:41 | aferraz | Note Added: 0087908 | |
| 2016-06-24 14:41 | aferraz | Status | resolved => closed |
| 2016-06-24 14:41 | aferraz | Fixed in Version | => 3.0PR16Q3 |
| 2016-06-24 22:11 | hudsonbot | Checkin | |
| 2016-06-24 22:11 | hudsonbot | Note Added: 0087915 | |
|
Notes |
|
|
(0077386)
|
|
plujan
|
|
2015-05-13 15:47
|
|
|
This issue has an attached diff. If it fix the issue, consider including it in the dev branch to mark the issue as fixed |
|
|
|
(0087860)
|
|
egoitz
|
|
2016-06-23 18:17
|
|
attached other change required.
Notice that if the a query does not return any result redirecting to a variable using the select into var sentence
cause a error on oracle so it is needed to ensure that the query always return results and in case of error, that the error is captured with the exception block |
|
|
|
(0087907)
|
|
hgbot
|
|
2016-06-24 14:37
|
|
Repository: erp/devel/pi
Changeset: 2514ec7e686abedcd8efb94e75853a0e417238da
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Tue Oct 14 12:30:24 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/2514ec7e686abedcd8efb94e75853a0e417238da [^]
Fixes issue 27868: The Create Standards process throws ORA-01403: no data found
Modified MA_PRODUCTIONRUN_STANDARD to catch the exception.
---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
|
|
|
|
|
|
|
|
|
|