Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019780Openbravo ERP01. General setuppublic2012-02-15 16:562012-04-17 05:31
Reporterpsarobe 
Assigned ToSandrahuguet 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP11 
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
Summary0019780: Cannot apply Core and APRM dataset in two different organizations
DescriptionExists 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 Reproduce1. 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
TagsVMA-Reviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-15 16:56psarobeNew Issue
2012-02-15 16:56psarobeAssigned To => jonalegriaesarte
2012-02-15 16:56psarobeModules => Core
2012-02-15 19:03iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-17 09:19vmromanosTag Attached: VMA-Reviewed
2012-04-03 16:58SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-04-03 16:58SandrahuguetStatusnew => scheduled
2012-04-03 16:58Sandrahuguetfix_in_branch => pi
2012-04-04 10:24SandrahuguetNote Added: 0047376
2012-04-12 13:53hgbotCheckin
2012-04-12 13:53hgbotNote Added: 0047528
2012-04-12 13:53hgbotStatusscheduled => resolved
2012-04-12 13:53hgbotResolutionopen => fixed
2012-04-12 13:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c1173672a520e415b8841506a9bd462bab2b60fa [^]
2012-04-12 13:58vmromanosNote Added: 0047529
2012-04-12 13:58vmromanosStatusresolved => closed
2012-04-12 13:58vmromanosFixed in Version => 3.0MP11
2012-04-12 14:00vmromanosNote Added: 0047530
2012-04-17 05:31hudsonbotCheckin
2012-04-17 05:31hudsonbotNote Added: 0047641

Notes
(0047376)
Sandrahuguet   
2012-04-04 10:24   
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
---
(0047529)
vmromanos   
2012-04-12 13:58   
code review + testing OK
(0047530)
vmromanos   
2012-04-12 14:00   
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
(0047641)
hudsonbot   
2012-04-17 05:31   
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/cedf57621434 [^]

Maturity status: Test