topic Script error in QlikView

Script error

Mon, 06 Oct 2014 22:05:47 GMT

Can anyone point me in the right direction of correcting this script - Everything seems to be ok but its failing to load - prob something simple

I'm cert its something to do with the file path actually - recall being told if the files on your desktop that ya uploading it causes the script to full over

Any help be gd

Paul

[Aircraft Types]:
LOAD AC_TYPEID as [%Aircraft Type ID],

     AC_GROUP as [%Aircraft Group Type],

     SSD_NAME as [Aircraft Name],

     MANUFACTURER as [Aircraft Manufacturer],

     LONG_NAME as [Aircraft Name Full],

     SHORT_NAME as [Aircraft Name Abbreviated],

     BEGIN_DATE as [Aircraft Begin Date],

     END_DATE as [Aircraft End Date]
FROM

[..\..\..\..\..\paul\Desktop\Qlikview download\Chapters 1 - 11\QlikView
Development\Airline Operations\Data Files\CSVs\Aircraft_Base_File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Groups]:
LOAD [Aircraft Group ID] as [%Aircraft Group Type],

     [Aircraft Engine Type],

     [Aircraft Number Of
Engines]
FROM

[..\..\..\..\..\paul\Desktop\Qlikview download\Chapters 1 - 11\QlikView
Development\Airline Operations\Data Files\CSVs\Aircraft_Group.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Re: Script error

Anonymous — Mon, 06 Oct 2014 22:08:03 GMT

Any specific error message?

Re: Script error

stevedark — Mon, 06 Oct 2014 22:16:21 GMT

Hi Paul,

I would look at simplifying the relative path. Save your QVW into the folder

Desktop\Qlikview download\Chapters 1 - 11\QlikView

Development\ and the relative path is then just .\Airline Operations\Data Files\CSVs\Aircraft_Base_File.csv .

The only other thing that looks iffy in the script is the carriage return in the middle of the Number of Engines field. Should that be there?

Most things in QlikView load scripts give reasonably sensible error messages. The couple of things that don't are having the same field name appearing twice in a single load, trying to write a file (eg. QVD) to a folder that does not exist or trying to overwrite a locked file. These things all cause failures with no sensible error message.

I can see you are loading in example data from QlikView 11 For Developers. I've run training courses based on this book a number of time, and can assure you that these loads tend to work fine (when delegates don't forget semi colons).

Personally, I would not put spaces in table labels, which means the square brackets are not required there - but I know the exercises in the book suggests you do have them.

Hope that helps,

Steve

Re: Script error

Tue, 07 Oct 2014 05:54:41 GMT

No error message just jumps straight to the little failed dialog box - I think this is deff a path issue actually and will give Steve's solution a bash - See if that helps

Paul

Re: Script error

Tue, 07 Oct 2014 06:05:21 GMT

Hi Steve

Might try moving my file to the same location see if that helps as per your advice!

The path is rather long

Did try moving my working files to my documents - but still same error

Your correct loading data from developer - fab up to now

I'm following the developer guide to the T so everything you see is as per instructions

Let me have bash and I will let you know how I get on

Tx for your help!

Paul

Re: Script error

Peter_Cammaert — Tue, 07 Oct 2014 07:18:43 GMT

Copied your code from this post into the script editor. Changed long paths into [.\Data Files\CSVs\Filename.csv]. Ran the script and got this error:

I removed the Newline and the script now runs without any problems. No idea why you're not getting an error message.

I'm using Desktop 11.20SR8.

Peter

Re: Script error

perumal_41 — Tue, 07 Oct 2014 07:24:06 GMT

Hi Paul,

any one table comment and reload aplication .can come to know reload failed happen from which table.

any store statement using in application?

Re: Script error

stevedark — Tue, 07 Oct 2014 07:56:11 GMT

There is a point in the book where QlikView bails out without an error message. Right after it advises you to save before reload.

The text asks you to re-jig your script a bit, leaving a couple of list boxes that don't have fields attached. In earlier versions of QlikView this worked fine - it just showed you the empty list boxes. On more recent versions it fails. If you delete the list boxes before the reload all is fine. Also, if you do a Debug load with very few rows it also works. It's the Aircraft Group and Aircraft Type list boxes on page 220.

