Dear Experts,
We are facing an error at creation of product variant "Cannot create a record in products(EcoResProduct). The Record already exist".
Suppose:
This is already available variant
Configuration
Size
Color
Style
LAB TEST REPORT (METAL/FERROUS)
8.5" X 11"
(WHITE,YELLOW)
DUPLICATE PAPER 50
and we want this new variant just style changes
DUPLICATE PAPER 50 , IMPORTED PAPER 70 GRM
This is image of error:
In EcoResProduct table DisplayProductNumberIdx is unique index which contain only DisplayProductNumber field. Check the DisplayProductNumber of new product variant and existing product variant.
Well Done Team,
Issue Resolved,
Issue was that "EcoResProduct" table EDT length was 70. When we were creating same variants below 70 characters error was occurring. We have increase characters length up to 200 then issue resolved.
Table Image:
Business Applications communities