SAP Knowledge Base Article - Preview

3137070 - 'Stock Level' showing empty from Products in Backoffice after upgrading to 2011.14 and 2011.15

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

SAP Commerce 2011

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.