Script Line Error. Can't find my mistake

[max_potass]

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

[vishsaggi]

Can you screen shot that script error you are getting?

[dan_sullivan]

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

[tamilarasu]

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?

[max_potass]

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

[max_potass]

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

[max_potass]

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

[max_potass]

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.

[PrashantSangle]

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

[max_potass]

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.