SAP Knowledge Base Article - Preview

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


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... 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$3.execute( ~[coreserver.jar:?]

        at$3.execute( ~[coreserver.jar:?]

        at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView( ~[coreserver.jar:?]



SAP Commerce Cloud 2011.14 and 2011.15


SAP Commerce 2011


"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.