SAP Knowledge Base Article - Preview

1962380 - Teradata transaction load rolled back silently when executing Data Services job

Symptom

  • A Data Services dataflow set to load to 2 different Teradata tables, both are set to be include in Transaction with same Transaction Order, loads only one table.
  • The job completed successfully, with no warnings or errors.
  • Only 1 table was loaded, another was left empty, and ODBC trace showed a rollback.


Read more...

Environment

  • SAP Data Services 4.0
  • SAP Data Services 4.1
  • SAP Data Services 4.2

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2

Keywords

BODS, BODI, DS, DI, Edge, rolleback , 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 for Me (Login required).

Search for additional results

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