0015295: Check «m_product_atsetvaltype_chk» violated when trying to generate/update products

Description

Check «m_product_atsetvaltype_chk» violated when trying to generate/update products.

Steps To Reproduce

1. Create values for "Division", "Collection"and "Subcollection"
2. Go to Master Data Management || Product Setup || Attribute || Attribute:
set "Size" attribute as isSize=Y
set "Color" attribute as isColor=Y
3. General Setup || Enterprise || Enterprise module management || Enterprise module management: apply apparel dataset
4. Master Data Management || Product Technical Specification || Product : create new product and press "Generate/update products"
5. Press "Propose EAN" in the popup and then press "Generate/update products"
Error "org.hibernate.exception.GenericJDBCException: could not execute query" is obtained.

Having a look at the log you see:
[http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into M_Product (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, UPC, C_UOM_ID, IsSummary, IsStocked, IsPurchased, IsSold, IsBOM, IsInvoicePrintDetails, IsPickListPrintDetails, IsVerified, M_Product_Category_ID, C_TaxCategory_ID, Discontinued, Processing, ProductType, ImageURL, M_AttributeSet_ID, M_AttributeSetInstance_ID, Ispriceprinted, Costtype, Enforce_Attribute, Calculated, Production, Qtytype, EM_Apparel_Prod_Tech_Spec_ID, M_Product_ID) values (1000000, 0, Y, 2010-11-24 18:52:42.400000 +0100, 100, 2010-11-24 18:52:42.400000 +0100, 100, ppinkL, p - Large - Pink, 1234567800011, 100, N, Y, Y, Y, N, N, N, N, 1000000, 1000000, N, N, I, 800011, FF8081812C797F3F012C798A9F6C005D, FF8081812C7E8205012C7F04138D0116, N, ST, N, N, N, N, 68331524A98B4E77941C04C2F361BDAE, FF8081812C7E8205012C7F0413A00119) was aborted. Call getNextException to see the cause.
a3196480 18:52:42 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: el nuevo registro para la relación «m_product» viola la restricción check «m_product_atsetvaltype_chk»

Issue History
Date Modified	Username	Field	Change
2010-11-25 17:57	maite	New Issue
2010-11-25 17:57	maite	Assigned To	=> alostale
2020-04-13 08:58	alostale	Note Added: 0119123
2020-04-13 08:58	alostale	Status	new => closed
2020-04-13 08:58	alostale	Resolution	open => out of date
2022-02-18 04:26	priyam	Category	Apparel Products => zz obsolete Apparel Products

Notes
(0119123) alostale (manager) 2020-04-13 08:58	Won't fix: retired module

Relationships [ Relation Graph ] [ Dependency Graph ]