SAP Knowledge Base Article - Preview

1573983 - A job with "count_distinct" function using an Oracle datastore generates an incorrect SQL statement "distinctto_date" - DI XI R2


  • Optimized SQL contains "distinctto_date" (instead of "distinct to_date").
  • Executing a job containing this function produces the following error message :
    |Dataflow <DataFlowName> |Reader Agreg: SQL submitted to Oracle Server <OracleServer> resulted in error <ORA-00942: table or view does not exist >. The SQL submitted is ...



  • Data Integrator XI R2 ver. 11.7.x
  • Oracle datastore
  • Any supported OS


SAP Data Integrator XI R2


KBA , EIM-DI , Data Integrator, Composer , 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.