topic Re: Script Line Error. Can't find my mistake in QlikView

Script Line Error. Can't find my mistake

max_potass — Fri, 11 Aug 2017 09:56:52 GMT

So I am currently trying to get following code working. When I execute it, I get a Script line Error. The code mentioned in the error starts at line 11. It probably is just a stupid mistage or misconseption as I am very new to this and have like no prgramming experience...

It would be nice, if someone can help me.

Let URL_Base='something';
Let Timeout='something';
Let URL_Open_1='something';
Let URL_Open_2='something';
Let URL_Intern_1='something';
Let URL_Intern_2='something';
Let URL_Extern_1='something';
Let URL_Extern_2='something';


For counter_1=0 to 2
  Let URL_1=$(URL_Base)&IF($(counter_1)=0,$(URL_Open_1),IF($(counter_1)=1,$(URL_Intern_1),$(URL_Extern_1)));
  Let URL_2=$(Timeout)&IF($(counter_1)=0,$(URL_Open_2),IF($(counter_2)=1,$(URL_Intern_2),$(URL_Extern_2)));
  For counter=0 to 14
  Let URL=$(URL_1)&($(counter)*1000)&$(URL_2);
  CUSTOM CONNECT TO $(URL);
  RestConnectorMasterTable:
  SQL SELECT
  "__KEY_root",
  (SELECT 
            "key",
              "__KEY_issues",
            "__FK_issues",
              (SELECT 
                    "created",
                    "__KEY_fields",
                    "__FK_fields",
                    (SELECT 
                    "@Value",
                        "__FK_customfield_10306"
                    FROM "customfield_10306" FK "__FK_customfield_10306" ArrayValueAlias "@Value"),
                    (SELECT 
                        "@Value" AS "@Value_u0",
                        "__FK_customfield_10305"
                    FROM "customfield_10305" FK "__FK_customfield_10305" ArrayValueAlias "@Value_u0")
              FROM "fields" PK "__KEY_fields" FK "__FK_fields")
        FROM "issues" PK "__KEY_issues" FK "__FK_issues")
  FROM JSON (wrap on) "root" PK "__KEY_root"; 
  [customfield_10306]:
  LOAD   [@Value],
        [__FK_customfield_10306]&'.1' AS [__KEY_fields]
  RESIDENT RestConnectorMasterTable
  WHERE NOT IsNull([__FK_customfield_10306]);
  [customfield_10305]:
  LOAD   [@Value_u0],
        [__FK_customfield_10305]&'.1' AS [__KEY_fields]
  RESIDENT RestConnectorMasterTable
  WHERE NOT IsNull([__FK_customfield_10305]);
  [fields]:
  LOAD [created],
        [__KEY_fields]&'.1' as [__KEY_fields],
        [__FK_fields]&'.1' AS [__KEY_issues]
  RESIDENT RestConnectorMasterTable;
  [issues]:
  LOAD   [key],
        [__KEY_issues]&'.1' as [__KEY_issues]
  RESIDENT RestConnectorMasterTable;

  Drop Tables [RestConnectorMasterTable];
  Let counter=$(counter)+1;
  next
Set counter=0;
Let SLA=If($(counter_1)=0,'open',If($(counter_1)=1,'intern','extern'));
STORE [customfield_10306] INTO customfield_10306_$(SLA).qvd (qvd);
STORE [customfield_10305] INTO customfield_10305_$(SLA).qvd (qvd);
STORE [fields] INTO fields_$(SLA).qvd (qvd);
STORE [issues] INTO issues_$(SLA).qva

Re: Script Line Error. Can't find my mistake

vishsaggi — Fri, 11 Aug 2017 15:29:53 GMT

Can you screen shot that script error you are getting?

Re: Script Line Error. Can't find my mistake

dan_sullivan — Fri, 11 Aug 2017 15:40:34 GMT

Is there more after line 67? if not make sure you have semi-colon there at the end.

Re: Script Line Error. Can't find my mistake

tamilarasu — Fri, 11 Aug 2017 19:13:13 GMT

Hi Max,

I could see two "FOR" loops in your script but only one "Next" statement. Could you try again by adding "Next" statement in the above script?

Re: Script Line Error. Can't find my mistake

max_potass — Mon, 14 Aug 2017 08:08:06 GMT

I attached the file. Just noticed, that the script line error includes my whole script, not only one tab.

Re: Script Line Error. Can't find my mistake

max_potass — Mon, 14 Aug 2017 08:10:17 GMT

There is. See answer to vishsaggi. I attached the whole file.

Re: Script Line Error. Can't find my mistake

max_potass — Mon, 14 Aug 2017 08:11:05 GMT

