topic Re: Script Loading problem in QlikView

Script Loading problem

Fri, 31 Jul 2015 06:42:02 GMT

Hi everybody,

I have a strange problem with my qvw app :

My app work great, but i when i remove the script for charging a particulary table from my load script, i get :
" Execution of Script Failed. Reload old data? "

When drop another table, i dont have this problem.

If somebody know what happened.....

Thanks

Re: Script Loading problem

qlikmsg4u — Fri, 31 Jul 2015 06:46:33 GMT

you may missing something like ";" or commas somewhere, please post the script that would be easy to look into the problem

Re: Script Loading problem

Fri, 31 Jul 2015 06:48:47 GMT

Some wrong syntax error in the code. Need to write correct code and reload.

Re: Script Loading problem

Fri, 31 Jul 2015 07:17:00 GMT

Here is the script, comapny works in energy, so i can't share files, even if i wanted too.

in files i joined, in my script, when a drop this table or make it like comment, i get script loading crash.

Re: Script Loading problem

Fri, 31 Jul 2015 07:35:37 GMT

Hi K N, i find out the problem, but i dont know why i get that,

if i delete all chart and graphic in my qvw app, and suppress the table, i dont have loading probleme.

You know what's the problem??

Re: Script Loading problem

Fri, 31 Jul 2015 07:36:03 GMT

Hi Kuldeep, i find out the problem, but i dont know why i get that,

if i delete all chart and graphic in my qvw app, and suppress the table, i dont have loading probleme.

You know what's the problem??

Re: Script Loading problem

sasiparupudi1 — Fri, 31 Jul 2015 07:43:06 GMT

You have breaks in your column names..

Try

POMT:

LOAD [Code],

Poche,

[Poche en contrainte ?]

FROM

[POMT.xlsx]

(ooxml, embedded labels, table is CH88_20150621_234715);

Left join (POMT) LOAD Départ as [Code du départ],

Poche,

[Nombre elements encadrants],

[Element encadrant amont],

[Element encadrant aval 1]

FROM

[Diagnostic poches OMT Midi Pyrénées.xlsx]

(ooxml, embedded labels, table is Poches);

Re: Script Loading problem

qlikmsg4u — Fri, 31 Jul 2015 07:43:32 GMT

no need to delete any thing in UI just delete the script once and again load it from source files may be you are missing something tiny thing like more spaces in column names i guess

Re: Script Loading problem

Fri, 31 Jul 2015 07:46:40 GMT

I dont want to load, this table, when i suppress or make it like a comment, i get loading crash.

But when i delete all chart and tab in my qvw app, i dont get that problem.

Dont understand what happened

Re: Script Loading problem

sasiparupudi1 — Fri, 31 Jul 2015 07:53:45 GMT

I do not see why you can not comment this table...May be you got the table joined to some other tables down the script?

if not , you should be able to do the following..

HTH

POMT:

LOAD [Code],

Poche,

[Poche en contrainte ?]

FROM

[POMT.xlsx]

(ooxml, embedded labels, table is CH88_20150621_234715);

Left join (POMT) LOAD Départ as [Code du départ],

Poche,

[Nombre elements encadrants],

[Element encadrant amont],

[Element encadrant aval 1]

FROM

[Diagnostic poches OMT Midi Pyrénées.xlsx]

(ooxml, embedded labels, table is Poches);

Re: Script Loading problem

Anonymous — Fri, 31 Jul 2015 07:56:56 GMT

as I understood there are two things:

if you delete objects in your qvw app, you have no Problems as These objects only exists onthe surface and have

nothing todo with the script (and script load). you never get an error message on this

if you delete or comment These tables in your script your load Fails. do you use the deleted/commented table (POMT) elsewhere? Normally just a message "table not found" should occur"

do you completely delete/comment the part? a "execution failed message" occurs e.gmm when something with file Actions Fails (eg. cannot write to log)

/*
POMT:

LOAD [Code],
Poche,
[Poche en contrainte ?]
FROM
[..\1_Sources\Poche OMT\POMT.xlsx]
(ooxml, embedded labels, table is CH88_20150621_234715);

Left join (POMT) LOAD Départ as [Code du départ],
     Poche,
     [Nombre elements encadrants],
     [Element encadrant
amont],
     [Element encadrant
aval 1]

FROM
[..\1_Sources\Poche OMT\Diagnostic poches OMT Midi Pyrénées.xlsx]
(ooxml, embedded labels, table is Poches);
*/

Re: Script Loading problem

Fri, 31 Jul 2015 08:02:20 GMT

Yes Rudolf, its exactly what happen,

Yes in some variable définition, i use the table POMT, and in a chart, but when i remove all tab in my qvw i have no problem. It seem the problem isn't the script, but other thing that i dont know, too strange

Re: Script Loading problem

qlikviewwizard — Fri, 31 Jul 2015 08:57:10 GMT

Please follow these steps:

1. Wrap the titles in source xls files. There is a space between encadrant and amont. Also for encadrant and aval Remove the space.

[Element encadrant

amont],

[Element encadrant

aval 1]

2. Uncheck the relative path and reload.

Hope this will help you.

Thank you.