/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
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=? )', |
Read more...
Environment
SAP Commerce Cloud
Product
SAP Commerce Cloud all versions
Keywords
ccv2, hybris, db, flexiblesearch, query, select, hac, mysql , KBA , CEC-SCC-PLA-PL , Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)