SAP Knowledge Base Article - Public

3602224 - Error "An error occurred while getting the query results: An exception of type 'EdmSimpleTypeException' occurred. " when importing data from S/4HANA Cloud

Symptom

  • Error "An error occurred while getting the query results: An exception of type 'EdmSimpleTypeException' occurred. " when importing data from S/4 HANA Cloud

Environment

  • SAP Analytics Cloud Enterprise
  • S/4HANA Cloud import connection

Reproducing the Issue

  1. Create a model or an import job against S/4 HANA Cloud Odata query, eg: YY1_MaintOrderOP_API_V1
  2. Error when run the query.

Cause

Some time items are having invalid values, eg: 24:00:00, while the expected value range is from 00:00:00 to 23:59:59

Resolution

  • Correct the values from S/4HANA Cloud side.
  • Or do not include such items in SAC query.

See Also

https://www.odata.org/documentation/odata-version-2-0/overview/

Keywords

YY1_MaintOrderOP_API_V1, S4 HANA, S4HC, S/4 HANA , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud all versions