3667546 - SyntaxError: Unexpected non-whitespace character after JSON when executing a FlexibleSearch query using the LEFT() function

Symptom

When executing a FlexibleSearch query that uses the LEFT() function, an error occurs.

Example Query:

SELECT {e.location} AS location,
{item1.name} AS name1,
{item2.name} AS name2
FROM {ItemType1 as e
LEFT JOIN MyItemType AS item1 ON LEFT({e.location},4) = {item1.code}
LEFT JOIN MyItemType AS item2 ON LEFT({e.location},6) = {item2.code}}
WHERE {locationdesc} = '********'

Error Message:

See SyntaxError: Unexpected non-whitespace character after JSON at position 39626 (line 1 column 39627)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Commerce
SAP Commerce Cloud

Product

SAP Commerce Cloud all versions ; SAP Commerce all versions

Keywords

unexpected non-whitespace character, left, substring, flexiblesearch syntax, query error, function not supported, string function, sql function, flexiblesearch query , 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.