Dear Experts,

While synchronising data b/w SQL Anywhere and HANA via RDSynch; we are getting an error:

2017-05-05 12:04:55.499 Server error: Message: ODBC: [SAP AG][LIBODBCHDB SO][HDBODBC] Base table or view not found;259 invalid table name: Could not find table/view HELLO in schema HELLO: line 1 col 19 (at pos 18) (ODBC State = 42S02, Native error code = 259). Table Name: HELLO

The script that we executed in HANA initially had the following code:

CALL SAP_HANA_SYNC.ml_add_table_script ( 'HELLO_V1', 'HELLO', 'upload_insert', 'INSERT INTO HELLO.HELLO (ID, READING) VALUES ({ml r.ID}, {ml r.READING})' )

But the table HELLO is created in schema CONN_PHARMA, so I changed the script to following and ran again:

CALL SAP_HANA_SYNC.ml_add_table_script ( 'HELLO_V1', 'HELLO', 'upload_insert', 'INSERT INTO CONN_PHARMA.HELLO (ID, READING) VALUES ({ml r.ID}, {ml r.READING})' )

But I still get the error. How to delete the previous script because it seems that the synchronisation is referring to the previous script only even now.