2324730 - Data_transfer transform causes wrong datastore to be used in optimized sql - Data Services | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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

Read more...

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

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