2072887 - Optimized SQL is incorrect after upgrading job from 3.2 to 4.2 - Data Services 4.2 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2072887 - Optimized SQL is incorrect after upgrading job from 3.2 to 4.2 - Data Services 4.2

Symptom

  • Upgraded from 3.2 to 4.2
  • Optimized SQL differs between 3.2 and 4.2
  • Inner join shown in optimized SQL for 4.2 job does not actually execute on the database at runtime resulting in the job never completing
  • Optimized SQl results in full table scans on the source tables
  • In 4.2 SQL the optimized SQL is only shown for the target datastore whereas on 3.2 there is different optimized SQL for both the source and target datastores.
  • The optimized SQL for 4.2 differs from what is actually run on the database at runtime.

 


Read more...

Environment

SAP Data Services 4.2

Product

SAP Data Services 4.2

Keywords

DHR5050166279 , KBA , EIM-DS-EXE , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

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