Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024544Openbravo ERP08. Project and service managementpublic2013-08-20 11:002013-08-21 18:59
Reportervmromanos 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian 5.0
Product Version 
Target Version3.0MP27Fixed in Version3.0MP27 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024544: C_PROJECT_VALUE unique constraint in C_Project table should include AD_ORG_ID
DescriptionThe C_PROJECT_VALUE unique constraint inside the C_Project table is defined as (client, value). This is wrong since two different organizations may have a contract with the same name
Steps To Reproduce1. Go to Multiphase Project window
2. Create a Project with search key "Test" for F&B España
3. Create a Project with search key "Test" for F&B US. An error is shown
Proposed SolutionRedefine C_PROJECT_VALUE constraint to:
<index name="C_PROJECT_VALUE" unique="true">
        <index-column name="AD_CLIENT_ID"/>
        <index-column name="AD_ORG_ID"/>
        <index-column name="VALUE"/>
</index>

Note that this change will produce a false API change
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0019009 closed dmiguelez Project name is unique between Service Project and Multiphase Project 
related to defect 0024551 closed dmiguelez False API positive with constraint C_Project_Value 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-08-20 11:00vmromanosNew Issue
2013-08-20 11:00vmromanosAssigned To => dmiguelez
2013-08-20 11:00vmromanosModules => Core
2013-08-20 11:00vmromanosTriggers an Emergency Pack => No
2013-08-21 10:47dmiguelezRelationship addedrelated to 0019009
2013-08-21 11:00dmiguelezRelationship addedrelated to 0024551
2013-08-21 11:02hgbotCheckin
2013-08-21 11:02hgbotNote Added: 0060700
2013-08-21 11:02hgbotStatusnew => resolved
2013-08-21 11:02hgbotResolutionopen => fixed
2013-08-21 11:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6ca87037847e8b4323388162a6251149cc178e66 [^]
2013-08-21 11:59vmromanosReview Assigned To => vmromanos
2013-08-21 11:59vmromanosNote Added: 0060703
2013-08-21 11:59vmromanosStatusresolved => closed
2013-08-21 11:59vmromanosFixed in Version => 3.0MP27
2013-08-21 18:59hudsonbotCheckin
2013-08-21 18:59hudsonbotNote Added: 0060720

Notes
(0060700)
hgbot   
2013-08-21 11:02   
Repository: erp/devel/pi
Changeset: 6ca87037847e8b4323388162a6251149cc178e66
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Aug 21 11:01:14 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6ca87037847e8b4323388162a6251149cc178e66 [^]

Fixes Issue 24544, 19009. Updates C_Project_Value unique constraint.
Now is Client + Organization + Project Category + Value.

---
M src-db/database/model/tables/C_PROJECT.xml
---
(0060703)
vmromanos   
2013-08-21 11:59   
Code review + testing OK
(0060720)
hudsonbot   
2013-08-21 18:59   
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/5a759279dc34 [^]

Maturity status: Test