Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers