Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019492Openbravo ERP08. Project and service managementpublic2012-01-13 12:432012-03-02 15:40
Reporterjonalegriaesarte 
Assigned ToioritzCia 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP9Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019492: The use can change the header organization in project window, when the project has lines
DescriptionThe use can change the header organization in project window, when the project has lines.

We have checked the same problem in Product and in Warehouse and storages bin windows.
Steps To Reproduce- Create a project header
- Create one line
- Change the organization in the header
Proposed SolutionIn other windows, the window shows an error. The user should remove the lines before changing the organization. All the windows should be reviewed.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00195612.50MP40 closed ioritzCia The use can change the header organization in project window, when the project has lines 
has duplicate defect 0020085 closed Sandrahuguet Change organization in Multiphase Project does not propagate to phases 
blocks design defect 0022314 new Triage Omni OMS In some windows the Organization can be changed and this change is not propagated to all its child records 
Attached Filesdiff 19492.diff (3,271) 2012-01-27 15:52
https://issues.openbravo.com/file_download.php?file_id=4932&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-01-13 12:43jonalegriaesarteNew Issue
2012-01-13 12:43jonalegriaesarteAssigned To => jonalegriaesarte
2012-01-13 12:43jonalegriaesarteModules => Core
2012-01-13 14:08jonalegriaesarteProposed Solution updated
2012-01-16 16:13VictorVillarResolution time => 1329174000
2012-01-16 16:13VictorVillarPrioritynormal => urgent
2012-01-16 16:13VictorVillarReproducibilityhave not tried => always
2012-01-16 16:13VictorVillarDescription Updatedbug_revision_view_page.php?rev_id=3067#r3067
2012-01-16 16:13VictorVillarProposed Solution updated
2012-01-16 16:13VictorVillarIssue Monitored: networkb
2012-01-23 10:26jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-01-25 16:45ioritzCiaStatusnew => scheduled
2012-01-25 16:45ioritzCiafix_in_branch => pi
2012-01-26 17:43ioritzCiaStatusscheduled => resolved
2012-01-26 17:43ioritzCiaFixed in SCM revision => 3fe916f3aa96afc61f00473c551c7ccb1add5277
2012-01-26 17:43ioritzCiaResolutionopen => fixed
2012-01-26 18:00ioritzCiaNote Added: 0044617
2012-01-27 15:48hgbotCheckin
2012-01-27 15:48hgbotNote Added: 0044643
2012-01-27 15:52ioritzCiaStatusresolved => new
2012-01-27 15:52ioritzCiaResolutionfixed => open
2012-01-27 15:52ioritzCiaFile Added: 19492.diff
2012-01-27 15:52ioritzCiaStatusnew => scheduled
2012-01-27 15:53ioritzCiaNote Added: 0044644
2012-01-27 15:53ioritzCiaStatusscheduled => resolved
2012-01-27 15:53ioritzCiaResolutionopen => fixed
2012-01-28 04:10hudsonbotCheckin
2012-01-28 04:10hudsonbotNote Added: 0044674
2012-01-30 17:58ioritzCiaStatusresolved => new
2012-01-30 17:58ioritzCiaResolutionfixed => open
2012-01-30 17:59ioritzCiaPriorityurgent => high
2012-01-30 17:59ioritzCiaSeveritymajor => minor
2012-01-30 17:59ioritzCiafix_in_branchpi =>
2012-01-30 17:59ioritzCiaStatusnew => scheduled
2012-01-30 17:59ioritzCiafix_in_branch => pi
2012-01-31 09:49jonalegriaesarteTarget Version3.0MP8 => 3.0MP9
2012-01-31 09:49jonalegriaesartefix_in_branchpi =>
2012-01-31 17:51hgbotCheckin
2012-01-31 17:51hgbotNote Added: 0044742
2012-01-31 17:51hgbotStatusscheduled => resolved
2012-01-31 17:51hgbotResolutionopen => fixed
2012-01-31 17:51hgbotFixed in SCM revision3fe916f3aa96afc61f00473c551c7ccb1add5277 => http://code.openbravo.com/erp/stable/2.50/rev/81ee13513de1d00f8d8a93e3ac800871b7d4f729 [^]
2012-02-01 09:25hgbotCheckin
2012-02-01 09:25hgbotNote Added: 0044762
2012-02-01 09:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.50/rev/81ee13513de1d00f8d8a93e3ac800871b7d4f729 [^] => http://code.openbravo.com/erp/devel/pi/rev/e2817093d0b87e7aa69c6fd345dbfff8180658e9 [^]
2012-02-16 11:11ioritzCiaStatusresolved => new
2012-02-16 11:11ioritzCiaResolutionfixed => open
2012-02-16 11:11hgbotCheckin
2012-02-16 11:11hgbotNote Added: 0045178
2012-02-17 09:48jonalegriaesarteNote Added: 0045219
2012-02-29 17:33hgbotCheckin
2012-02-29 17:33hgbotNote Added: 0045626
2012-02-29 17:33hgbotStatusnew => resolved
2012-02-29 17:33hgbotResolutionopen => fixed
2012-02-29 17:33hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e2817093d0b87e7aa69c6fd345dbfff8180658e9 [^] => http://code.openbravo.com/erp/devel/pi/rev/7be373a943ba5a539adfb55f43242bfe76af3f0b [^]
2012-03-01 17:46malsasuaNote Added: 0045678
2012-03-01 17:46malsasuaStatusresolved => closed
2012-03-02 15:33hudsonbotCheckin
2012-03-02 15:33hudsonbotNote Added: 0045715
2012-03-02 15:37hudsonbotCheckin
2012-03-02 15:37hudsonbotNote Added: 0045865
2012-03-02 15:40hudsonbotCheckin
2012-03-02 15:40hudsonbotNote Added: 0046002
2012-04-12 17:36vmromanosRelationship addedhas duplicate 0020085
2014-02-05 13:41ngarciaRelationship addedblocks 0022314

