Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011658
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-12-07 15:312010-06-15 14:02
ReporternaveednoorView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisiond7a238243698
ProjectionnoneETAnoneTarget Version
OSWindowsDatabaseOracleJava versionJDK 1.6
OS VersionXP ProDatabase version10 XEAnt version1.7
Product Version2.50MP9SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011658: 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'
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0022488)
shuehner (administrator)
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 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2009-12-07 15:31 naveednoor New Issue
2009-12-07 15:31 naveednoor Assigned To => rafaroda
2009-12-07 17:39 shuehner Note Added: 0022488
2009-12-07 22:56 naveednoor Note Added: 0022514
2010-01-21 17:42 psarobe Assigned To rafaroda => alostale
2010-01-21 17:42 psarobe Priority normal => urgent
2010-01-21 17:42 psarobe Severity critical => major
2010-01-21 17:42 psarobe Status new => scheduled
2010-01-21 17:42 psarobe Category 01. General setup => A. Platform
2010-04-23 15:14 hgbot Checkin
2010-04-23 15:14 hgbot Note Added: 0026638
2010-04-23 15:14 hgbot Status scheduled => resolved
2010-04-23 15:14 hgbot Resolution open => fixed
2010-04-23 15:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72a9865d5f183bb45891454ba34c9ee620dc5ca3 [^]
2010-05-12 18:27 marvintm Note Added: 0027179
2010-05-12 18:27 marvintm Status resolved => closed
2010-05-12 18:27 marvintm Fixed in Version => pi
2010-05-13 00:00 anonymous sf_bug_id 0 => 3000763
2010-05-14 15:27 hudsonbot Checkin
2010-05-14 15:27 hudsonbot Note Added: 0027289
2010-06-04 14:45 hgbot Checkin
2010-06-04 14:45 hgbot Note Added: 0027982
2010-06-04 14:45 hgbot Status closed => resolved
2010-06-04 14:45 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/72a9865d5f183bb45891454ba34c9ee620dc5ca3 [^] => http://code.openbravo.com/erp/devel/pi/rev/d7a238243698159254afbe520df65acf01073d30 [^]
2010-06-07 21:21 hudsonbot Checkin
2010-06-07 21:21 hudsonbot Note Added: 0028104
2010-06-07 23:43 hudsonbot Checkin
2010-06-07 23:43 hudsonbot Note Added: 0028146
2010-06-15 14:02 jpabloae Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker