Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
stewart_lancast
New Contributor III

Server reload failure

Hi,

I have written my first few Qlik reports and have hit a roadblock along the way.

Specifically i am running a simple SQL query (works fine) then storing the table into a CSV:

//Variables:

Let vDate = Date(Now(), 'YYYY.MM.DD');

let vPath = '\QlikView\2015\';let vPath = '\QlikView\BCP\2015\';

FX:

SELECT code, fullname, sign, lastbid, lastoffer, pricedate

FROM SYSTEM.currencies;

STORE FX into $(vPath)CCY $(vDate).csv (txt);

When I run this via the desktop software it works perfectly, but when i run this via the qmc on the server I get a failure.

I have looked at the log file and get the below generc error message:

10/08/2015 11:26:34: 0027  STORE FX into \QlikView\2015\CCY 2015.08.10.csv

10/08/2015 11:26:34:       General Script Error

10/08/2015 11:26:34:       Execution Failed

10/08/2015 11:26:34:      Execution finished.

Any ideas as to how i c

1 Solution

Accepted Solutions
stewart_lancast
New Contributor III

Re: Server reload failure

Hi All

We've finally got to the bottom of this - the service account linked to the server did not have the correct permissions.

In addition, the networked path \QlikView\ was actually in the my Documents section of the service account on the server - lazy work from the IT team.

Due to the size it has been given its own drive E:\QlikView\ and the correct permissions are now in place and it is working perfectly, I just wish I hadn't spent two days trying to fix the code, thank you to @Krishna 20, awhitfieldmaxgro‌ and @Kuczynska for your helpful suggestions

Stewart

13 Replies
krishna20
Valued Contributor

Re: Server reload failure

Hi Stewart,

Have you checked  the disk space whether it is filled up or remaining space available.??

awhitfield
Esteemed Contributor

Re: Server reload failure

Hi Stewart,

You appear to have vPath specified twice

HTH - ANDY

stewart_lancast
New Contributor III

Re: Server reload failure

Hi krishna20

I haven't got the required access ot he server to see how much space is remaining, however i this is a new server "with plenty of space" - not very helpful i appreciate!

However, when i run the report on my desktop it creates the CSV from the store command in the server directory (\QlikView\2015\) so I don't think it can be a space issue.

S

stewart_lancast
New Contributor III

Re: Server reload failure

Hi Andrew - well spotted, this is a copy and paste error from my scrip to the forum, the actual script only has it once

many thanks

Stewart

kuczynska
Contributor III

Re: Server reload failure

Does your server/publisher have access to this DB? Are your QV services setup under the user that can actually access this location? There also might be some other issue (I'm assuming less possible), that maybe there is another query trying to read/write from this table. If your services are setup correctly I would double check with your DBA

Edit: I just noticed that now, apologies - it fails on the store itself, you are able to read from this location. Can you try to rename the csv in your STORE command to something that doesn't have dots? Like CCY_2015_08_10

stewart_lancast
New Contributor III

Re: Server reload failure

I am wondering if it is anything to do with the Oracle connectors on the server - the desktops had to have ODAC installed to connect to the DB - and having spoken to one of the server support team , this hasn't been installed on the server.

I will let you know if this fixes it.

Stewart

awhitfield
Esteemed Contributor

Re: Server reload failure

Ha, just to easy for it to be that I suppose 

You could check your theory below by running the reload from QV Desktop on the server!

Andy

MVP
MVP

Re: Server reload failure

comment the store on the server and reload

if you don't get any error, the sql load (connection to the database) works, so the db shouldn't be the problem

stewart_lancast
New Contributor III

Re: Server reload failure

thanks

I did as suggested and it worked absolutely fine (the query was returned and displayed in a flat table)

I have also tried to use a fixed filepath without the variables and that also fails (but works on the desktop software)

looks like the ODAC option wasn't the issue after all

Community Browser