There is a second next. Forgot to copy that apperently. See answer to vishsaggi. I attached the whole file.

Re: Script Line Error. Can't find my mistake

max_potass — Mon, 14 Aug 2017 08:22:41 GMT

Oh, and there is no ';' after the next, but I tried it, and it did not work. It gave me more errors. Maybe I did something wrong.

Re: Script Line Error. Can't find my mistake

PrashantSangle — Mon, 14 Aug 2017 09:14:19 GMT

Hi,

difficult to identify just my guess

In variable URL_Intern_1 & URL_Extern_1. You are missing " which close your URL double quote (").

If it won't help run your script in debug -> step mode and check where you are getting error.

Regards,

Prashant

Re: Script Line Error. Can't find my mistake

max_potass — Mon, 14 Aug 2017 11:00:08 GMT

Hi,

that is not the issue. I combine URL_Base & URL_1 & URL_2 which is the the actual URL. And the double quotes should be around that, not around each part.

I have a similar code working in another setup just fine, so it should be good. But thanks anyway.

Re: Script Line Error. Can't find my mistake

marcus_sommer — Mon, 14 Aug 2017 11:32:07 GMT

I would go for an excluding-strategy. At first commenting the second/third script-tab (or per exit script;), then commenting the loading within the loop, then reducing the number of loop-iterations and some similar measures - I think you will be quite soon hit the error-reason.

- Marcus

Re: Script Line Error. Can't find my mistake

settu_periasamy — Mon, 14 Aug 2017 12:27:08 GMT

Hi,

Can you try to remove the double quote for the variable URL_Base and check it?

Try,

Let URL_Base='Provider=QvRestConnector.exe;url=https://ticket.xxx.services/rest/api/2/search?jql%2';

Re: Script Line Error. Can't find my mistake

vishsaggi — Mon, 14 Aug 2017 14:25:51 GMT

As Marcus Suggested debug the script as chunks and see where you getting this error?

Re: Script Line Error. Can't find my mistake

Peter_Cammaert — Mon, 14 Aug 2017 14:49:25 GMT

Settu is right. The error you get when executing your script is because of the unterminated double quote that causes everything after that line to be included in the LET statement.

Note that a statement like

Let URL_Base = ' "Provider=.....search?jq1%2';

will assign the string without the single quotes to variable URL_Base.

$-sign expansion in the first LET inside the FOR loop will then produce something highly illegal in scripting terms, like:

Let URL_1="Provider=...search?jq1%2&IF(0=0, (project%%20%2%%20%3BU...&maxResults%21000&startAt%2));

which isn't exactly regular QlikView script code. You could fix the quote problem by adding another double quote in the last expanded variable, but your embedded IFs certainly won't be executed as expected.

If you don't have any programming experience, and you want to do complex things in QlikView script, start with the easier stufff until you grow accustomed to the intricacies of string quoting, embedded IFs and $-sign expansion.

Re: Script Line Error. Can't find my mistake

max_potass — Tue, 15 Aug 2017 08:26:35 GMT

I had no time to fix this code, so I just did not loop the different URLs and put it in different tabs... But thanks for the help.

The Debugging did not help, as I see no error in my code. This apparently causes the error:

Let URL_1=$(URL_Base)&IF($(counter_1)=0,$(URL_Open_1),IF($(counter_1)=1,$(URL_Intern_1),$(URL_Extern_1)));

But even if the variables included are wrong, it should not give an script line error. I mean I only connect strings. It should give me an failed to connect later, if the URL is wrong.

Anyway, I have a solution that works, but it's just not as nice as this would have been.

Re: Script Line Error. Can't find my mistake

Peter_Cammaert — Wed, 16 Aug 2017 00:05:02 GMT

Good to hear that you managed to eliminate the problem.

However, with respect to your statement "But even if the variables included are wrong, it should not give an script line error", I think you are mistaken. Allow me to explain myself, as it may help you in handling similar situations in the future.

Your Let statement uses $-sign substitution to create the eventual value to assign to variable URL_1. However, the $-sign substitution will replace all $(variable) constructs after the equal sign with the contents of the respective variables before evaluating the statement itself.

If - as you say - one or more of these variables contain invalid content, then the $-sign substitution will produce a syntactically incorrect right hand-part of the Let statement. The script engine then tries to make sense of the wrongly formatted statement and is unable to.

That's why you get a generic message "Script Line Error" which is used to denote (amongst others) all statement syntax errors (like unbalanced quotes, too many comma's, missing semicolon terminators and whatever can be added or omitted from a statement).

Keep in mind that whenever you get a "Script Line Error", usually something very small/simple is missing in your code. And it's more than likely that you will get this message again some time in the future.

Good luck.