SAP Knowledge Base Article - Preview

2023117 - Job upgraded to 4.x does not run without changing table grants - Data Services 4.x


  • Upgraded from Data Integrator 11.7
  • Datastores are on same database but different schemas
  • Optimized SQL is a single SQL statement after the upgrade
  • In old version the Optimized SQL was separate per datastore
  • ERROR: SQL submitted to Oracle Server resulted in error <ORA-00942: table or view does not exist>




SAP Data Services 4.x


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


BODS , KBA , EIM-DS-DES , User Interface/Designer , 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.