2600151 - Error: Insufficient privilege for Streaming user - SAP HANA Streaming, SAP Event Stream Processor | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2600151 - Error: Insufficient privilege for Streaming user - SAP HANA Streaming, SAP Event Stream Processor

Symptom

  • For the Streaming project, there is an SAP HANA Output Adapter or SAP IQ Output Adapter or SAP Adaptive Server Enterprise (ASE) Output Adapter connected to a Keyed Stream or Window.
  • The connector status goes to DEAD at the very start of the project.
  • The project log file reports errors. For example, when using the SAP HANA Output Adapter:

[SP-3-150004] (0.421) sp(18757) Connection(<adapter>/<keyed-stream-or-window>):: SAP HANA Output adapter failed to prepare for bulk loading of target database table "<schema>.<table>".
 
[SP-3-150004] (0.421) sp(18757) Connection(<adapter>/<keyed-stream-or-window>):: ODBC status: HY000 SQL error code: 258 Error Message: "[SAP AG][LIBODBCHDB SO][HDBODBC] General error;258 insufficient privilege: Not authorized".
 
[SP-3-150004] (0.421) sp(18757) Connection(<adapter>/<keyed-stream-or-window>):: SAP HANA Output adapter cannot start because initialization of a ChildLoader component has failed.
...
 
[SP-3-150004] (0.479) sp(18757) Connection(<adapter>/<keyed-stream-or-window>):: SAP HANA Output adapter cannot start because initialization of the Loader component has failed.
 
[SP-3-148011] (0.479) sp(18757) ConnectionWriter(<adapter>) connection reset error: <date time> Adapter failed to start because initialization failed.

  • When activating trace, the log reports:

User <database-user> is missing privilege DELETE for TABLE <schema.table>
 
User <database-user> tried to execute 'DELETE FROM "<schema-name>"."<table-name>" WHERE "<primary-key-field"=?'

  • What is the reason for this, and can this be solved without giving delete permissions?

Read more...

Environment

  • SAP HANA Smart Data Streaming
  • SAP HANA Streaming Analytics
  • SAP Event Stream Processor

Product

SAP HANA 1.0 smart data streaming ; SAP HANA streaming analytics 2.0 ; SAP HANA, platform edition 2.0

Keywords

stream, processing, processor, sds, esp, HANA Output Adapter, IQ Output Adapter, Adaptive Server Enterprise (ASE) Output Adapter, insert update delete permission , KBA , HAN-SDS , SAP HANA Smart Data Streaming , 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.