Server reload failure

[stewart_lancast]

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

[krishna20]

Hi Stewart,

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

[awhitfield]

Hi Stewart,

You appear to have vPath specified twice

HTH - ANDY

[stewart_lancast]

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]

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]

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]

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]

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

[maxgro]

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]

thanks maxgro

great idea - I have been trying different variations of code for hours.... wish I had thought of that sooner

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