Looking at the code you have I suspect this is where you are in the book.

Also, while we are on little gotchas in the book, there is a variable name that has a case issue. There is a variable that is quoted as eAirTime and eAirtime. On page 191 it should show with a capital T.

Hope that helps,

Steve

Re: Script error

Sat, 25 Oct 2014 15:40:03 GMT

Well I'm at a total loss on this error I've totally started again thinking it was something I had done along the way just got to loading that script and exactly the same thing as occurred. This time I created a folder right next to my C-drive content .

The weird thing is if I open a new Qlik doc totally blank and load the script it loads perfectly fine. Its seriously strange and very frustrating

LOAD AC_TYPEID as [%Aircraft Type ID],

     AC_GROUP as [%Aircraft Group Type],

     SSD_NAME as [Aircraft Name],

     MANUFACTURER as [Aircraft Manufacturer],

     LONG_NAME as [Aircraft Name Full],

     SHORT_NAME as [Aircraft Name Abbreviated],

     BEGIN_DATE as [Aircraft Begin Date],

     END_DATE as [Aircraft End Date]

FROM
[..\Aircraft_Base_File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Groups]:

LOAD [Aircraft Group ID] as [%Aircraft Group Type],

     [Aircraft Engine Type],

     [Aircraft Number Of Engines]

FROM

