topic Re: Issue calling stored procedure in IF ELSE statement in App Development

Issue calling stored procedure in IF ELSE statement

Wed, 09 Mar 2016 16:34:55 GMT

Hello everyone,

I'm working on our load script and I'm running into a problem. We're implementing incremental load and I've got to call a stored procedure in SQL, but I'm having problems putting the call into an IF ELSE. Here's the code

if $(FirstReload) = true then

LOAD *;

SQL EXECUTE EV_TEST;

else

LOAD *;

SQL EXECUTE EV_TEST '$(vExecTime)';

end if

So what I'm seeing is when I run this:

The following error occurred:

Script line error:

The error occurred here:

else

So I'm not sure if I'm doing something incorrectly with my call to load the stored procedure, or if I have some syntax wrong with my IF ELSE.

Re: Issue calling stored procedure in IF ELSE statement

Gysbert_Wassenaar — Thu, 10 Mar 2016 08:51:50 GMT

Have you tried both sql statements separately without the if-then-else?

Re: Issue calling stored procedure in IF ELSE statement

paul_scotchford — Thu, 10 Mar 2016 09:53:06 GMT

Syntax looks fine, your Stored Proc, is the input param mandatory or optional, as there is no param on the first call? Hence the SQL maybe throwing the error .

Re: Issue calling stored procedure in IF ELSE statement

Thu, 10 Mar 2016 12:38:08 GMT

I've ran both without the IF ELSE and they both successfully run and bring back data. When I run without the param I get a tabled called EXECUTE EV_TEST. When I run it with the param I get a table called EXECUTE EV_TEST '2016-03-10 12:36:50' and that name changes with the timestamp. Both bring back the data I'm expecting and the correct data that correlates to having or not having the parameter.

Re: Issue calling stored procedure in IF ELSE statement

Thu, 10 Mar 2016 12:39:39 GMT

The input param is optional. We pass nothing over if it's the first time we're loading data and we want to pass the whole set back to qlik. We pass the parameter if it's not the first load so we can get incremental data. I can run both in SQL and both return data to qlik.

Re: Issue calling stored procedure in IF ELSE statement

Gysbert_Wassenaar — Thu, 10 Mar 2016 12:51:05 GMT

Since you're using variables... did you enable Legacy Mode? See: Qlik Sense Legacy mode and Disabling standard mode ‒ Qlik Sense

Re: Issue calling stored procedure in IF ELSE statement

Thu, 10 Mar 2016 12:54:38 GMT

Yes legacy mode is enabled. We've got some loading from disk as well so we've had to enable legacy mode for the app.

Re: Issue calling stored procedure in IF ELSE statement

Gysbert_Wassenaar — Thu, 10 Mar 2016 13:29:09 GMT

Curious. I'm afraid I don't know what's wrong. Can you try it in Qlikview too? Maybe you can generate a log file with more information that way.

Or try replacing one branch of the if statement with some code that can't fail: TRACE $(FirstReload) $(vExecTime);