Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011658 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-12-07 15:31 | 2010-06-15 14:02 | |||
| Reporter | naveednoor | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | d7a238243698 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | Oracle | Java version | JDK 1.6 | |||
| OS Version | XP Pro | Database version | 10 XE | Ant version | 1.7 | |||
| Product Version | 2.50MP9 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011658: when i tried to insert "next step" in workflow windows then i get trigger error | |||||||
| Description | 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' | |||||||
| Steps To Reproduce | Just 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' | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |