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.