topic Re: Error in load script in QlikView

Error in load script

Anonymous — Mon, 28 Sep 2015 18:07:59 GMT

Hi experts,

Can any one of you help me why this error is coming

Re: Error in load script

MK_QSL — Mon, 28 Sep 2015 18:22:09 GMT

You don't have Inserts table in your script...

This could be you have dropped this table before this concatenation...

Re: Error in load script

Gysbert_Wassenaar — Mon, 28 Sep 2015 18:23:17 GMT

Check that you have already created a table with the name Inserts. If you created such a table, but it has exactly the same fields as another table you created earlier then that table won't be created as Inserts but the data will be added to the first table.

Re: Error in load script

Anonymous — Mon, 28 Sep 2015 18:37:52 GMT

Is the table ' Inserts' tyhe one you are reading from D:\? do you have the table name in your script?

It is not recognizing that table name - either it has not been loaded yet, it has been dropped or there is a spelling mistake (including capitalization)

Re: Error in load script

pamaxeed — Mon, 28 Sep 2015 19:01:26 GMT

Can you share some additional details?
It seems the Insert table was not created or was just dropped....

Re: Error in load script

qlikviewwizard — Tue, 29 Sep 2015 02:19:52 GMT

Hi kumarreddy257,

Can you provide us the full sample script to demonstrate your issue to avoid imagination.

Re: Error in load script

Anonymous — Tue, 29 Sep 2015 12:33:38 GMT

Hi all,

Can you pls find the below script

For each vFile in filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_inserts.qvx')

Inserts:

LOAD *

FROM [$(vFile)] (QVX);

next vFile

Concatenate (Inserts)

LOAD *

FROM

D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd

(qvd);

Store Inserts into D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd);

Drop Table Inserts;

///////////////////Updates////////////////////

For each vFile in filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_updates.qvx')

Updates:

LOAD *

FROM [$(vFile)] (QVX);

next vFile

Concatenate (Updates)

LOAD *

FROM

D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd)

Where not exists(account_key);

Store Updates into D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\Data Models\Gqvd\dim_account.qvd (qvd);

Drop Table Updates;

Re: Error in load script

MK_QSL — Tue, 29 Sep 2015 12:37:17 GMT

Try to load only one file using below path..

filelist('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\dim_account_inserts.qvx') and check whether it's working or not...

Re: Error in load script

pamaxeed — Tue, 29 Sep 2015 12:40:21 GMT

Are you sure that the table INSERTS get created ?

Are you entering in the for each LOOP? Maybe you can add a TRACE statement to see if you entering the loop....

Or just check if the Inserts table is created and add an EXIT Script statement just after the for loop like below:

For each vFile in filelist('xxx')

Inserts:

LOAD *

FROM [$(vFile)] (QVX);

next vFile

EXIT Script;

Cheers,

Patric

Re: Error in load script

jonathandienst — Tue, 29 Sep 2015 12:48:10 GMT

It looks like the first loop is not lading any content. Open the debugger and single step through the script to see what's happening.

Just noticed that your filelist has no wildcards (both), so it will look for exactly one file matching that path and name. i have a feeling that it does not exists.

Normally the fllelist is a path with wilcards, like

... in FileList('\\10.12.250.152\SourceDocuments\QVX\Mktg_Funnel_Prj\*.qvx')

Re: Error in load script

sasiparupudi1 — Tue, 29 Sep 2015 12:56:15 GMT

Your script and the error message do not seem to match..

I do not see a where condition , where (account_record_updated_datetime>'.079...')

is this ithe correct script?

hth

Sasi

Re: Error in load script

Anonymous — Tue, 29 Sep 2015 13:23:53 GMT

Hi Jonath,

If i mention wildcard it will call all qvx files. But I am testing specific to only one file. If it is working fine for that qvx then i will do wild card.

Regards,

Kumar

Re: Error in load script

Anonymous — Tue, 29 Sep 2015 13:27:10 GMT

Hi Manish,

Even for single file also it is having same issue.

Regards,

Kumar

Re: Error in load script

MK_QSL — Tue, 29 Sep 2015 13:28:20 GMT

means your loop is not generating any tables...

Re: Error in load script

jonathandienst — Tue, 29 Sep 2015 13:29:47 GMT

OK - have you tried just loading that file in a simple qvw. Does the load return any content?

It looks like either the path is wrong (which would not cause an error in FileList) or the qvx file has no rows. I don't have much experience with the qvx format, but in a qvd file, the header is XML and it contains a no of rows XML element. This can be 0.

Re: Error in load script

jonathandienst — Tue, 29 Sep 2015 13:30:53 GMT