Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002552 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 03. Procurement management | minor | always | 2008-01-25 10:50 | 2008-06-12 09:43 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | rafaroda | |||||||
Priority | normal | Resolution | duplicate | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002552: OBNETWORK: error fillign order ref. after copy lines on PO) | |||||||
Description | STEPS: an order reference after copy lines from on PO Procurement Managemente>Transactions>Purchase Order When we enter an order and do not fill-in an order reference, create lines for the order and then afterwards try to fill in the order reference, we get the following error: ORA-04091: table TAD.C_ORDER is mutating, trigger/function may not see it ORA-06512: at "TAD.C_ORDLINE_CHK_RESTRICTIONS_TRG", line 27 ORA-04088: error during execution of trigger 'TAD.C_ORDLINE_CHK_RESTRICTIONS_TRG' ORA-06512: at "TAD.C_ORDER_TRG", line 48 ORA-04088: error during execution of trigger 'TAD.C_ORDER_TRG' This error is explained by the following webpage: http://www.techonthenet.com/oracle/errors/ora04091.php [^] The reason is that the trigger C_ORDER_TRG updates the C_ORDERLINES table which triggers the C_ORDLINE_CHK_RESTRICTIONS_TRG trigger. The C_ORDLINE_CHK_RESTRICTIONS_TRG trigger makes a select to the C_ORDER table which is not allowed in this case because this table is being updated! | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0003090) rafaroda (developer) 2008-01-25 10:58 edited on: 2008-06-12 09:24 |
Logged In: YES user_id=1892190 Originator: NO Duplicated in https://sourceforge.net/tracker/index.php?func=detail&aid=1879538&group_id=162271&atid=823129 [^] |
(0006141) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1879534 [^] |
Copyright © 2000 - 2009 MantisBT Group |