SAP Knowledge Base Article - Preview

2324730 - Data_transfer transform causes wrong datastore to be used in optimized sql - Data Services


  • Job with multiple data transfer transforms tries to push down a table to a datastore that it cannot create tables to.
  • Data_Transfer transform creating objects in a datastore that is not used in the job.
  • Error: "Loader <objectname>_1_DT__4507_833_1_2 ODBC data source <incorrect datastore> error message for operation <SQLPrepare>: <[Teradata][ODBC Teradata Driver][Teradata Database] Object '<schema>.DT__4507_833_1_2' does not exist. >."
  • Check optimized sql and a datastore that is not used within the job is used for the data_transfer.



SAP Data Services


SAP Data Services all versions


DS, dsxi, DT , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.