SAP Knowledge Base Article - Preview

2122644 - Data Services does not create Hana stored procedures at runtime in default user schema when join has tables in multiple schemas.

Symptom

Data Services creates a stored procedure during job execution to fetch data from Hana. When tables from multiple schemas are joined in the dataflow query, the stored procedure is created in the schema that 1st column in the 1st table is mapped to in the query and not the default schema of the Hana Data store user.


Read more...

Environment

  • SAP Data Services 4.2
  • Hana 1.0.xx

Product

SAP Data Services 4.2

Keywords

hana, ds, HANA_CALCVIEW_OPTIMIZER, schema, access, rights, optimized SQL , KBA , EIM-DS , Data Services , 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 for Me (Login required).

Search for additional results

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