- Job using HANA source and targets fails with error:
DBS-070106: |Data flow <Data flow name> <ODBC driver> does not support function <cast>. Check your dataflow.
- A column mapping contains syntax where the cast() function is being applied twice to the same column.
- Attempting to display optimized SQL for the failing dataflow returns the same error
- The error does not occur if the option HANA_CALCVIEW_OPTIMIZER = FALSE is added to the [AL_Engine] section of dsconfig.txt
SAP Data Services 4.2 SP14 patch 0-2
SAP Data Services 4.2
BODS, data flow, optimization , KBA , EIM-DS-EXE , Job Execution , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.