Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0019780 | Openbravo ERP | 01. General setup | public | 2012-02-15 16:56 | 2012-04-17 05:31 |
|
| Reporter | psarobe | |
| Assigned To | Sandrahuguet | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | 3.0MP11 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0019780: Cannot apply Core and APRM dataset in two different organizations |
| Description | Exists a unique constraint in the table GL_CATEGORY that prevents to apply both datasets
This constraint is CONSTRAINT gl_category_name UNIQUE(ad_client_id, name);
It should be for the organization. I suggest
CONSTRAINT gl_category_name UNIQUE(ad_org_id, name);
This way you can insert the datasets |
| Steps To Reproduce | 1. Create a new client through the process initial client setup without applying this two datasets
2. Create an organization and apply both dataset
3. Create another organization that belongs to a different branch and apply the datasets
You cannot. An error shows up. This is wrong |
| Proposed Solution | |
| Additional Information | |
| Tags | VMA-Reviewed |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-02-15 16:56 | psarobe | New Issue | |
| 2012-02-15 16:56 | psarobe | Assigned To | => jonalegriaesarte |
| 2012-02-15 16:56 | psarobe | Modules | => Core |
| 2012-02-15 16:56 | psarobe | OBNetwork customer | => No |
| 2012-02-15 19:03 | iciordia | Assigned To | jonalegriaesarte => vmromanos |
| 2012-02-17 09:19 | vmromanos | Tag Attached: VMA-Reviewed | |
| 2012-04-03 16:58 | Sandrahuguet | Assigned To | vmromanos => Sandrahuguet |
| 2012-04-03 16:58 | Sandrahuguet | Status | new => scheduled |
| 2012-04-03 16:58 | Sandrahuguet | fix_in_branch | => pi |
| 2012-04-04 10:24 | Sandrahuguet | Note Added: 0047376 | |
| 2012-04-12 13:53 | hgbot | Checkin | |
| 2012-04-12 13:53 | hgbot | Note Added: 0047528 | |
| 2012-04-12 13:53 | hgbot | Status | scheduled => resolved |
| 2012-04-12 13:53 | hgbot | Resolution | open => fixed |
| 2012-04-12 13:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c1173672a520e415b8841506a9bd462bab2b60fa [^] |
| 2012-04-12 13:58 | vmromanos | Note Added: 0047529 | |
| 2012-04-12 13:58 | vmromanos | Status | resolved => closed |
| 2012-04-12 13:58 | vmromanos | Fixed in Version | => 3.0MP11 |
| 2012-04-12 14:00 | vmromanos | Note Added: 0047530 | |
| 2012-04-17 05:31 | hudsonbot | Checkin | |
| 2012-04-17 05:31 | hudsonbot | Note Added: 0047641 | |
|
Notes |
|
|
|
Test Plan:
1. Go to initial client setup and create a client without applying datasets
2. Create an organization and apply both dataset
3. Create another organization and apply the datasets
And you can see that now you can create both organizations |
|
|
|
(0047528)
|
|
hgbot
|
|
2012-04-12 13:53
|
|
Repository: erp/devel/pi
Changeset: c1173672a520e415b8841506a9bd462bab2b60fa
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 04 09:31:20 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c1173672a520e415b8841506a9bd462bab2b60fa [^]
Fixed bug 19780 Change the contraint gl_category_name in gl_category
Add ad_org_id to gl_category_name in gl_category.
---
M src-db/database/model/tables/GL_CATEGORY.xml
---
|
|
|
|
|
|
|
|
|
|
This change should create an API change, but it is totally safe for the user and it should not require any build validation or module script |
|
|
|
|
|