Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016831 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2011-04-15 15:14 | 2011-05-05 10:07 | |||
| Reporter | jonalegriaesarte | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0RC7 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | df01c4ee458e | ||||
| 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 | 0016831: 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 | Regression | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0035999) hgbot (developer) 2011-04-15 16:50 |
Repository: erp/devel/pi Changeset: df01c4ee458e92cd5a6159ed7418ff24f705358a Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Fri Apr 15 15:23:27 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/df01c4ee458e92cd5a6159ed7418ff24f705358a [^] Fixes issue 16831: A trigger condition in c_orderline has been added. The condition in the trigger is removed --- M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml --- |
|
(0036379) jonalegriaesarte (viewer) 2011-05-05 10:06 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-04-15 15:14 | jonalegriaesarte | New Issue | |
| 2011-04-15 15:14 | jonalegriaesarte | Assigned To | => dalsasua |
| 2011-04-15 15:14 | jonalegriaesarte | Modules | => Core |
| 2011-04-15 15:14 | jonalegriaesarte | OBNetwork customer | => Yes |
| 2011-04-15 15:15 | jonalegriaesarte | Relationship added | depends on 0015594 |
| 2011-04-15 15:15 | jonalegriaesarte | Tag Attached: Regression | |
| 2011-04-15 15:18 | dalsasua | Status | new => scheduled |
| 2011-04-15 15:18 | dalsasua | fix_in_branch | => pi |
| 2011-04-15 15:42 | dalsasua | Relationship deleted | depends on 0015594 |
| 2011-04-15 15:43 | dalsasua | Relationship added | related to 0016321 |
| 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:50 | hgbot | Checkin | |
| 2011-04-15 16:50 | hgbot | Note Added: 0035999 | |
| 2011-04-15 16:50 | hgbot | Status | scheduled => resolved |
| 2011-04-15 16:50 | hgbot | Resolution | open => fixed |
| 2011-04-15 16:50 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/df01c4ee458e92cd5a6159ed7418ff24f705358a [^] |
| 2011-05-05 10:06 | jonalegriaesarte | Note Added: 0036379 | |
| 2011-05-05 10:07 | jonalegriaesarte | Status | resolved => closed |
| 2011-05-05 10:07 | jonalegriaesarte | Fixed in Version | => 3.0RC7 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |