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?


asked 02 Mar '16, 23:46

jimboidaho_gplus's gravatar image

accept rate: 0%

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%20Barth's gravatar image

Volker Barth
accept rate: 32%

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
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 02 Mar '16, 23:46

question was seen: 238 times

last updated: 03 Mar '16, 10:12