Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Stewart,
Have you checked the disk space whether it is filled up or remaining space available.??
Hi Stewart,
You appear to have vPath specified twice
HTH - ANDY
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
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
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
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
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
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
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