Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010093Openbravo ERPA. Platformpublic2009-07-28 18:562009-10-06 11:15
Reporterpsarobe 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010093: Error in design or in concept
DescriptionIt seems to be an error in concept or in design and it could happen in lots of places. Let me explain:

1. We have the data set for Taxes: Configuration for Spain (Impuestos para España)
2. The Data access level for it is: Client/Organization
3. So you could apply this data set to any organization that belong to different org trees. Having this structure:
  *
  --Main
    ----A
    ----B
4. Through Enterprise module management you can apply this data set to A
5. But if you want to apply it to B, it crashes due a constraint in C_TAXCATEGORY table which is a Unique constraint (AD_CLIENT_ID, NAME)


Steps To Reproduce1. Install Taxes module for Spain
2. Rebuild the system
3. Login as Openbravo Admin role
4. Go to General setup->Enterprise->Enterprise module management
5. Apply the data set for A
6. Apply the data set for B

See the error in the ATTACH
Proposed SolutionIf the table C_TAXCATEGORY is defined as data access level=Client/Organization then the unique constraint has to be changed to (AD_CLIENT_ID, AD_ORG_ID, NAME)
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng error_dal_1.PNG (111,733) 2009-07-28 18:56
https://issues.openbravo.com/file_download.php?file_id=1601&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-07-28 18:56psarobeNew Issue
2009-07-28 18:56psarobeAssigned To => iciordia
2009-07-28 18:56psarobeFile Added: error_dal_1.PNG
2009-07-28 18:56psarobeOBNetwork customer => No
2009-07-28 18:56psarobeStatusnew => scheduled
2009-07-28 18:56psarobefix_in_branch => pi
2009-07-28 19:30psarobeAssigned Toiciordia => dalsasua
2009-07-28 19:30psarobefix_in_branchpi =>
2009-07-28 19:30psarobeDescription Updated
2009-07-28 19:30psarobeSteps to Reproduce Updated
2009-09-10 10:00vmromanosAssigned Todalsasua => vmromanos
2009-09-10 10:19hgbotCheckin
2009-09-10 10:19hgbotNote Added: 0019688
2009-09-10 10:19hgbotStatusscheduled => resolved
2009-09-10 10:19hgbotResolutionopen => fixed
2009-09-10 10:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^]
2009-09-10 10:26hudsonbotCheckin
2009-09-10 10:26hudsonbotNote Added: 0019689
2009-09-10 10:26hudsonbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^] =>
2009-09-10 10:38hudsonbotCheckin
2009-09-10 10:38hudsonbotNote Added: 0019696
2009-09-10 12:31hudsonbotCheckin
2009-09-10 12:31hudsonbotNote Added: 0019719
2009-09-10 12:39hudsonbotCheckin
2009-09-10 12:39hudsonbotNote Added: 0019720
2009-09-10 14:38hudsonbotCheckin
2009-09-10 14:38hudsonbotNote Added: 0019732
2009-09-10 16:04hudsonbotCheckin
2009-09-10 16:04hudsonbotNote Added: 0019745
2009-09-10 17:33hudsonbotCheckin
2009-09-10 17:33hudsonbotNote Added: 0019758
2009-09-10 21:17hudsonbotCheckin
2009-09-10 21:17hudsonbotNote Added: 0019769
2009-09-10 23:15hudsonbotCheckin
2009-09-10 23:15hudsonbotNote Added: 0019779
2009-09-11 07:08hudsonbotCheckin
2009-09-11 07:08hudsonbotNote Added: 0019789
2009-09-11 10:39hudsonbotCheckin
2009-09-11 10:39hudsonbotNote Added: 0019796
2009-09-11 21:17hudsonbotCheckin
2009-09-11 21:17hudsonbotNote Added: 0019831
2009-09-11 23:15hudsonbotCheckin
2009-09-11 23:15hudsonbotNote Added: 0019846
2009-09-12 21:17hudsonbotCheckin
2009-09-12 21:17hudsonbotNote Added: 0019858
2009-09-13 21:17hudsonbotCheckin
2009-09-13 21:17hudsonbotNote Added: 0019873
2009-09-14 11:51hudsonbotCheckin
2009-09-14 11:51hudsonbotNote Added: 0019895
2009-09-14 18:37hudsonbotCheckin
2009-09-14 18:37hudsonbotNote Added: 0019927
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019949
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019980
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0020006
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020061
2009-09-18 10:13psarobeStatusresolved => closed
2009-09-18 10:13psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861724
2009-09-29 14:10hgbotCheckin
2009-09-29 14:10hgbotNote Added: 0020457
2009-09-29 14:10hgbotStatusclosed => resolved
2009-09-29 14:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^]
2009-10-06 11:15psarobeStatusresolved => closed
2009-10-06 11:15psarobeNote Added: 0020746

Notes
(0019688)
hgbot   
2009-09-10 10:19   
Repository: erp/devel/pi
Changeset: 7ecc16757e3b6f83592dafd0f11d2c69f91a157d
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Sep 10 10:18:59 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^]

Fixed bug 10093: Modified unique constraint in C_TAXCATEGORY and C_TAX tables

---
M src-db/database/model/tables/C_TAX.xml
M src-db/database/model/tables/C_TAXCATEGORY.xml
---
(0019689)
hudsonbot   
2009-09-10 10:26   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/852/ [^]
------
(0019696)
hudsonbot   
2009-09-10 10:38   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/745/ [^]
------
(0019719)
hudsonbot   
2009-09-10 12:31   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/340/ [^]
------
(0019720)
hudsonbot   
2009-09-10 12:39   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/346/ [^]
------
(0019732)
hudsonbot   
2009-09-10 14:38   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019745)
hudsonbot   
2009-09-10 16:04   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/170/ [^]
------
(0019758)
hudsonbot   
2009-09-10 17:33   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019769)
hudsonbot   
2009-09-10 21:17   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/171/ [^]
------
(0019779)
hudsonbot   
2009-09-10 23:15   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019789)
hudsonbot   
2009-09-11 07:08   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/172/ [^]
------
(0019796)
hudsonbot   
2009-09-11 10:39   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/60/ [^]
------
(0019831)
hudsonbot   
2009-09-11 21:17   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/173/ [^]
------
(0019846)
hudsonbot   
2009-09-11 23:15   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019858)
hudsonbot   
2009-09-12 21:17   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/174/ [^]
------
(0019873)
hudsonbot   
2009-09-13 21:17   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/175/ [^]
------
(0019895)
hudsonbot   
2009-09-14 11:51   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019927)
hudsonbot   
2009-09-14 18:37   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/176/ [^]
------
(0019949)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019980)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0020006)
hudsonbot   
2009-09-14 23:15   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020061)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10093

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020457)
hgbot   
2009-09-29 14:10   
Repository: erp/devel/pi-pageddatagrid
Changeset: 7ecc16757e3b6f83592dafd0f11d2c69f91a157d
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Sep 10 10:18:59 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^]

Fixed bug 10093: Modified unique constraint in C_TAXCATEGORY and C_TAX tables

---
M src-db/database/model/tables/C_TAX.xml
M src-db/database/model/tables/C_TAXCATEGORY.xml
---
(0020746)
psarobe   
2009-10-06 11:15   
Closed again because hudson has reopened without no reason