Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008711 | Openbravo ERP | 05. Production management | public | 2009-04-22 16:34 | 2009-05-05 00:00 |
| Reporter | AinhoaPagola | ||||
| Assigned To | AinhoaPagola | ||||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | Ubuntu 8.4 | |
| Product Version | pi | ||||
| Target Version | pi | Fixed in Version | 2.50MP1 | ||
| 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 | 0008711: Wrong constraint on m_transaction table- UUID | ||||
| Description | Internal Consumption Process fails because it can not insert lines in M_transaction. The error is: 2009-04-22 16:00:17 CEST NOTICE: @ERROR=insert or update on table "m_transaction" violates foreign key constraint "m_intl_consump_mtransaction" It is also reproducible in 2.40. | ||||
| Steps To Reproduce | Create a new Internal Consuption and try to process it. | ||||
| Proposed Solution | CONSTRAINT m_intl_consump_mtransaction FOREIGN KEY (m_internal_consumptionline_id) REFERENCES m_internal_consumption (m_internal_consumption_id) MATCH SIMPLE Is wrong. It references the header instead of the line. The pl is right and tries to insert the line ID, but it fails because the header id is expected (because of the wrong constraint). | ||||
| Additional Information | |||||
| Tags | 250MP1 | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-04-22 16:34 | AinhoaPagola | New Issue | |||
| 2009-04-22 16:34 | AinhoaPagola | Assigned To | => rafaroda | ||
| 2009-04-22 16:34 | AinhoaPagola | OBNetwork customer | => No | ||
| 2009-04-22 16:34 | AinhoaPagola | Regression testing | => No | ||
| 2009-04-22 16:36 | psarobe | Priority | normal => urgent | ||
| 2009-04-22 16:36 | psarobe | Status | new => scheduled | ||
| 2009-04-22 16:36 | psarobe | Summary | Wrong constraint on m_transaction table => Wrong constraint on m_transaction table- UUID | ||
| 2009-04-22 17:00 | AinhoaPagola | Assigned To | rafaroda => AinhoaPagola | ||
| 2009-04-23 12:57 | hgbot | Checkin | |||
| 2009-04-23 12:57 | hgbot | Note Added: 0015614 | |||
| 2009-04-23 12:57 | hgbot | Status | scheduled => resolved | ||
| 2009-04-23 12:57 | hgbot | Resolution | open => fixed | ||
| 2009-04-23 12:57 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bcd29d3a8fbdc2bcbc7cd0d738cf2d80a317ec5d [^] | ||
| 2009-04-23 18:23 | psarobe | Tag Attached: 250MP1 | |||
| 2009-05-04 18:30 | psarobe | Status | resolved => closed | ||
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786916 | ||
| Notes | |||||
|
|
|||||
|
|
||||