topic Periodic - Error in Hidden Script in QlikView

Periodic - Error in Hidden Script

Wed, 30 Sep 2009 21:42:32 GMT

Any help or pointers with this would be appreciated!

My Load script runs fine 90% of the time but the other 10% I get the following :

Error in hidden script. For details, open hidden script before reload.

For security reasons, failed hidden script code is not shown.

All data processes continue loading correctly and works, and will continue to relaod without error, however if an error occurs or I exit and reload the qvw, the file is corupted.This has been a pain and recovering the script from logs is time consuming.

I'd post the hidden script but its part of a commercial product, so I'm not sure i can and other users don't appear to have the problem. I've only made minor changes to the connection string.

Thanks

Periodic - Error in Hidden Script

biester — Thu, 01 Oct 2009 00:02:49 GMT

It's of course reasonable to not disclose details in your case, but they might be important for troubleshooting, so I'd personally contact QlikTech support or a QlikTech partner. You could of course try to bring down the thing to an abstract level, but who knows that you don't omit just the jumping point ....

Rgds,
Joachim

Periodic - Error in Hidden Script

prieper — Thu, 01 Oct 2009 02:53:43 GMT

Error-Message sounds, as if you are probably referring to a file, which is not available (or a network-drive currently not connected)

Peter

Periodic - Error in Hidden Script

biester — Thu, 01 Oct 2009 03:32:47 GMT

To check Peters suspicion you could use Sysinternals suite (I think it's filemonitor but it could be anything else, never remember the name) on the target server (the not available machine) ..... Peter, a very good guess, but it could as well be the Easter bunny changing permissions randomly by a script ... (I've done that already on a 1st April).

Don't get me wrong: I appreciate it very much that you don't publish the script, that's a matter of trust your customer put in you. But I don't want to guess ... so give the support a chance ...

Rgds,
Joachim

Periodic - Error in Hidden Script

Thu, 01 Oct 2009 03:52:07 GMT

thanks for your comments. I've got a support guy from the vendor looking at it and we haven't spotted anything.

Was wondering if someone remembered something that created this kind of error.

I am working over a vpn to a remote sql server, but not sure if something else is involved.

Example a hidden script component calls a macro that does a CreateObject() to unscramble user passwords.

I could live with the error if I didn't corrupt the file

Thanks

Periodic - Error in Hidden Script

Anonymous — Thu, 01 Oct 2009 06:28:15 GMT

The first step is to move the script from hidden to "open" part. Next time there is the error - you can see what exactly is wrong.
There is a possibility that the error is data-driven, hence intermittent.

Re: Periodic - Error in Hidden Script

Wed, 02 Dec 2015 08:51:06 GMT

Thanks Michael that will surely help!