Skip to Content
0
Former Member
Nov 13, 2018 at 11:45 PM

way on changing an enum type product tier to a collection type

83 Views

Hello,

i have been working with product tiers. The way it was, each product could have only one tier, but now we want it to each product could be in one or more than one tier. This tier attribute was an enum type so i changed it to a collection type. In the backoffice is ok, i can add more than one tier to each product. The problem comes when i enter to the store, i can't see the products, none of them, and when i try to search them i get an error like this:

HTTP Status 500 - Request processing failed; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - data exception: invalid character value for cast query = 'SELECT item_t0.PK FROM products item_t0 WHERE ( item_t0.p_code =?) AND (item_t0.TypePkString IN (?,?,?,?,?,?) AND ((( item_t0.p_onlinedate IS NULL OR item_t0.p_onlinedate <= ?) AND ( item_t0.p_offlinedate IS NULL OR item_t0.p_offlinedate >= ?)) AND ((((SELECT item_t1.Code FROM enumerationvalues item_t1 WHERE ( item_t1.PK = item_t0.p_productclass ) AND (item_t1.TypePkString=? )) = 'EDUCATIONAL' AND (SELECT item_t2.Code FROM enumerationvalues item_t2 WHERE ( item_t2.PK = item_t0.p_tier ) AND (item_t2.TypePkString=? )) = ?) OR ((SELECT item_t3.Code FROM enumerationvalues item_t3 WHERE ( item_t3.PK = item_t0.p_productclass ) AND (item_t3.TypePkString=? )) = 'ENTERPRISE' AND (SELECT item_t4.Code FROM enumerationvalues item_t4 WHERE ( item_t4.PK = item_t0.p_tier ) AND (item_t4.TypePkString=? )) = ?))) AND ( item_t0.p_catalogversion IN (?,?,?)) AND ( item_t0.p_approvalstatus = 8796101378139 ) AND ((( item_t0.p_b2c = '1' AND ? = '1') OR ? <> '1'))) )', values = [1027125, 8796103606354, 8796103442514, 8796103508050, 8796103475282, 8796103540818, 8796099444818, Tue Nov 13 00:00:00 MST 2018, Tue Nov 13 00:00:00 MST 2018, 8796103344210, 8796103376978, , 8796103344210, 8796103376978, SILVER, PropertyValue:8796093153881, PropertyValue:8796093317721, PropertyValue:8796093186649, false, false]

I'm pretty new to hybris, so it would be great if anyone could help me out in this. it is hybris 6.6 btw

Thank you