SAP Knowledge Base Article - Preview

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

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

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 for Me (Login required).

Search for additional results

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