Skip to Content
0

SAP HANA - Smart Data Integration (Twitter) - Error while running procedures

Feb 06, 2017 at 05:56 AM

79

avatar image
Former Member

Currently I am trying to perform a twitter analysis with SAP Hana. I want to load twitter data using the twitter api. I already configured the Twitter adapter for the SAP HANA system (I configurated a remote source for the Twitter adapter). I also created a *.hdbreptask file which in turn creates the procedure.

First time I called the procedure, everything worked fine. Twitter data was loaded into the table.

Here the problem begins. If I want to run the procedure a second time, I got an error message:

Blockquote (SQL Editor) Could not execute 'CALL "Twitter.twitterdata::twitter_allsynonyms.START_REPLICATION"()' Error: (dberror) 129 - transaction rolled back by an internal error: [129] "Twitter.twitterdata::twitter_allsynonyms.START_REPLICATION": line 3 col 0 (at pos 160): [129] (range 3): transaction rolled back by an internal error: sql processing error: QUEUE: Twitter.twitterdata::twitter_allsynonyms.SUB_VTStatus: Cannot perform Queue on remote subscription Twitter.twitterdata::twitter_allsynonyms.SUB_VTStatus. It is not in created state. Reset state using ALTER RESET to perform Queue. : line 1 col 1 (at pos 0)

Unfortunately, I do not understand this error message. How do I run the procedure a second time, so that I can add new data?

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers