topic Re: Bypassing QV script error? in QlikView

Bypassing QV script error?

Wed, 06 Aug 2014 10:59:35 GMT

Hi,

Sometimes I have a server task failing due to certain files being used by another script at the exact time.

I am wondering if it is possible to write code that bypasses this? I mean, is it possible to make the script move past a file IF it is already in use by another process, instead of stopping the script reload and throwing an error?

I am also wondering if this might be a good idea at all?

Re: Bypassing QV script error?

ashfaq_haseeb — Wed, 06 Aug 2014 11:04:59 GMT

Hi,

As per Qlikview behavior is not supported.

you can skip warnings but not errors.

Regards

ASHFAQ

Re: Bypassing QV script error?

tresB — Wed, 06 Aug 2014 11:07:40 GMT

set ErrorMode=0;

Example:

load * from abc.qvw;

if ScriptError=8 then // see help for different types of error . Here 8 means 'No file is found'

exit script;

//no file;

end if

Re: Bypassing QV script error?

Wed, 06 Aug 2014 11:13:44 GMT

Thank you. I did not realize this existed. My error is not on the list ("The process cannot access the file because it is being used by another process"). Is this windows specific and therefore not listed as a "QV Error"? (I am a beginner at this, so please bare with me )

Re: Bypassing QV script error?

tresB — Wed, 06 Aug 2014 11:15:14 GMT

Yes, you are right here.

But for such case, I would try to catch the error using ScriptErrorDetails and then conditional script.

Re: Bypassing QV script error?

sujeetsingh — Wed, 06 Aug 2014 11:16:36 GMT

Read the attached document please

Error Handling in Qlikview

Re: Bypassing QV script error?

Bill_Britt — Wed, 06 Aug 2014 11:20:12 GMT

Hi,

Maybe you need to look at you scheduling and try to fix it so the reloads are not using the same files. You can do this with dependences.

Bill

Re: Bypassing QV script error?

ashfaq_haseeb — Wed, 06 Aug 2014 11:24:00 GMT

Exactly agree with bill.

You cannot handle this in Qlik.

This is not related to Qlik, This is something related to file sharing.

Regards

ASHFAQ

Re: Bypassing QV script error?

Wed, 06 Aug 2014 13:12:13 GMT

tresesco wrote:

But for such case, I would try to catch the error using ScriptErrorDetails and then conditional script.

Could you please elaborate some more on this? Would that enable me to bypass the error or just give me more information? Since it is windows specific..

Re: Bypassing QV script error?

tresB — Thu, 07 Aug 2014 05:54:37 GMT

I was trying to replicate your issue in vain. Then I went back to your first post, uhh - this error is not actually been thrown by qlikview during load process, rather it's prior to that and by windows os. Therefore, not in the scope of qv error handling. In such cases - follow process as Bill Britt suggested.

Re: Bypassing QV script error?

Thu, 07 Aug 2014 06:18:52 GMT

Thank you for the clarification. I'll have to look into what we can do with dependencies.