"cannot open file" error in reload task log when executed from qmc only
I need some advice. I have a qwv file which reads data from an only txt file, located in disk (O:) different from the main disk C where Qlik Server has installed.
I'm able as administrator user (which runs the Qlik services too) to reload the qwv manually from desktop but I receive the following error when I try to start the related task from QMC: "Error: cannot open file "O:Test.txt"." Then the message follows: It's not possible to find the relative path.
What do you think the problem is? Any suggestions?
I've already tried to flag relative paths and/or use paths like "\\servername\O$\Test.txt" but without success!
The user account which is running the services has access to O disk as a member of the Administrators group. And it has access to the qvw too (it has a CAL). In fact, if I use the account to access remotely on server and reload the qvw manually, the reload succeed. The problem is only from QMC.
If your error message above is a copy, "O:Test" is not a valid folder, "O:\Test" is (see the backslash). If it's a typo, you will have to enable the log in the QVW, then run the task in the QMC and check in the logs in which step does it stop, and open as that account the file exactly as it is mentioned in the script to verify that the permissions work.
Is the O: drive a mapped network share? Mappings are user objects set up when the user logs on to Windows. System accounts do not execute a login script and therefore cannot usually access mapped drives. Change the load statement so that it loads from the UNC path (ie something like \\yourserver\yourfolder) in place of O:
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
If the QlikView service account can open that file just going to Windows > Run > O:\Test.txt and it displays its content, I would contact your IT to see which issues the account may have to open the file interactively but not when running a service.
And if it does not open as mentioned from the Windows home button, I would double and triple check the permissions of the account running the services, such as the password has not change while the account was not stopped and running the services.
Check the effective permissions of that account by right clicking on the file > Properties > Security > Advanced > Effective Access > Select a user > (specify the account for the QlikView services) > View Effective access
By default, this should return "Full Control" with a green check mark in the list
we have the same issue at the moment. The file is accessible, the load script is running fine when executed from publisher locally via QV Client. But the reload fails when executed from QMC running on that same publisher with