Symptom
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
You wish to pull data from the SAP SuccessFactors adapter in CPI, however when trying to generate the XML schema the following error occurs: "Failed to save query Unable to generate XSD file"
Environment
SAP SuccessFactors HCM suite
SAP CPI
BTP Cloud Integration Administration Logistics
Cause
Wrong configuration. The SuccessFactors adapter in CPI cannot handle special characters such as hyphens or spaces. When the SuccessFactors metadata contains hyphens, the olingo parser will fail when trying to generate the XML schema.
Example from Metadata file:
<Property Name="Travel Expenses Group" Type="Edm.String" Nullable="true" sap:required="false" sap:creatable="true" sap:updatable="true" sap:upsertable="true" sap:visible="true" sap:sortable="true" sap:filterable="true" MaxLength="128" sap:label="externalName"></Property>
Resolution
Correct the metadata by removing all the special characters (e.g. hyphens) or spacing in the SuccessFactors metadata
See Also
2527971 - CPI Artifact - ERP to Employee Central Cost Center - error message = OData metadata content available in the server is outdated or the request payload seems to be incorrect
2433234 - Error in HCI message monitor for Successfactors OData API calls: "XML is malformed"
2629015 - Connection to SuccessFactors OData Fails
Keywords
CPI, BTP Cloud Integration Administration Logistics, adapter, SuccessFactors adapter, SFSF, Failed to save query Unable to generate XSD file, metadata, hyphen, special character , KBA , LOD-SF-INT-CPI , Standard SF to 3rd Party CPI (HCI) Content , LOD-SF-INT , Integrations , LOD-SF-INT-CPI-TPI , Standard SF to 3rd Party Integration using CPI , How To
Product
Attachments
image.png |