Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021933 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | always | 2012-10-15 11:23 | 2012-11-21 06:06 | |||
| Reporter | pramakrishnan | View Status | public | |||||
| Assigned To | pramakrishnan | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | a7d41be10b1b | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| 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 | 0021933: API Change : Cascade on delete options for constraints in m_matchpo table | |||||||
| Description | When records are deleted from Goods Receipt Lines and Goods Shipment Lines, they are not removed from M_Matchpo. So we are not able to delete lines that are created from Orders. | |||||||
| Steps To Reproduce | 1. Use create from option to create lines in Goods Shipment from any Order. 2. Try to delete that line. It will show dependency error. | |||||||
| Proposed Solution | cascade on delete option is needed for the following fields in m_matchpo 1. m_inoutline_id 2. c_orderline_id API change is needed. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0053349) iciordia (manager) 2012-10-15 12:04 |
Pandee, I don't see an evaluation of the risk of this api change. Please add it to the issue and I will react (talk to Eduardo for guidance). Ismael |
|
(0053352) pramakrishnan (developer) 2012-10-15 14:44 |
This API change does not have any risk because, before doing the fix for the issue https://issues.openbravo.com/view.php?id=19043, [^] no action will trigger this cascade delete constraint as the completed goods receipt can never be deleted. But now I have added rows in m_matchpo before completing an shipment which throws the dependency error in goods receipt lines. This occurs only when creating lines from order since the cascade delete constraint is already present in m_matchinv. After discussing with Pablo Sarobe, he told the cascade delete constraint is only needed for the column m_inoutline_id and not for c_orderline_id. |
|
(0053357) iciordia (manager) 2012-10-15 18:33 |
Approved. Ismael |
|
(0054225) hgbot (developer) 2012-11-14 13:36 |
Repository: erp/devel/pi Changeset: a7d41be10b1bb59d84f47a6667ffdbe483fdf776 Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> Date: Tue Oct 16 13:13:02 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/a7d41be10b1bb59d84f47a6667ffdbe483fdf776 [^] Fixes Issue 21933 : Cascade on delete options for m_inoutline_id in m_matchpo --- M src-db/database/model/tables/M_MATCHPO.xml --- |
|
(0054236) Sandrahuguet (developer) 2012-11-14 16:09 |
Code review + testing OK |
|
(0054379) hudsonbot (developer) 2012-11-21 06:06 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c3c5e61b0164 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-10-15 11:23 | pramakrishnan | New Issue | |
| 2012-10-15 11:23 | pramakrishnan | Assigned To | => dmiguelez |
| 2012-10-15 11:23 | pramakrishnan | Modules | => Core |
| 2012-10-15 11:24 | pramakrishnan | Assigned To | dmiguelez => iciordia |
| 2012-10-15 12:04 | iciordia | Note Added: 0053349 | |
| 2012-10-15 14:44 | pramakrishnan | Note Added: 0053352 | |
| 2012-10-15 18:33 | iciordia | Note Added: 0053357 | |
| 2012-10-15 18:33 | iciordia | Assigned To | iciordia => pramakrishnan |
| 2012-10-16 13:06 | pramakrishnan | Status | new => scheduled |
| 2012-10-16 13:06 | pramakrishnan | fix_in_branch | => pi |
| 2012-11-14 13:36 | hgbot | Checkin | |
| 2012-11-14 13:36 | hgbot | Note Added: 0054225 | |
| 2012-11-14 13:36 | hgbot | Status | scheduled => resolved |
| 2012-11-14 13:36 | hgbot | Resolution | open => fixed |
| 2012-11-14 13:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a7d41be10b1bb59d84f47a6667ffdbe483fdf776 [^] |
| 2012-11-14 16:09 | Sandrahuguet | Note Added: 0054236 | |
| 2012-11-14 16:09 | Sandrahuguet | Status | resolved => closed |
| 2012-11-21 06:06 | hudsonbot | Checkin | |
| 2012-11-21 06:06 | hudsonbot | Note Added: 0054379 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |