I am having trouble with reloading automatically through the Qlikview Management Console. When I manually reload, the script is executed successfully. However, when trying to reload automatically, the source document log file shows that the file path cannot be found (I use data files in a specific location and not a database). How is this possible? If the manual reload executes successfully, shouldn’t the automatic process also?
You may have access to the required folders, are you sure the server has permissions? Is the path the server would follow the same as the path you would follow? i.e. the server won't be able to access your desktop or personal drives..
Are you loading info fro a database or from files? This sounds like you've put in a hard coded file path like Q:\QVDfolders\QVDFiles\Loadthisfile.qvd when in fact you perhaps need to use a relative path. Is it a very long script or can you paste it in here so we can have a peek?
Thank you for your reply. As I've mentioned to Felim, all files and models are on the server. Please see below part of the script (This is the first segment of my script and also were the error occurs)
Also ensure that the Windows user which is running the QlikView services has enough permissions to read all source folders. If you are using Section Access ensure that the same user has full access to the entire data model.
I agree with Emma though; hard coded paths is generally a bad idea, use relative paths wherever possible.
Thank you for all the replies. They were all correct and very helpful. The server has the necessary permissions, so it was definitely the hard coded paths creating my problem. Before we end the discussion, could you please explain why relative paths are preferred over hard coded paths? I would like to impart the knowledge to my fellow users.