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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031866
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2016-01-12 18:432016-03-17 10:55
ReporterngarciaView Statuspublic 
Assigned Tononofrancisco 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionb6f6e3509b63
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket39949
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031866: Cannot manage variants if Multilingual Documents selected at Client level because it is trying to create duplicated translation

DescriptionCannot manage variants if Multilingual Documents selected at Client level because it is trying to create duplicated translation. The ManageVariants process copies the product with the DalUtil.copy function and the m_product_trg trigger tries to insert a new record in the m_product_trl table
Steps To ReproduceAs system admin role:
   Check at least one language is Active and set as System Language
As group admin role:
   Go to Client window and select the Multilingual Documents window
   Create a Product Characteristic, set it as Variant and add a Value to it
   Create a Product, set it as Generic and add the previously created Characteristic
   Click on Manage Variants button, select one record and OK
   Check the following error message is shown:
      There is already a Product Translation with the same (Language, Product). (Language, Product) must be unique. You must change the values entered.

   The log shows:
      ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "m_product_trl_product_langu_un"
  Detail: Key (m_product_id, ad_language)=(B5EB4CEAC81748C69CAF5E661FDC7D4E, en_US) already exists.
      ERROR org.openbravo.materialmgmt.actionhandler.ManageVariants - Error in Manage Variants Action Handler
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00281363.0PR15Q2 closedfsoto82 Error duplicate key value violates unique constraint "m_product_trl_product_langu_un" trying to create product variants 

-  Notes
(0083572)
nonofrancisco (viewer)
2016-01-22 21:44

 Test Plan

As Openbravo / System Administrator

In Language window check at least one language is Active and set as System Language

As Openbravo / F&B International Group Admin

In Client window
  Multilingual Documents: checked
  
In Product Characteristics window
  Create a new Record
    Variant: checked
    Active: checked
    Save the record
    In Value tab
      Create two records
        Active: checked
      
In Product window
  Create a new record
    is Generic: checked
    Save the record
    In Characteristics tab
      Add a new record
        Characteristics: the one previously created
        Save the record

Click on Manage Variants button
Select one of the variants
Click Done button

A success message is shown

In Client window
  Multilingual Documents: not checked

In Product window
  Select the generic product previously created

Click on Manage Variants button
Select the variant with "Variant Created" field set to No
Click Done button

A success message is shown

Review the definition of the new crated products and realize all values are correct
(0083758)
hgbot (developer)
2016-01-31 12:53

 Repository: erp/devel/pi
Changeset: 5af9f355ad36eff792c928ec5cd55f09fa1fbd7c
Author: Nono <f.carballo <at> nectus.com>
Date: Thu Jan 21 15:36:07 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/5af9f355ad36eff792c928ec5cd55f09fa1fbd7c [^]

Fixes Issue 31866: Emptied Translation List after copying generic product

If Multilingual Document is checked in Client window, when managing variants,
after copying the generic product, the translation list is emptied, the
m_product_trg trigger will insert the proper values when inserting
the new product.

---
M src/org/openbravo/materialmgmt/actionhandler/ManageVariants.java
---
(0083759)
hgbot (developer)
2016-01-31 12:53

 Repository: erp/devel/pi
Changeset: b6f6e3509b632b71b1bd4398a02ae12f03cc6d0b
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Sun Jan 31 12:49:38 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b6f6e3509b632b71b1bd4398a02ae12f03cc6d0b [^]

Fixed bug 31866: code review improvements

Applied Openbravo format style
Updated copyright

---
M src/org/openbravo/materialmgmt/actionhandler/ManageVariants.java
---
(0083760)
vmromanos (viewer)
2016-01-31 12:53

 Code review + testing OK
(0085097)
hudsonbot (viewer)
2016-03-17 10:55

 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/b22fb0500156 [^]
Maturity status: Test
(0085098)
hudsonbot (viewer)
2016-03-17 10:55

 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/b22fb0500156 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-01-12 18:43 ngarcia New Issue
2016-01-12 18:43 ngarcia Assigned To => Triage Finance
2016-01-12 18:43 ngarcia OBNetwork customer => Yes
2016-01-12 18:43 ngarcia Modules => Core
2016-01-12 18:43 ngarcia Support ticket => 39949
2016-01-12 18:43 ngarcia Resolution time => 1455318000
2016-01-12 18:43 ngarcia Triggers an Emergency Pack => No
2016-01-12 18:44 ngarcia Relationship added related to 0028136
2016-01-12 18:44 ngarcia Issue Monitored: networkb
2016-01-22 21:43 nonofrancisco Assigned To Triage Finance => nonofrancisco
2016-01-22 21:44 nonofrancisco Status new => scheduled
2016-01-22 21:44 nonofrancisco Note Added: 0083572
2016-01-31 12:53 hgbot Checkin
2016-01-31 12:53 hgbot Note Added: 0083758
2016-01-31 12:53 hgbot Status scheduled => resolved
2016-01-31 12:53 hgbot Resolution open => fixed
2016-01-31 12:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5af9f355ad36eff792c928ec5cd55f09fa1fbd7c [^]
2016-01-31 12:53 hgbot Checkin
2016-01-31 12:53 hgbot Note Added: 0083759
2016-01-31 12:53 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/5af9f355ad36eff792c928ec5cd55f09fa1fbd7c [^] => http://code.openbravo.com/erp/devel/pi/rev/b6f6e3509b632b71b1bd4398a02ae12f03cc6d0b [^]
2016-01-31 12:53 vmromanos Review Assigned To => vmromanos
2016-01-31 12:53 vmromanos Note Added: 0083760
2016-01-31 12:53 vmromanos Status resolved => closed
2016-03-17 10:55 hudsonbot Checkin
2016-03-17 10:55 hudsonbot Note Added: 0085097
2016-03-17 10:55 hudsonbot Checkin
2016-03-17 10:55 hudsonbot Note Added: 0085098

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker