SAP Knowledge Base Article - Preview

3049987 - Job fails with error <ODBC driver> does not support function <cast>. Check your dataflow. - Data Services


  • 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 page

This 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.