Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024544
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementmajoralways2013-08-20 11:002013-08-21 18:59
ReportervmromanosView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version3.0MP27
StatusclosedFix in branchFixed in SCM revision6ca87037847e
ProjectionnoneETAnoneTarget Version3.0MP27
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionDebian 5.0Database version8.3.8Ant version1.7.0
Product VersionSCM revision 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024544: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0019009 closeddmiguelez Project name is unique between Service Project and Multiphase Project 
related to defect 0024551 closeddmiguelez False API positive with constraint C_Project_Value 

-  Notes
(0060700)
hgbot (developer)
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 (viewer)
2013-08-21 11:59

 Code review + testing OK
(0060720)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2013-08-20 11:00 vmromanos New Issue
2013-08-20 11:00 vmromanos Assigned To => dmiguelez
2013-08-20 11:00 vmromanos Modules => Core
2013-08-20 11:00 vmromanos OBNetwork customer => No
2013-08-20 11:00 vmromanos Triggers an Emergency Pack => No
2013-08-21 10:47 dmiguelez Relationship added related to 0019009
2013-08-21 11:00 dmiguelez Relationship added related to 0024551
2013-08-21 11:02 hgbot Checkin
2013-08-21 11:02 hgbot Note Added: 0060700
2013-08-21 11:02 hgbot Status new => resolved
2013-08-21 11:02 hgbot Resolution open => fixed
2013-08-21 11:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6ca87037847e8b4323388162a6251149cc178e66 [^]
2013-08-21 11:59 vmromanos Review Assigned To => vmromanos
2013-08-21 11:59 vmromanos Note Added: 0060703
2013-08-21 11:59 vmromanos Status resolved => closed
2013-08-21 11:59 vmromanos Fixed in Version => 3.0MP27
2013-08-21 18:59 hudsonbot Checkin
2013-08-21 18:59 hudsonbot Note Added: 0060720

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker