Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011106Openbravo ERP05. Production managementpublic2009-10-23 10:592009-11-20 20:37
Reporternetworkb 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP5 
Target Version2.50MP9Fixed in Version2.50MP9 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011106: It is possible to create two process plan with same identifier
DescriptionIt is possible to create two process plan with same identifier and it should not.
Steps To ReproduceGo to Production Management > Transactions > Production plan.
Create a new one. Save it.
Create other one and set as "Search Key" the same as the previous one. Save it.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0011335 closed harikrishnan api check build 204 fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-23 10:59networkbNew Issue
2009-10-23 10:59networkbAssigned To => rafaroda
2009-10-23 10:59networkbOBNetwork customer => Yes
2009-10-23 11:42rafarodaPriorityimmediate => urgent
2009-10-23 11:42rafarodaStatusnew => scheduled
2009-11-10 06:13harikrishnanAssigned Torafaroda => harikrishnan
2009-11-10 10:19shuehnerAssigned Toharikrishnan => pjuvara
2009-11-10 10:20shuehnerNote Added: 0021670
2009-11-12 13:19hgbotCheckin
2009-11-12 13:19hgbotNote Added: 0021771
2009-11-12 13:19hgbotStatusscheduled => resolved
2009-11-12 13:19hgbotResolutionopen => fixed
2009-11-12 13:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9de9162100b676e7421cdd4d42210488f0d71a5f [^]
2009-11-12 13:57shuehnerRelationship addedrelated to 0011335
2009-11-13 11:53arunkumarNote Added: 0021808
2009-11-13 11:53arunkumarStatusresolved => closed
2009-11-13 11:53arunkumarFixed in Version => 2.50MP9
2009-11-14 00:00anonymoussf_bug_id0 => 2897490
2009-11-20 16:59shuehnerAssigned Topjuvara => harikrishnan
2009-11-20 16:59shuehnerNote Added: 0022071
2009-11-20 16:59shuehnerStatusclosed => new
2009-11-20 16:59shuehnerResolutionfixed => open
2009-11-20 16:59shuehnerFixed in Version2.50MP9 =>
2009-11-20 17:18psarobeStatusnew => scheduled
2009-11-20 17:18psarobefix_in_branch => pi
2009-11-20 18:57hgbotCheckin
2009-11-20 18:57hgbotNote Added: 0022078
2009-11-20 18:57hgbotStatusscheduled => resolved
2009-11-20 18:57hgbotResolutionopen => fixed
2009-11-20 18:57hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9de9162100b676e7421cdd4d42210488f0d71a5f [^] => http://code.openbravo.com/erp/devel/pi/rev/681b124da42f4e800f222ad2a26cb092e53f2c20 [^]
2009-11-20 19:02rafarodaNote Added: 0022080
2009-11-20 20:37psarobeNote Added: 0022082
2009-11-20 20:37psarobeStatusresolved => closed
2009-11-20 20:37psarobeFixed in Version => 2.50MP9

Notes
(0021670)
shuehner   
2009-11-10 10:20   
The table used for this window (ma_processplan) does not have a unique constraint for its value field (in the ui: search key). Adding this would be an api change and needs a solution for upgrades of existing instances having duplicates in this field.
(0021771)
hgbot   
2009-11-12 13:19   
Repository: erp/devel/pi
Changeset: 9de9162100b676e7421cdd4d42210488f0d71a5f
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Nov 12 17:47:48 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9de9162100b676e7421cdd4d42210488f0d71a5f [^]

Fixes Issue 11106: It is possible to create two process plan with same identifier.

---
M src-db/database/model/tables/MA_PROCESSPLAN.xml
---
(0021808)
arunkumar   
2009-11-13 11:53   
Tested & working fine
(0022071)
shuehner   
2009-11-20 16:59   
Re-Opening as wrongly the attached api check 11335 was reopened, with the following note attached.


Hi,

After talking with Paolo the solution is not correct. The unique key constraint is not correct. It has to be

AD_ORG_ID, VALUE

Please change it

Thanks
(0022078)
hgbot   
2009-11-20 18:57   
Repository: erp/devel/pi
Changeset: 681b124da42f4e800f222ad2a26cb092e53f2c20
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Nov 20 03:33:05 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/681b124da42f4e800f222ad2a26cb092e53f2c20 [^]

Fixes issue 11106 Unique constraint changed to Org and Value

---
M src-db/database/model/tables/MA_PROCESSPLAN.xml
---
(0022080)
rafaroda   
2009-11-20 19:02   
Test this issue by creating 2 Process Plan with the same search key in the same organization: error message should display.
(0022082)
psarobe   
2009-11-20 20:37   
Tested working fine