no download_cursor scripts error version 11 to 17 problem

My version 11 db has some tables that I only want to sync from the remote to the consolidated. I left the download_curosr and delete script off for that reason. Now version 17 errors out.
E. 2016-03-02 21:38:25. <1> [-10366] The table 'Ml_logs' has no download_cursor script I know I could add the scripts using where 1=2 but it seems like I should be able to run that way. Is there a setting I am missing?

Thanks.

mobilink

asked 02 Mar '16, 23:46

jimboidaho_g...
146●9●9●16
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

Even 11.0.1 has introduced a facility to tell the ML server that particular scripts are missing by design, see the Ignored scripts feature or alternatively (less recommended) the -zwd mlsrv17 option to prevent that error message.

permanent link

answered 03 Mar '16, 04:12

Volker Barth
40.2k●361●550●822
accept rate: 34%

edited 03 Mar '16, 04:12

--{ml_ignore} worked. The main difference with 17 is I was getting an error not a warning for the missing scripts. Thanks for your help.

(03 Mar '16, 09:46) jimboidaho_g...

Replies hidden

--{ml_ignore} is the right way to do it.

We changed the message to an error as opposed to a warning in v12 because of a surprising number of issues from customers about missing data in their system that was caused by missing scripts. The warnings were in the logs, but were being ignored.

(03 Mar '16, 10:12) Reg Domaratzki

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

mobilink ×371

question asked: 02 Mar '16, 23:46

question was seen: 1,371 times

last updated: 03 Mar '16, 10:12

SAP SQL Anywhere

no download_cursor scripts error version 11 to 17 problem

Follow this question

Related questions