Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011106 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 05. Production management | major | always | 2009-10-23 10:59 | 2009-11-20 20:37 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP9 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 681b124da42f | |||
| Projection | none | ETA | none | Target Version | 2.50MP9 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP5 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011106: It is possible to create two process plan with same identifier | |||||||
| Description | It is possible to create two process plan with same identifier and it should not. | |||||||
| Steps To Reproduce | Go 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0021670) shuehner (administrator) 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 (developer) 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 (viewer) 2009-11-13 11:53 |
Tested & working fine |
|
(0022071) shuehner (administrator) 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 (developer) 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 (viewer) 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 (viewer) 2009-11-20 20:37 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-23 10:59 | networkb | New Issue | |
| 2009-10-23 10:59 | networkb | Assigned To | => rafaroda |
| 2009-10-23 10:59 | networkb | OBNetwork customer | => Yes |
| 2009-10-23 11:42 | rafaroda | Priority | immediate => urgent |
| 2009-10-23 11:42 | rafaroda | Status | new => scheduled |
| 2009-11-10 06:13 | harikrishnan | Assigned To | rafaroda => harikrishnan |
| 2009-11-10 10:19 | shuehner | Assigned To | harikrishnan => pjuvara |
| 2009-11-10 10:20 | shuehner | Note Added: 0021670 | |
| 2009-11-12 13:19 | hgbot | Checkin | |
| 2009-11-12 13:19 | hgbot | Note Added: 0021771 | |
| 2009-11-12 13:19 | hgbot | Status | scheduled => resolved |
| 2009-11-12 13:19 | hgbot | Resolution | open => fixed |
| 2009-11-12 13:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9de9162100b676e7421cdd4d42210488f0d71a5f [^] |
| 2009-11-12 13:57 | shuehner | Relationship added | related to 0011335 |
| 2009-11-13 11:53 | arunkumar | Note Added: 0021808 | |
| 2009-11-13 11:53 | arunkumar | Status | resolved => closed |
| 2009-11-13 11:53 | arunkumar | Fixed in Version | => 2.50MP9 |
| 2009-11-14 00:00 | anonymous | sf_bug_id | 0 => 2897490 |
| 2009-11-20 16:59 | shuehner | Assigned To | pjuvara => harikrishnan |
| 2009-11-20 16:59 | shuehner | Note Added: 0022071 | |
| 2009-11-20 16:59 | shuehner | Status | closed => new |
| 2009-11-20 16:59 | shuehner | Resolution | fixed => open |
| 2009-11-20 16:59 | shuehner | Fixed in Version | 2.50MP9 => |
| 2009-11-20 17:18 | psarobe | Status | new => scheduled |
| 2009-11-20 17:18 | psarobe | fix_in_branch | => pi |
| 2009-11-20 18:57 | hgbot | Checkin | |
| 2009-11-20 18:57 | hgbot | Note Added: 0022078 | |
| 2009-11-20 18:57 | hgbot | Status | scheduled => resolved |
| 2009-11-20 18:57 | hgbot | Resolution | open => fixed |
| 2009-11-20 18:57 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/9de9162100b676e7421cdd4d42210488f0d71a5f [^] => http://code.openbravo.com/erp/devel/pi/rev/681b124da42f4e800f222ad2a26cb092e53f2c20 [^] |
| 2009-11-20 19:02 | rafaroda | Note Added: 0022080 | |
| 2009-11-20 20:37 | psarobe | Note Added: 0022082 | |
| 2009-11-20 20:37 | psarobe | Status | resolved => closed |
| 2009-11-20 20:37 | psarobe | Fixed in Version | => 2.50MP9 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |