topic ScriptErrorDetails in QlikView

ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 09:27:36 GMT

Hi,

My script as bellow..

Test:
LOAD
@1,
@2
FROM
U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\test.txt.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

vErrorType=ScriptError;

vErrordetail=ScriptErrorDetails;//Pls check latter for Value not assigning properly

vErrordetail=ScriptErrorList ;

if ScriptErrorCount=0 then //If Script Executed successfully!
//set vError=0;

Store Test into U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\Error.qvd;

ELSE //If Script not executed successfully!

Set vError=1;
exit script;
end if

Above script im not able access this inside vb script as ScriptErrorDetails value become null.. how i can store this value in variable so i can call this in macro..

Macro Vb script as bellow for call that Error

Set vErrType=ActiveDocument.Variables("vErrordetail")

Thanks in advance.

ScriptErrorDetails

kaushiknsolanki — Mon, 25 Jul 2011 09:33:32 GMT

Hi,

ScriptErrorDetail itself is a variable so no need to create any seperate variable to store the error.

to see the value of this variable

Create a textbox and type =ScriptErrorDetail.

So is there is any error while loading the script the description is stored in this variable.

Regards,

Kaushik Solanki

Re: ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 09:41:34 GMT

Hi Kaushik,

Thaks for your reply. i

agree with you but in my case i need to send error deatils in mail. so need to call ScriptErrorDetail vbscript..in Qv 10 im loosing value .. so i cant able call ScriptErrorDetail inside vb script..

well-come your any other suggestion. thanks

ScriptErrorDetails

kaushiknsolanki — Mon, 25 Jul 2011 09:49:30 GMT

Hi,

If you want to send mail when error occurs, you can try this.

Create a alert, here give condition as if (ScriptErrorCount<> 0,1,0)

This will trigger the mail when there is error.

Configure the mail.

in message you can write

=ScriptErrorDetail

For more info on alerts have a look at the help.

Regards,

Kaushik Solanki

Re: ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 09:56:51 GMT

hey thanks for your suggestion but i wantedcall this error in Vbscript .pls help me

ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 09:57:37 GMT

can u able to run my scipt?

ScriptErrorDetails

kaushiknsolanki — Mon, 25 Jul 2011 10:10:36 GMT

Hi,

First thing i want to tell you is that qlikview already said that its not fixed that always your macro will run.

So it is always recommended to use the built in feature of qlikview.

For macro you said.

"Macro Vb script as bellow for call that Error"

What do you mean by this.

Regards,

Kaushik Solanki

ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 10:46:19 GMT

Hi Kaushik,

Thanks for your valuable suggestion

I mean i have Etl Script as bellow

Test:
LOAD
@1,
@2
FROM
U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\test.txt.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

vErrorType=ScriptError;

vErrordetail=ScriptErrorDetails;//Pls check latter for Value not assigning properly

vErrordetail=ScriptErrorList ;

if ScriptErrorCount=0 then //If Script Executed successfully!
//set vError=0;

Store Test into U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\Error.qvd;

ELSE //If Script not executed successfully!

Set vError=1;
exit script;
end if

=============================MACRO========

in macro im calling vErrordetail as bellow

Set vErrDt=ActiveDocument.Variables("vErrordetail")

'MsgBox(vErrDt)

but vErrDt dint have any value as i lost value of vErrordetail in Etlscript itslef

i found reson that i had defined ScriptError and assigined to vErrorType vaiable after that lost.if its single variable vErrordetail it will store value.and i can call this in MACRO aslo.

thank u

ScriptErrorDetails

kaushiknsolanki — Mon, 25 Jul 2011 10:52:54 GMT

Hi,

This is a reviced version of your script.

Test:
LOAD
@1,
@2
FROM
U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\test.txt.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

if ScriptErrorCount=0 then //If Script Executed successfully!
//set vError=0;

Store Test into U:\QlikView\Monitor Dashboard\Email Notification Test\Email test 0720\Email test 0721\Error.qvd;

ELSE //If Script not executed successfully!

Set vError=1;
exit script;
end if

Now as i can see in your macro, it seems that you just want to display the error.. is it...?

If yes then create a alert which will show you the error.

This way you will achieve what you want and there will be no need of any macro.

So as i said ScriptErrorList contains the error and its a variable, so you dont need any other variable for that pourpose. If you want you can directly call tyhis variable in macro. like this.

Set vErrDt=ActiveDocument.Variables("ScriptErrorList")

MsgBox(vErrDt.getcontent.string)

Regards,

Kaushik Solanki

ScriptErrorDetails

srinivasa1 — Mon, 25 Jul 2011 12:58:17 GMT

Thanks for your reply.

i would like to call

ScriptError and

ScriptErrorDetails in same script. my try as bellow but its not working

not

ScriptErrorList

ScriptErrorDetails

erichshiino — Mon, 25 Jul 2011 15:21:09 GMT

Can you see something in the variable using the variable overview window?

Is your result similar to this post?

http://community.qlik.com/message/114781#114781

regards,

Erich

ScriptErrorDetails

kaushiknsolanki — Tue, 26 Jul 2011 08:51:11 GMT

Hi,

Can you please describe what are you trying to do and what you want.

Regards,

Kaushik Solanki

ScriptErrorDetails

srinivasa1 — Fri, 29 Jul 2011 05:18:12 GMT

Sorry for late reply as i was bit bussy. my pbm similer as bellow post.

http://community.qlik.com/message/114781#114781

Thank you.