SAP Knowledge Base Article - Preview

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


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




SAP Data Services 4.2


SAP Data Services 4.2


DHR5050166279 , 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 ONE Support launchpad (Login required).

Search for additional results

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