Symptom
- 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>
Read more...
Environment
SAP Data Services 4.x
Product
SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2
Keywords
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.
SAP Knowledge Base Article - Preview