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

Search for additional results

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