SAP Knowledge Base Article - Public

3396572 - DATE fields from Oracle SQL connection may appear as TIMESTAMP field in SAP Analytics Cloud (SAC)

Symptom

  • Can not import DATE field from Oracle SQL when creating a model.
  • Date Oracle SQL data type is being imported as a TIMESTAMP type within SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2023.16

Reproducing the Issue

  1. While creating a model from an Oracle SQL Datasource
  2. Upon filtering on a DATE field
  3. Notice field members appear as TIMESTAMP datatype.
    • Meaning: YYYY-MM-DD hh:mm:ss
  4. Creating a model will then result in error, "An internal server error occurred in the Data Acquisition Service..."

Cause

  • This issue is being investigated by development.

Resolution

  • This issue is being investigated by development.

Keywords

Oracle SAC acquired model create timestamp date internal server error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0