topic Re: $sync after exit script in QlikView

$sync after exit script

Michiel_QV_Fan — Mon, 31 Mar 2014 14:07:58 GMT

I get a $sync error after my script is finished. I have hard coded the 'exit script' but the log files shows the $sync error after that, as does the script progress window.

Any ideas why this happens?

And what could be the solution?

Re: $sync after exit script

Mon, 31 Mar 2014 14:18:47 GMT

There must be some synthetic keys occuring in your script.

$Sync error won't come because of Exit Script.

Check for the Synthetic keys.

Re: $sync after exit script

jonathandienst — Mon, 31 Mar 2014 14:28:35 GMT

You are likely seeing an out of memory condition while constructing the synthetic keys.

To check this, open the edit script window, and click Debug. Then click on Limited Load and select a number (say 100) and click run to execute the script. After it has completed (you might get a data loop error), check the data model by clicking Ctrl-T. Now you should be able to see the synthetic keys that QV is constructing.

HTH

Jonathan

Re: $sync after exit script

Bill_Britt — Mon, 31 Mar 2014 14:47:01 GMT

Hi,

Look at this Blog. It is a great article on synthetic Keys.

Bill