Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016832 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 07. Sales management | major | always | 2011-04-15 15:14 | 2011-05-03 10:48 | |||
| Reporter | jonalegriaesarte | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP29 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | e6bb116f2a6c | |||
| Projection | none | ETA | none | Target Version | 2.50MP29 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP28 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016832: A trigger condition in c_orderline has been added and can cause problems in special conditions | |||||||
| Description | This piece of code has been added to src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml: IF(UPDATING OR INSERTING) THEN IF (:NEW.C_BPARTNER_ID IS NOT NULL AND :NEW.C_BPARTNER_LOCATION_ID IS NULL) THEN RAISE_APPLICATION_ERROR(-20000, '@LocationNotNullConstraint@'); END IF; END IF; This piece of code is trying to simulate the old behavior when the line is not a discount. This piece of code is wrong because in some special conditions the user can not insert lines or modify existing lines where this field is null. The original bug is solved without this change in the trigger. | |||||||
| Steps To Reproduce | Remove the Business Partner Address field from the purchase order line windows. Create a purchase order; fill in all the necessary fields. Create a line for the order; fill in all the necessary fields. Save the line. Trigger restriction makes the save to fail. | |||||||
| Proposed Solution | This piece of code must be deleted. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0035994) hgbot (developer) 2011-04-15 15:22 |
Repository: erp/stable/2.50 Changeset: 31fa3266b55b52960f051c727d44708c4a73634a Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Fri Apr 15 15:21:32 2011 +0200 URL: http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^] Fixes 16832: A trigger condition in c_orderline has been added. The condition in the trigger has been removed --- M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml --- |
|
(0036141) jonalegriaesarte (viewer) 2011-04-27 18:43 |
Verified |
|
(0036235) hgbot (developer) 2011-04-29 19:32 |
Repository: erp/stable/2.50 Changeset: e6bb116f2a6cf983628fcf18d8253fd5a940675a Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Fri Apr 15 15:21:32 2011 +0200 URL: http://code.openbravo.com/erp/stable/2.50/rev/e6bb116f2a6cf983628fcf18d8253fd5a940675a [^] Fixes 16832: A trigger condition in c_orderline has been added. The condition in the trigger has been removed --- M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml --- |
|
(0036297) jonalegriaesarte (viewer) 2011-05-03 10:48 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-04-15 15:18 | dalsasua | Type | defect => backport |
| 2011-04-15 15:18 | dalsasua | fix_in_branch | => 2.50 |
| 2011-04-15 15:22 | hgbot | Checkin | |
| 2011-04-15 15:22 | hgbot | Note Added: 0035994 | |
| 2011-04-15 15:22 | hgbot | Status | scheduled => resolved |
| 2011-04-15 15:22 | hgbot | Resolution | open => fixed |
| 2011-04-15 15:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^] |
| 2011-04-15 15:41 | dalsasua | Status | resolved => new |
| 2011-04-15 15:41 | dalsasua | Resolution | fixed => open |
| 2011-04-15 15:41 | dalsasua | Relationship added | related to 0015594 |
| 2011-04-15 15:41 | dalsasua | Status | new => scheduled |
| 2011-04-15 15:41 | dalsasua | fix_in_branch | 2.50 => pi |
| 2011-04-15 15:41 | dalsasua | Status | scheduled => resolved |
| 2011-04-15 15:41 | dalsasua | Resolution | open => fixed |
| 2011-04-15 16:43 | dalsasua | Status | resolved => new |
| 2011-04-15 16:43 | dalsasua | Resolution | fixed => open |
| 2011-04-15 16:43 | dalsasua | fix_in_branch | pi => |
| 2011-04-15 16:43 | dalsasua | Description Updated | View Revisions |
| 2011-04-15 16:43 | dalsasua | Steps to Reproduce Updated | View Revisions |
| 2011-04-15 16:43 | dalsasua | Status | new => scheduled |
| 2011-04-15 16:43 | dalsasua | fix_in_branch | => pi |
| 2011-04-15 16:44 | dalsasua | Status | scheduled => resolved |
| 2011-04-15 16:44 | dalsasua | Resolution | open => fixed |
| 2011-04-27 18:43 | jonalegriaesarte | Note Added: 0036141 | |
| 2011-04-27 18:43 | jonalegriaesarte | Status | resolved => closed |
| 2011-04-27 18:43 | jonalegriaesarte | Fixed in Version | => 2.50MP29 |
| 2011-04-29 19:32 | hgbot | Checkin | |
| 2011-04-29 19:32 | hgbot | Note Added: 0036235 | |
| 2011-04-29 19:32 | hgbot | Status | closed => resolved |
| 2011-04-29 19:32 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.50/rev/31fa3266b55b52960f051c727d44708c4a73634a [^] => http://code.openbravo.com/erp/stable/2.50/rev/e6bb116f2a6cf983628fcf18d8253fd5a940675a [^] |
| 2011-05-03 10:48 | jonalegriaesarte | Note Added: 0036297 | |
| 2011-05-03 10:48 | jonalegriaesarte | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |