Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011658Openbravo ERPA. Platformpublic2009-12-07 15:312010-06-15 14:02
Reporternaveednoor 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS VersionXP Pro
Product Version2.50MP9 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011658: when i tried to insert "next step" in workflow windows then i get trigger error
DescriptionORA-01403: no data found
ORA-06512: at "MP8.AD_WF_NODENEXT_MOD_TRG", line 44
ORA-04088: error during execution of trigger 'MP8.AD_WF_NODENEXT_MOD_TRG'
Steps To ReproduceJust create any new work flow and its nodes and for any node try to insert its next node. this error will be occurred every time.
ORA-01403: no data found
ORA-06512: at "MP8.AD_WF_NODENEXT_MOD_TRG", line 44
ORA-04088: error during execution of trigger 'MP8.AD_WF_NODENEXT_MOD_TRG'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-07 15:31naveednoorNew Issue
2009-12-07 15:31naveednoorAssigned To => rafaroda
2009-12-07 17:39shuehnerNote Added: 0022488
2009-12-07 22:56naveednoorNote Added: 0022514
2010-01-21 17:42psarobeOBNetwork customer => No
2010-01-21 17:42psarobeAssigned Torafaroda => alostale
2010-01-21 17:42psarobePrioritynormal => urgent
2010-01-21 17:42psarobeSeveritycritical => major
2010-01-21 17:42psarobeStatusnew => scheduled
2010-01-21 17:42psarobeCategory01. General setup => A. Platform
2010-04-23 15:14hgbotCheckin
2010-04-23 15:14hgbotNote Added: 0026638
2010-04-23 15:14hgbotStatusscheduled => resolved
2010-04-23 15:14hgbotResolutionopen => fixed
2010-04-23 15:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72a9865d5f183bb45891454ba34c9ee620dc5ca3 [^]
2010-05-12 18:27marvintmNote Added: 0027179
2010-05-12 18:27marvintmStatusresolved => closed
2010-05-12 18:27marvintmFixed in Version => pi
2010-05-13 00:00anonymoussf_bug_id0 => 3000763
2010-05-14 15:27hudsonbotCheckin
2010-05-14 15:27hudsonbotNote Added: 0027289
2010-06-04 14:45hgbotCheckin
2010-06-04 14:45hgbotNote Added: 0027982
2010-06-04 14:45hgbotStatusclosed => resolved
2010-06-04 14:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/72a9865d5f183bb45891454ba34c9ee620dc5ca3 [^] => http://code.openbravo.com/erp/devel/pi/rev/d7a238243698159254afbe520df65acf01073d30 [^]
2010-06-07 21:21hudsonbotCheckin
2010-06-07 21:21hudsonbotNote Added: 0028104
2010-06-07 23:43hudsonbotCheckin
2010-06-07 23:43hudsonbotNote Added: 0028146
2010-06-15 14:02jpabloaeStatusresolved => closed

Notes
(0022488)
shuehner   
2009-12-07 17:39   
error message in pgsql is different but probably the same issue. Problem is when the trigger is executed for an insert the trigger code references :old which doesn't exist for inserts.
(0022514)
naveednoor   
2009-12-07 22:56   
To resolve this issue immediately i just disable the trigger code. Its working fine but its not validating the nodes automatically that i need to check myself to mark the next node.
(0026638)
hgbot   
2010-04-23 15:14   
Repository: erp/devel/pi
Changeset: 72a9865d5f183bb45891454ba34c9ee620dc5ca3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Apr 23 15:13:30 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/72a9865d5f183bb45891454ba34c9ee620dc5ca3 [^]

fixed bug 11658: error inserting next step in workflow

---
M src-db/database/model/triggers/AD_WF_NODENEXT_MOD_TRG.xml
---
(0027179)
marvintm   
2010-05-12 18:27   
I can insert nodes and assign the next steps without any problems, so the issue was fixed correctly.
(0027289)
hudsonbot   
2010-05-14 15:27   
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/72a9865d5f18 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/36f76c8d7193 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17198.obx [^]
(0027982)
hgbot   
2010-06-04 14:45   
Repository: erp/devel/pi
Changeset: d7a238243698159254afbe520df65acf01073d30
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Apr 23 15:13:30 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d7a238243698159254afbe520df65acf01073d30 [^]

fixed bug 11658: error inserting next step in workflow

---
M src-db/database/model/triggers/AD_WF_NODENEXT_MOD_TRG.xml
---
(0028104)
hudsonbot   
2010-06-07 21:21   
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/d7a238243698 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^]
(0028146)
hudsonbot   
2010-06-07 23:43   
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/d7a238243698 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^]