topic Re: Why no error message when execute SP failed? in QlikView

Why no error message when execute SP failed?

Mon, 10 Feb 2014 07:58:22 GMT

Dear Experts,

I found a strange behavior when reloading my QV file.

I made a typo about a stored procedure name, so of course there no line fetched by that stored procedure (you can simply regard this scenario as: there's no such sp exists in the connected db).

But my point is, there is no error message popped out when reloading, neither anything logged down in the log file.

Is this a product bug or did I missed setting any options?

Thanks in advance.

Patrick

Re: Why no error message when execute SP failed?

giakoum — Mon, 10 Feb 2014 08:07:24 GMT

What error mode have you ?

ErrorMode

This variable determines what action is to be taken by QlikView when an error is encountered during script execution. By default (ErrorMode=1) the script execution will halt and the user will be prompted for action (non-batch mode). By setting ErrorMode =0 QlikView will simply ignore the failure and continue script execution at the next script statement. By setting ErrorMode =2 QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand.

Example:

set ErrorMode=0;

Re: Why no error message when execute SP failed?

Sokkorn — Mon, 10 Feb 2014 08:13:46 GMT

Hi Patrick,

I'm afraid you set ErrorMode=0. Something like this

Set ErrorMode = 0;

Load ....

Regards,

Sokkorn

Re: Why no error message when execute SP failed?

Mon, 10 Feb 2014 08:20:34 GMT

Hi Ionannis,

Thanks for your reply.

It's 0, in log file it says so.

But I just tried manually change it to 1 and 2 in my script, the result is the same.

No error message prompted.

Seems QV doesn't regard sp that couldn't be found as an error.

Btw, I'm using QV 10g.

Patrick

Re: Why no error message when execute SP failed?

giakoum — Mon, 10 Feb 2014 08:23:05 GMT

instead of sp, if you try to read from a table that does not exists, does it report an error?

Re: Why no error message when execute SP failed?

Sokkorn — Mon, 10 Feb 2014 08:26:17 GMT

Hi Patrick,

You may search all tab to find out ErrorMode=0

It may have more than one.

Regards,

Sokkorn

Re: Why no error message when execute SP failed?

Mon, 10 Feb 2014 08:37:28 GMT

Hi Sokorn,

Thanks for your reply.

There's no such setting in my script, it should be default set to 0, or perhaps there's some server level setting which I'm not sure of.

Do you mean I should manually set this to 1 instead of 0?

Patrick

Re: Why no error message when execute SP failed?

Mon, 10 Feb 2014 08:38:02 GMT

Yes, it does.

As well as wrong field name or something like that.

Re: Why no error message when execute SP failed?

Sokkorn — Mon, 10 Feb 2014 08:48:08 GMT

Hi Patrick,

By default, ErrorMode=1 (see in help file).

Now let try Set ErrorMode=1; on top of your script and see what happen when you load it.

Regards,

Sokkorn

Re: Why no error message when execute SP failed?

Wed, 12 Feb 2014 02:27:55 GMT

Hi Sokkorn,

Sorry for late reply.

I tried to set the error mode to be 0 ,1 and 2, all cannot solve it.

Seems QV doesn't concern if the SP exists.

One hint is that, In QV reload log file, no matter I type the right or wrong SP name, there's always one row to indicate it, and no error message:

......

2/12/2014 10:21:37 AM: 0074 SQL exec db.dbo.XXXXXX

......

Re: Why no error message when execute SP failed?

Sokkorn — Wed, 12 Feb 2014 02:53:16 GMT

Hi Patrick,

Let debug together by create new QlikView document and use only one script SQL exec db.dbo.spName; then see what happen after we reload script.

Regards,

Sokkorn

Re: Why no error message when execute SP failed?

Thu, 13 Feb 2014 02:19:47 GMT

Hi Sokkorn,

I've tried these scenario and more, but QV just doesn't regard SP failure as an error.

I wonder if this really is a bug.

Patrick

Re: Why no error message when execute SP failed?

Sokkorn — Thu, 13 Feb 2014 02:51:48 GMT

Hi Patrick,

It can be a bug. Anyhow, we may contact support@qlik.com or Ms. Sara Leslie can clarify on this.

Regards,

Sokkorn

Re: Why no error message when execute SP failed?

Thu, 13 Feb 2014 03:00:13 GMT

Hi Sokkorn,

Thank you very much.

I'll report this and post the result if there's any solution or explanation.

Patrick

Re: Why no error message when execute SP failed?

Sokkorn — Thu, 13 Feb 2014 03:01:26 GMT

Thank Patrick. Keep post here to let me and everyone know

Regards,

Sokkorn