topic Re: script failed and their reason should capture in QlikView

script failed and their reason should capture

rupaliqlik — Fri, 21 Sep 2018 08:25:08 GMT

Hi experts,

I have a requirement where I will load all server logs like (qvd extractor document logs).If my script execution is failed then I wil create flag Script_Failed ='Y' else N.If flag Y then I want to fetch the error like syantax error or anything .But if it is succsful then null.

Script failed	Header 2
Sctipt Failed	Error
Y	sysntax error
N
Y	Unknown statement
N

Regards,

Rupali Ethape.

kaushik.solanki‌stalwar1‌hic‌vatr841029‌

Re: script failed and their reason should capture

tresB — Fri, 21 Sep 2018 10:21:55 GMT

You could try like:

Set ErrorMode=0;

Load

If(Len('$(ScriptError)')=0, 'N', 'Y') as [Script failed],

'$(ScriptError)' as Header2

AutoGenerate 1 ;

Re: script failed and their reason should capture

rupaliqlik — Fri, 21 Sep 2018 18:21:34 GMT

Hi Tresesco B ,

My main concern is that how to load log file and captur error .I want to write a script.How to write a script to capture error flag?

Re: script failed and their reason should capture

Anil_Babu_Samineni — Mon, 08 Oct 2018 13:54:33 GMT

Difficult to load your log files into Qlik platform. Instead, We have tools to understand where that error occurs. Moreover, We can skip that error using SET ErrorMode = 0

Re: script failed and their reason should capture

rwunderlich — Mon, 08 Oct 2018 17:38:25 GMT

The free Script Log Analyzer tool

Qlikview Cookbook: Script Log Analyzer http://qlikviewcookbook.com/recipes/download-info/script-log-analyzer/

loads logs and flags those that are failing. You could use that as a base, Should be easy enough to update to capture some error reasons by looking for "Error:" in the script text.

You might also consider a different approach and read the C:\ProgramData\QlikTech\DistributionService\TaskResults files instead.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com