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.

asked 05 May '17, 02:41

suberta's gravatar image

suberta
100111117
accept rate: 0%

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.

(05 May '17, 03:44) Vlad
1

Scripts are by default cached for performance reasons. As a result, script changes generally require a restart of the RDSync server components.

(05 May '17, 08:44) Chris Keating
Replies hidden

It worked. Thanks!

(05 May '17, 09:11) suberta

hey, Chris :) my link tells this solution, he had to read it only.

(05 May '17, 12:15) Vlad
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×24

question asked: 05 May '17, 02:41

question was seen: 3,551 times

last updated: 05 May '17, 12:15