[..\Aircraft_Group.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Re: Script error

SunilChauhan — Sat, 25 Oct 2014 15:49:25 GMT

keep .csv file and qvw application in same folder and use dircetory keyword below

directory;

LOAD AC_TYPEID as [%Aircraft Type ID],

     AC_GROUP as [%Aircraft Group Type],

     SSD_NAME as [Aircraft Name],

     MANUFACTURER as [Aircraft Manufacturer],

     LONG_NAME as [Aircraft Name Full],

     SHORT_NAME as [Aircraft Name Abbreviated],

     BEGIN_DATE as [Aircraft Begin Date],

     END_DATE as [Aircraft End Date]

FROM
[Aircraft_Base_File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Groups]:
directory;
LOAD [Aircraft Group ID] as [%Aircraft Group Type],

     [Aircraft Engine Type],

     [Aircraft Number Of Engines]

FROM

[Aircraft_Group.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

hope this helps

Re: Script error

Sat, 25 Oct 2014 16:52:46 GMT

Unfort exactly the same error - I had moved all CSV files before to same error as my working file just pushed out same error - Tried using directory name but still no joy

Re: Script error

stevedark — Sun, 26 Oct 2014 06:20:47 GMT

Hi Paul,

Have you followed the steps in my email of a couple of weeks back?

Before reloading delete the Aircraft Group and Aircraft Type list boxes, this step is referenced on page 220 - after the load, but due to a crash introduced in a later version of QlikView you need to do it before the reload.

Cheers,

Steve

Re: Script error

Sun, 26 Oct 2014 11:18:35 GMT

Hi Steve

Thanks for your input! Can see you know your way around the book I see the Variable AirTime error with the lower case t & capital T obviously when your following any book you follow it to the T like a recipe. - l have done exactly what it said on the tin on that one so I will correct that! What did this time when I started from scratch was created a backup copy following on from behind the one I'm working on (Prob always advisable actually) and each time I got so far I loaded the script to see if it fell over appears all is ok up to the point of having the gauges set up and in place just before replacing the formulas with Variables - eLoadFactor variable is in place and it wrks fine. However I have noticed a couple things as well as the current script error that I already have that you may be able to shed some light on - When you replace the ePerformedVsScheduled formula with the variable the Gauge disappears even though you make a number of different selections it doesn't come back ? Just says "No Data Available" know this can happen as looked on gauges on the master - However it should come back at some point obviously. The Air Time gauge I'm having the same prob with to actually - I did do this manually as I preserved for days with the Find & replace tool and it just wasn't working for me even though all my formulas were entered & edit with the drop downs & paste option it still wasn't picking them up - I got past this actually on my first original attempt but do recall having exactly the same prob when replacing the formulas with variables - Any help is much appreciated!

Paul

Re: Script error

stevedark — Sun, 26 Oct 2014 23:05:17 GMT

Hi Paul,

I'm quite familiar with the text, as I was actually a technical editor on the book. I also use it as the basis for the regular training courses I run. I therefore see delegates hitting the pitfalls as they work through the exercises.

I can't specifically recall an issue with that variable on the gauges, but I would double check the variable name - including upper and lower case characters. Also check that the code that you thought you put in against the variable actually is against the variable. There is a nasty gotcha in QlikView where you create a new variable and then immediately type in the code for it - that code is then lost.when you close the variable window. To ensure the code is stored you need to click on the variable name after creating it and before entering the variable value.

If you reduce the data from the app (File \ Reduce Data \ Remove All Data) you can then post it up here and I can load it against my copy of the data files. It is probably something with a simple explanation.

Cheers,

Steve

Re: Re: Script error

Mon, 27 Oct 2014 20:41:14 GMT

Hi Steve

I can see you know your Qlik

Think I went over & over those variables so many times I know them off by heart - Prob is something that a experienced eye can see and I've missed. I know it warns you to highlight the new Variable on the Variable overview when typing in your formula which I've done. Whats strange is once you add it to the gauges they disappear well the ePerformedVsScheduled does the Air time stays but disappears on and off when making selections which could be norm - not sure. But on the Expression overview all looks ok on all the variables that I entered

Anyway thanks for your input - see what you can make of it hope did this right in removing the data its a backup copy anyway

Paul

Re: Re: Re: Script error

stevedark — Mon, 27 Oct 2014 21:07:05 GMT

Hi Paul,

I'm slightly confused by the load script, as it references both the QVDs and the CSVs as being in the same folder as the QVW (i.e. there is no path provided). The source data is not laid out like that.

When I fixed up the load script so that all files could load the gauges all showed fine. With the QVW saved in the Apps folder the path should read like this: ..\Data Files\CSVs\Origin Markets.csv The same is true of the Access database: ..\Data Files\MDBs\Dimension Tables.mdb

Do you currently get any warnings on reload? It may be that some fields required by the gauges simply are not there.

Attached is a copy of the file where I have fixed up the script, reloaded and reduced the data (but left a few rows).

Hope that helps,

Steve

Re: Re: Re: Script error

Mon, 27 Oct 2014 21:48:23 GMT

Hi Steve

I've moved the files all over the show that was to try and sort the orig error I had with the file path.. You are correct the CSV's & QVD's are in same folder now

Files were all laid out originally as outlined in the book on my desk top - that was until things went belly up with the file path. I then moved them around to see if it would sort the prob out

Unfort can't open what you have done - Unless you know of a way ?

Could be in trying to resolve one prob I've created another

Only re-load I've done is the one where it falls over with the file path which was my prob in first instance

Maybe I need to start again clear everything re-create my folders see how I get on - At this rate I'll be able to do it with my eyes shut which I guess is not such bad thing lol

Your a big help actually! Your cert pointing out what's a miss and whats not!

Paul

Re: Re: Re: Script error

stevedark — Mon, 27 Oct 2014 23:28:00 GMT

Hi Paul,

Suspect the reason you can't open my changes is that you are running Personal Edition?

I would certainly try a reload, and make sure it goes through with no errors. You may need to adjust some paths to make that work.

I think it is more likely to be partial data from a previous failed load than the variable - otherwise I would have not been able to see the gauges working this end.

Good luck!

Steve

Re: Re: Re: Script error

Tue, 28 Oct 2014 01:12:02 GMT

Hi Steve

Yes I'm running Personal Edition

I will have another go see where that takes me - Let you know how I get on with it

Many thanks

Paul

Re: Re: Re: Script error

stevedark — Tue, 28 Oct 2014 08:39:10 GMT

Another thing you can do is open the solution for the chapter and then delete the things that you have not yet created, in order to build them yourself.

Steve