3462698 - Data Preview on Successfactors Story Failed With Error: Failed to parse the expression: parsing failed

• Preview query on SuccessFactors Story reports fails with error below: 

"Text": "Internal error occurred while processing.",
"DetailedError": "Caught exception : exception 70002048: column store error: search table error:  [34023] Instantiation of calculation model failed;exception 306002: An internal error occurred\n\n"

or

"Text": "Internal error occurred while processing.",
            "DetailedError": "Caught exception : exception 42111: SQL Error : search table error:  [34023] Instantiation of calculation model failed;exception 306002: An internal error occurred\n\n" 

• In indexserver trace, you observe the error below:

 ceNodeInstantiate.cpp(02669) : Failed to convert SQL expression "xxx='abc's def'" to column store expression at node "xxx". Reason: Failed to parse the expression: parsing failed
-> xxx='abc's def'
->                      ^
; Condition 'isConverted' failed.

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

• SAP HANA Platform Edition 1.0
• SAP HANA Platform Edition 2.0
• HANA Cloud 
• SAP SuccessFactors HCM Suite

 [34023] Instantiation of calculation model failed, exception 306002, An internal error occurred\n\n, Failed to convert SQL expression, to column store expression at node, Reason: Failed to parse the expression: parsing failed, Condition 'isConverted' failed , KBA , HAN-DB-ENG , SAP HANA DB Engines , LOD-SF-ANA-SAC , Stories in People Analytics , Problem