Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008711 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 05. Production management | minor | always | 2009-04-22 16:34 | 2009-05-05 00:00 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | AinhoaPagola | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | bcd29d3a8fbd | ||||
| Projection | none | ETA | none | Target Version | pi | |||
| OS | Linux 32 bit | Database | Any | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | Ant version | 1.7 | ||||
| Product Version | pi | 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 | 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). | |||||||
| Tags | 250MP1 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0015614) hgbot (developer) 2009-04-23 12:57 |
Repository: erp/devel/pi Changeset: bcd29d3a8fbdc2bcbc7cd0d738cf2d80a317ec5d Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com> Date: Wed Apr 22 17:00:48 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/bcd29d3a8fbdc2bcbc7cd0d738cf2d80a317ec5d [^] Fixes bug 8711: Wrong constraint in m_transaction. UUID --- M src-db/database/model/tables/M_TRANSACTION.xml --- |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |