problem loading script.

[#1]

Hi Qlikcommunity,

I reload my script after i edit it and it seems after 1 min and 3 sec this what happen, It stack to this (image below), then after 20-30min it error and said Error loading Script.

Please Help me,

[MayilVahanan]

Hi

Actually, in ur script, there is no "COLOR" table.

[#3]

Hi Mayil,

This is for the color.

COLOUR:

LOAD ColourID,

     Colour_RGB

FROM

(ooxml, embedded labels, table is Colour);

For vCurser = 0 to NoOfRows('COLOUR')

  LET vColourID =Peek('ColourID',vCurser, 'COLOUR');

  Let vColour_RGB_$(vColourID) =Peek('Colour_RGB',vCurser, 'COLOUR');

Next vCurser

LET vCurser =;

LET vColourID =;

[MayilVahanan]

Hi

Try like this,

For vCurser = 0 to NoOfRows('COLOUR')

  LET vColourID =Peek('ColourID',$(vCurser), 'COLOUR');

  Let vColour_RGB_$(vColourID) =Peek('Colour_RGB', $(vCurser), 'COLOUR');

Next vCurser;

LET vCurser =;

LET vColourID =;

Exit script;

Check in the log file.

Document properties -> Generate log file.

You can able to find the error message in that.

[#5]

Sir thank for helping but I think the reason why stack on loading script is the relationship on the tables, the synthetic keys i think. what do you think sir???

Thank for the help by the way

[simospa]

Lester,

as many of users said, you'd better to enable the log in Document Properties --> Generate log file and then reload script.

Analizing the generate file we'll be more useful to you.

S.

[simospa]

Another solution to help you could be insert an exit script statement at the end of 2nd table, then reload and see the join in table viewer, then remove the exit script and put in at the end of 3rd table and so on.

S.

[PrashantSangle · Accepted solution]

Hi,

There is so many reason. Which include Synthetic Key, Circular Loop.

For that Debug you code with limited data take 10.

After completion of debug load check data model by ctrl+T

You will find reasons.

Regards