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:  “Twitter.twitterdata::twitter_allsynonyms.START_REPLICATION”: line 3 col 0 (at pos 160):  (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