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
- While creating a model from an Oracle SQL Datasource
- Upon filtering on a DATE field
- Notice field members appear as TIMESTAMP datatype.
- Meaning: YYYY-MM-DD hh:mm:ss
- 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