Notes
(0044617)
ioritzCia   
2012-01-26 18:00   
Testing:

The organization of the header can still be changed but only if it is in the organization tree of the organization in the lines.

Try to:

- Change among different locations from different branches in the organiztion tree.
- As the change has been done in the triggers of tables c_project, m_product and m_warehouse, try to insert, update and delete projects, products or warehouses.
(0044643)
hgbot   
2012-01-27 15:48   
Repository: erp/devel/pi
Changeset: 7321604b503bd3a411e99e754001d73495d4cac5
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Jan 27 15:44:48 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7321604b503bd3a411e99e754001d73495d4cac5 [^]

Backed out changeset 3fe916f3aa96. Fix for issue 19492.

---
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
---
(0044644)
ioritzCia   
2012-01-27 15:53   
Attached you can find the patch for the fix.
(0044674)
hudsonbot   
2012-01-28 04:10   
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/8e16ef45b30c [^]

Maturity status: Test
(0044742)
hgbot   
2012-01-31 17:51   
Repository: erp/stable/2.50
Changeset: 81ee13513de1d00f8d8a93e3ac800871b7d4f729
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Tue Jan 31 16:56:38 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/81ee13513de1d00f8d8a93e3ac800871b7d4f729 [^]

Backed out changeset a671596b2291. Fixes issue 19492
The user can change the header organization in project window, when the project has lines.

---
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
---
(0044762)
hgbot   
2012-02-01 09:25   
Repository: erp/devel/pi
Changeset: e2817093d0b87e7aa69c6fd345dbfff8180658e9
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Feb 01 09:24:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e2817093d0b87e7aa69c6fd345dbfff8180658e9 [^]

Backed out changeset 7321604b503b. Fixes issue 19492.
The user can change the header organization in project window, when the project has lines.

---
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
---
(0045178)
hgbot   
2012-02-16 11:11   
Repository: erp/devel/pi
Changeset: 8fd83eb63b971b196e8d8e2937b573d3b726026d
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Feb 16 11:10:40 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8fd83eb63b971b196e8d8e2937b573d3b726026d [^]

Backout of the changeset e2817093d0b8. Fix for issue 19492.
Rescheduled for later.

---
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
---
(0045219)
jonalegriaesarte   
2012-02-17 09:48   
The solution should be:

- When the user changes the organization in the header, the organization in phase should be updated.
- The organization in phase should be visible (the same in tasks).
(0045626)
hgbot   
2012-02-29 17:33   
Repository: erp/devel/pi
Changeset: 7be373a943ba5a539adfb55f43242bfe76af3f0b
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Feb 29 13:03:59 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7be373a943ba5a539adfb55f43242bfe76af3f0b [^]

Fixes issue 19492: The user can change the header organization in project window,
when the project has lines.

---
M src-db/database/model/triggers/C_PROJECTPHASE_TRG.xml
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0045678)
malsasua   
2012-03-01 17:46   
tested in 3.0.15300
in postgres & oracle
test plan:
 . update record -> the organization of childs are changed -> OK
 . delete and create record -> ok

code revision:
 OK
(0045715)
hudsonbot   
2012-03-02 15:33   
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/544d64e0c159 [^]

Maturity status: Test
(0045865)
hudsonbot   
2012-03-02 15:37   
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/544d64e0c159 [^]

Maturity status: Test
(0046002)
hudsonbot   
2012-03-02 15:40   
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/544d64e0c159 [^]

Maturity status: Test