The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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.

asked 02 Mar '16, 23:46

jimboidaho_gplus's gravatar image

jimboidaho_g...
1464916
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
30.9k309457668
accept rate: 33%

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
1

--{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

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:

×295

question asked: 02 Mar '16, 23:46

question was seen: 250 times

last updated: 03 Mar '16, 10:12