Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010093 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-07-28 18:56 | 2009-10-06 11:15 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP6 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 7ecc16757e3b | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| 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 | 0010093: Error in design or in concept | |||||||
| Description | It 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 Reproduce | 1. 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 Solution | If 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) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  error_dal_1.PNG [^] (111,733 bytes) 2009-07-28 18:56
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0019688) hgbot (developer) 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 (developer) 2009-09-10 10:26 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/852/ [^] ------ |
|
(0019696) hudsonbot (developer) 2009-09-10 10:38 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/745/ [^] ------ |
|
(0019719) hudsonbot (developer) 2009-09-10 12:31 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/340/ [^] ------ |
|
(0019720) hudsonbot (developer) 2009-09-10 12:39 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/346/ [^] ------ |
|
(0019732) hudsonbot (developer) 2009-09-10 14:38 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^] ------ |
|
(0019745) hudsonbot (developer) 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 (developer) 2009-09-10 17:33 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^] ------ |
|
(0019769) hudsonbot (developer) 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 (developer) 2009-09-10 23:15 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^] ------ |
|
(0019789) hudsonbot (developer) 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 (developer) 2009-09-11 10:39 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/60/ [^] ------ |
|
(0019831) hudsonbot (developer) 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 (developer) 2009-09-11 23:15 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^] ------ |
|
(0019858) hudsonbot (developer) 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 (developer) 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 (developer) 2009-09-14 11:51 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^] ------ |
|
(0019927) hudsonbot (developer) 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 (developer) 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 (developer) 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 (developer) 2009-09-14 23:15 |
Fixed Issue 10093 ------ Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^] ------ |
|
(0020061) hudsonbot (developer) 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 (developer) 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 (manager) 2009-10-06 11:15 |
Closed again because hudson has reopened without no reason |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-28 18:56 | psarobe | New Issue | |
| 2009-07-28 18:56 | psarobe | Assigned To | => iciordia |
| 2009-07-28 18:56 | psarobe | File Added: error_dal_1.PNG | |
| 2009-07-28 18:56 | psarobe | Status | new => scheduled |
| 2009-07-28 18:56 | psarobe | fix_in_branch | => pi |
| 2009-07-28 19:30 | psarobe | Assigned To | iciordia => dalsasua |
| 2009-07-28 19:30 | psarobe | fix_in_branch | pi => |
| 2009-07-28 19:30 | psarobe | Description Updated | |
| 2009-07-28 19:30 | psarobe | Steps to Reproduce Updated | |
| 2009-09-10 10:00 | vmromanos | Assigned To | dalsasua => vmromanos |
| 2009-09-10 10:19 | hgbot | Checkin | |
| 2009-09-10 10:19 | hgbot | Note Added: 0019688 | |
| 2009-09-10 10:19 | hgbot | Status | scheduled => resolved |
| 2009-09-10 10:19 | hgbot | Resolution | open => fixed |
| 2009-09-10 10:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^] |
| 2009-09-10 10:26 | hudsonbot | Checkin | |
| 2009-09-10 10:26 | hudsonbot | Note Added: 0019689 | |
| 2009-09-10 10:26 | hudsonbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^] => |
| 2009-09-10 10:38 | hudsonbot | Checkin | |
| 2009-09-10 10:38 | hudsonbot | Note Added: 0019696 | |
| 2009-09-10 12:31 | hudsonbot | Checkin | |
| 2009-09-10 12:31 | hudsonbot | Note Added: 0019719 | |
| 2009-09-10 12:39 | hudsonbot | Checkin | |
| 2009-09-10 12:39 | hudsonbot | Note Added: 0019720 | |
| 2009-09-10 14:38 | hudsonbot | Checkin | |
| 2009-09-10 14:38 | hudsonbot | Note Added: 0019732 | |
| 2009-09-10 16:04 | hudsonbot | Checkin | |
| 2009-09-10 16:04 | hudsonbot | Note Added: 0019745 | |
| 2009-09-10 17:33 | hudsonbot | Checkin | |
| 2009-09-10 17:33 | hudsonbot | Note Added: 0019758 | |
| 2009-09-10 21:17 | hudsonbot | Checkin | |
| 2009-09-10 21:17 | hudsonbot | Note Added: 0019769 | |
| 2009-09-10 23:15 | hudsonbot | Checkin | |
| 2009-09-10 23:15 | hudsonbot | Note Added: 0019779 | |
| 2009-09-11 07:08 | hudsonbot | Checkin | |
| 2009-09-11 07:08 | hudsonbot | Note Added: 0019789 | |
| 2009-09-11 10:39 | hudsonbot | Checkin | |
| 2009-09-11 10:39 | hudsonbot | Note Added: 0019796 | |
| 2009-09-11 21:17 | hudsonbot | Checkin | |
| 2009-09-11 21:17 | hudsonbot | Note Added: 0019831 | |
| 2009-09-11 23:15 | hudsonbot | Checkin | |
| 2009-09-11 23:15 | hudsonbot | Note Added: 0019846 | |
| 2009-09-12 21:17 | hudsonbot | Checkin | |
| 2009-09-12 21:17 | hudsonbot | Note Added: 0019858 | |
| 2009-09-13 21:17 | hudsonbot | Checkin | |
| 2009-09-13 21:17 | hudsonbot | Note Added: 0019873 | |
| 2009-09-14 11:51 | hudsonbot | Checkin | |
| 2009-09-14 11:51 | hudsonbot | Note Added: 0019895 | |
| 2009-09-14 18:37 | hudsonbot | Checkin | |
| 2009-09-14 18:37 | hudsonbot | Note Added: 0019927 | |
| 2009-09-14 19:57 | hudsonbot | Checkin | |
| 2009-09-14 19:57 | hudsonbot | Note Added: 0019949 | |
| 2009-09-14 21:17 | hudsonbot | Checkin | |
| 2009-09-14 21:17 | hudsonbot | Note Added: 0019980 | |
| 2009-09-14 23:15 | hudsonbot | Checkin | |
| 2009-09-14 23:15 | hudsonbot | Note Added: 0020006 | |
| 2009-09-15 12:35 | hudsonbot | Checkin | |
| 2009-09-15 12:35 | hudsonbot | Note Added: 0020061 | |
| 2009-09-18 10:13 | psarobe | Status | resolved => closed |
| 2009-09-18 10:13 | psarobe | Fixed in Version | => 2.50MP6 |
| 2009-09-19 00:00 | anonymous | sf_bug_id | 0 => 2861724 |
| 2009-09-29 14:10 | hgbot | Checkin | |
| 2009-09-29 14:10 | hgbot | Note Added: 0020457 | |
| 2009-09-29 14:10 | hgbot | Status | closed => resolved |
| 2009-09-29 14:10 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7ecc16757e3b6f83592dafd0f11d2c69f91a157d [^] |
| 2009-10-06 11:15 | psarobe | Status | resolved => closed |
| 2009-10-06 11:15 | psarobe | Note Added: 0020746 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |