Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028136 | Openbravo ERP | 02. Master data management | public | 2014-11-10 22:38 | 2015-02-04 20:34 |
|
| Reporter | jecharri | |
| Assigned To | fsoto82 | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR15Q2 | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | umartirena |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 32205 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028136: Error duplicate key value violates unique constraint "m_product_trl_product_langu_un" trying to create product variants |
| Description | Erro duplicate key value violates unique constraint "m_product_trl_product_langu_un" trying to create product variants |
| Steps To Reproduce | -Go to window client and check checkbox "Multilingual Document"
-Create a variant product characteristic like color with "red" value
-Go to window product
-Create a generic product and assign the created characteristic
-Verify that translation is automatically generated
-Press in "Generate Variants"
Verify that error
ERROR: duplicate key value violates unique constraint "m_product_trl_product_langu_un" Detail: Key (m_product_id, ad_language)=(3A62711A0668445F83BD63B1CD65076A, en_US) already exists.
is displayed |
| Proposed Solution | Check before generating a key. If exist, overwrite or skip. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0031866 | | closed | nonofrancisco | Cannot manage variants if Multilingual Documents selected at Client level because it is trying to create duplicated translation |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-11-10 22:38 | jecharri | New Issue | |
| 2014-11-10 22:38 | jecharri | Assigned To | => dmiguelez |
| 2014-11-10 22:38 | jecharri | OBNetwork customer | => Yes |
| 2014-11-10 22:38 | jecharri | Modules | => Core |
| 2014-11-10 22:38 | jecharri | Support ticket | => 32205 |
| 2014-11-10 22:38 | jecharri | Resolution time | => 1422054000 |
| 2014-11-10 22:38 | jecharri | Triggers an Emergency Pack | => No |
| 2014-12-01 13:40 | egoitz | Target Version | 3.0PR15Q1 => 3.0PR15Q2 |
| 2014-12-05 12:03 | maarten1962 | Note Added: 0072308 | |
| 2014-12-05 12:03 | maarten1962 | Summary | Erro duplicate key value violates unique constraint "m_product_trl_product_langu_un" trying to create product variants => Error duplicate key value violates unique constraint "m_product_trl_product_langu_un" trying to create product variants |
| 2014-12-05 12:03 | maarten1962 | Proposed Solution updated | |
| 2015-01-08 14:20 | fsoto82 | Status | new => scheduled |
| 2015-01-08 14:20 | fsoto82 | Assigned To | dmiguelez => fsoto82 |
| 2015-01-08 14:20 | fsoto82 | fix_in_branch | => pi |
| 2015-01-15 10:12 | hgbot | Checkin | |
| 2015-01-15 10:12 | hgbot | Note Added: 0073509 | |
| 2015-01-15 10:12 | hgbot | Status | scheduled => resolved |
| 2015-01-15 10:12 | hgbot | Resolution | open => fixed |
| 2015-01-15 10:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/caeee416813b4ad1a51ff0a6a7c3b9fca5127076 [^] |
| 2015-01-15 10:16 | hgbot | Checkin | |
| 2015-01-15 10:16 | hgbot | Note Added: 0073510 | |
| 2015-01-15 10:17 | umartirena | Review Assigned To | => umartirena |
| 2015-01-15 10:17 | umartirena | Note Added: 0073511 | |
| 2015-01-15 10:17 | umartirena | Status | resolved => closed |
| 2015-01-15 10:17 | umartirena | Fixed in Version | => pi |
| 2015-02-04 20:34 | hudsonbot | Checkin | |
| 2015-02-04 20:34 | hudsonbot | Note Added: 0074147 | |
| 2015-02-04 20:34 | hudsonbot | Checkin | |
| 2015-02-04 20:34 | hudsonbot | Note Added: 0074148 | |
| 2016-01-12 18:43 | ngarcia | Relationship added | related to 0026573 |
| 2016-01-12 18:43 | ngarcia | Relationship deleted | related to 0026573 |
| 2016-01-12 18:44 | ngarcia | Relationship added | related to 0031866 |
|
Notes |
|
|
|
|
I confirm this error in the training. As it appears, it was solved when I removed the translation that was (automatically) generated for the generic item. After that, the variants were created without problem. |
|
|
|
(0073509)
|
|
hgbot
|
|
2015-01-15 10:12
|
|
Repository: erp/devel/pi
Changeset: caeee416813b4ad1a51ff0a6a7c3b9fca5127076
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Fri Jan 09 09:08:39 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/caeee416813b4ad1a51ff0a6a7c3b9fca5127076 [^]
Fixed bug 28136: Error duplicate key value when create product variants
Modified class VariantAutomaticGenerationProcess to check if the Client has the flag "Multilingual Documents"
If checked then remove the translations list from the generic product clone.
---
M src/org/openbravo/materialmgmt/VariantAutomaticGenerationProcess.java
---
|
|
|
|
(0073510)
|
|
hgbot
|
|
2015-01-15 10:16
|
|
|
|
|
(0073511)
|
|
umartirena
|
|
2015-01-15 10:17
|
|
|
|
|
|
|
|
|
|
|