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
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.