2635858 - Facing "can not fetch entity information" error while using CPI Integration Query builder (Query Modeler)

When using CPI Integration Query builder / Quer Modeler on CPI WebUI, you observe errors such as:

• "Can not fetch entity information" or "Unable to fetch entity information for xxx specified in the existing query".
• The same job from browser works.
• The error is thrown after clicking on "Finish" after selecting the fields.

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

• SAP SuccessFactors HCM Suite
• SAP SuccessFactors OData APIs
• SAP CPI

The Cause of the issue is presence special character (-) dash or (.) dot in the metadata file being used for query creation.

According to OData V2 specification for QualifiedName: only following pattern is allowed for valid names:
"[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}"

Hence “-“ (dash) is not allowed in the name. Please also watch for spaces, as they also count as invalid character in this scenario.

edmx contains property 'date-of-birth' in entity XYZ which is causing the olingo parsing of the OData Metadata to fail in CPI.

eg : date-of-birth field (dash) or

Similarly a dot character can also cause the same issue e.g. "Product_Qty." NVARCHAR(10)

1. Check the metadata or EDMX file that you are using to perform your query.
2. Check if there is a field name that includes "-", "dash" in it, or spaces which also count as special character (or any special character which is not allowed by Odata specification). 

OData V2 specification available from OData Version 2.0

can not fetch entity information, Job Application entity can not be used by HCI query modeler, OData Adapter, OData, API, adapter, CPI, job application, jobapplication , KBA , LOD-SF-INT-CPI , Standard SF to 3rd Party CPI (HCI) Content , LOD-SF-INT , Integrations , Problem