SAP Knowledge Base Article - Preview

2048182 - Pushdown to HANA is resulting in errors - Data Services 4.2 SP1

Symptom

***INTERNAL USE ONLY***

  • Errors when using HANA target
  • Upgraded to version 4.2 SP1 or later
  • Optimized SQL is creating stored procedure
  • Errors concerning lack of permissions to create temp tables and views on HANA
  • ERROR: SQL submitted to ODBC data source <datastore> resulted in error <[SAPAG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Not authorized>. The SQL submitted is <CREATE TYPE "schema"."DS_TT_xxxx" AS TABLE


Read more...

Environment

SAP Data Services 4.2 SP1 or later

Product

SAP Data Services 4.2

Keywords

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.