Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027868Openbravo ERP05. Production managementpublic2014-10-14 19:222016-06-24 22:11
Reporterfsoto82 
Assigned Tofsoto82 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027868: The "Create Standards" process throws a "ORA-01403: no data found" exception.
DescriptionWhen using Oracle the "Create Standards" process throws a "ORA-01403: no data found" exception.
Steps To ReproduceCreate a work effort for a work requirement, using only the obligatory fields.

Run "Create Standards" on "Production Run" tab on "Work Effort" window.
Proposed SolutionUse the patch in attachemnts.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00274863.0PR15Q2 closed VictorVillar The error message should be different for not having the Storage Bin defined, after executing the Create Standards 
Attached Filesdiff 27868.diff (2,151) 2014-10-14 19:33
https://issues.openbravo.com/file_download.php?file_id=7364&type=bug
diff 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 ModifiedUsernameFieldChange
2014-10-14 19:22fsoto82New Issue
2014-10-14 19:22fsoto82Assigned To => dmiguelez
2014-10-14 19:22fsoto82Modules => Core
2014-10-14 19:22fsoto82Triggers an Emergency Pack => No
2014-10-14 19:23fsoto82Statusnew => scheduled
2014-10-14 19:23fsoto82Assigned Todmiguelez => fsoto82
2014-10-14 19:23fsoto82fix_in_branch => pi
2014-10-14 19:32fsoto82fix_in_branchpi =>
2014-10-14 19:32fsoto82Proposed Solution updated
2014-10-14 19:33fsoto82Relationship addedrelated to 0027486
2014-10-14 19:33fsoto82File Added: 27868.diff
2015-05-13 15:46plujanAssigned Tofsoto82 => Triage Finance
2015-05-13 15:47plujanNote Added: 0077386
2016-06-22 18:37egoitzResolution time => 1466805600
2016-06-22 18:37egoitzPrioritynormal => immediate
2016-06-23 18:15egoitzFile Added: MA_PRODUCTIONRUN_STANDARD.diff
2016-06-23 18:17egoitzNote Added: 0087860
2016-06-24 14:37hgbotCheckin
2016-06-24 14:37hgbotNote Added: 0087907
2016-06-24 14:37hgbotStatusscheduled => resolved
2016-06-24 14:37hgbotResolutionopen => fixed
2016-06-24 14:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2514ec7e686abedcd8efb94e75853a0e417238da [^]
2016-06-24 14:40aferrazAssigned ToTriage Finance => fsoto82
2016-06-24 14:41aferrazReview Assigned To => aferraz
2016-06-24 14:41aferrazNote Added: 0087908
2016-06-24 14:41aferrazStatusresolved => closed
2016-06-24 14:41aferrazFixed in Version => 3.0PR16Q3
2016-06-24 22:11hudsonbotCheckin
2016-06-24 22:11hudsonbotNote 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
---
(0087908)
aferraz   
2016-06-24 14:41   
Code review OK
(0087915)
hudsonbot   
2016-06-24 22:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cc0900cf80c9 [^]
Maturity status: Test