3291369 - Database throwing SQL error - SAP Commerce Cloud

You are running a SQL query and the system throws an error:

de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more

After you enable the property above, something like this is thrown:

SQL search error - Conversion failed when converting the nvarchar value 'NNNNN ' to data type int. query = 'SELECT ... FROM ... item_t0 WHERE ( item_t0.xxx = ? AND CAST( item_t0.xxx AS INT) <= ? AND CAST( item_t0.xxx AS INT) >= ?) AND (item_t0.TypePkString=? )',

SAP Commerce Cloud in the Public Cloud

KBA , CEC-SCC-PLA-PL , Platform , CEC-COM-CPS-COR , SAP Commerce Core , Problem