Symptom
- 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
Read more...
Environment
SAP Data Services 4.2 SP14 patch 0-2
Product
SAP Data Services 4.2
Keywords
BODS, data flow, optimization , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.