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

[maxgro]

try to store in a path  like c:\something\...,

where you know the QlikView service account can write (permissions)

not a network or shared path

[stewart_lancast]

the problem with that is that the current path is local to the server (it is essentially the C drive of the server).

when i change it to my local c drive it doesn't work as this is being run from the qmc on the server.

i had also tried a network location but i seem get this erroer regardless of the location

[stewart_lancast · Accepted solution]

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, awhitfield‌ maxgro‌ and @Kuczynska for your helpful suggestions

Stewart

[krishna20]

Always Glad to work stewart..