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 , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.