Project:
View Revisions: Issue #44108 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0044108: In Discounts and Promotions window, unclear error shown when trying to upload products from a file if they are duplicated | ||
Revision | 2020-05-19 16:42 by ngarcia | ||
Steps To Reproduce | As group admin role: Go to Discounts and promotions window Create a header and add a name and a starting date Go to Products tab Click on the toolbar button "Upload a file to import products into the discount" Choose the attached file Import Mode: Import and Add Import Error Handling: Stop on Error Check the following error is shown org.hibernate.exception.ConstraintViolationException: could not execute batch The log shows: ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch - HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 1 insert into M_Offer_Product (...) was aborted: ERROR: duplicate key value violates unique constraint "m_offer_product_unique" Detail: Key (m_product_id, m_offer_id)=(..., ...) already exists After that, the button keeps loading and it is not active until the window is opened again |
||
Revision | 2020-05-19 16:41 by ngarcia | ||
Steps To Reproduce | As group admin role: Go to Discounts and promotions window Create a header and add a name and a starting date Go to Products tab Click on the toolbar button "Upload a file to import products into the discount" Choose the attached file Import Mode: Import and Add Import Error Handling: Stop on Error Check the following error is shown org.hibernate.exception.ConstraintViolationException: could not execute batch The log shows: ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch - HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 1 insert into M_Offer_Product (...) was aborted: ERROR: duplicate key value violates unique constraint "m_offer_product_unique" Detail: Key (m_product_id, m_offer_id)=(..., ...) already exists |
Copyright © 2000 - 2009 MantisBT Group |