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.
SAP Knowledge Base Article - Preview