Symptom
When login to backoffice and then go to any product -> STOCK -> FIND STOCK LEVELS FOR PRODUCT, customer is not able to see stock level with all the products like shown below:
There should be below error found in log :
ERROR [hybrisHTTP28] [FlexibleSearch] Flexible search error occurred...
de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - data exception: invalid character value for cast query = 'SELECT item_t0.PK FROM stocklevels item_t0 WHERE (( item_t0.p_productcode =? and ( item_t0.p_warehouse IS NOT NULL and item_t0.p_warehouse <>?))) AND (item_t0.TypePkString=? ) order by item_t0.PK DESC LIMIT ? OFFSET ?', values = [29532, , 8796119138386]
at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:535) ~[coreserver.jar:?]
at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:1) ~[coreserver.jar:?]
at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:82) ~[coreserver.jar:?]
Read more...
Environment
SAP Commerce Cloud 2011.14 and 2011.15
Product
Keywords
"Stock Level"; empty; , KBA , CEC-SCC-CDM-BO-APP , Applications , 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.