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. |
I don't know exactly what is happening on the server, but you can read the documentation at first (ml_add_table_script) and then update your question accordingly - what you did, what you have in the ml_script table.
That article says how to delete, how to verify that the scripts were changed, what should be done with the server to reflect the changes.
Scripts are by default cached for performance reasons. As a result, script changes generally require a restart of the RDSync server components.
It worked. Thanks!
hey, Chris :) my link tells this solution, he had to read it only.