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

• When using HCI Integration Query builder we are having an error which says "Can not fetch entity information." But the same job from browser works perfectly fine.
• Or an error like "Unable to fetch entity information for xxx specified in the existing query" may also be thrown.
• I am unable to fetch XYZ Entity using Query Modeler on HCI WebUI, getting this error while i click on "Finish" after selecting fields : "Can not fetch Entity Information".

SuccessFactors BizX

OData APIs

Hana Cloud Platform Integration

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.

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 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 , KBA , LOD-SF-INT-HCI , Standard SF to 3rd Party CPI (HCI) Content , LOD-SF-INT , Integrations , Problem