topic Re: While running the job in QMC it throwing error Cannot open file. in QlikView

While running the job in QMC it throwing error Cannot open file.

vinod22kv — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

Just I want to one clarification regarding job in QMC job. When I am executing the QVW file manually it is executing successfully but while running in QMC it is throwing path issue. could you please help me to do this? please find the below example for reference.

QMC Log details:

Error: Cannot open file '\\FPSERVER\Company\Shared\Household\TL - Performance\Quality 1_05_06_2018 Start LIVE 1.xlsx' The system cannot find the path specified.

General Script Error

Execution Failed

Execution finished.

When I am executing same QVW file manually it is running successfully without any log error.

And when I am loading multiple excels using the below script it is working fine. When I am trying to load single excel I am getting above error. Request you to help me out Please.

Set vConcatenate = ;

sub ScanFolder(Root)

for each FileExtension in 'xlsx'

for each FoundFile in filelist( Root & '\*.' & FileExtension)

WebChat:
LOAD [Department Name],
[Start Time (GMT+0)],
[Conversions (Agent Attributed)]

FROM [$(FoundFile)]
(ooxml, embedded labels, table is department_chats_analytics_2099);

Set vConcatenate = Concatenate;

next FoundFile

next FileExtension

for each SubDirectory in dirlist( Root & '\*' )

call ScanFolder(SubDirectory)

next SubDirectory

end sub

Call ScanFolder('\\FPSERVER\Company\Shared\Household\CALL CENTRE STATS\Webchat Dashboard') ;

store WebChat into (qvd);

Thanks and Regards,

Vinod.

Re: While running the job in QMC it throwing error Cannot open file.

simospa — Thu, 06 Sep 2018 15:04:45 GMT

Hi,

did you try with an Excel filename without blanks/spaces?

Re: While running the job in QMC it throwing error Cannot open file.

michelknecht — Thu, 06 Sep 2018 15:07:42 GMT

Does the service user for your QV-Services on the server has access to this shared folder?

When you're using the QlikView Client to execute your Script, it is executed as the user you're logged in. When you're starting the task in QMC, the service user executes the script.

Maybe you have to adjust the security of the shared folder '\\FPSERVER\Company\Shared\Household\TL - Performance\'.

Re: While running the job in QMC it throwing error Cannot open file.

marcus_sommer — Thu, 06 Sep 2018 15:35:50 GMT

Make sure that the user with which the qmc runs has access rights to these files.

- Marcus

Re: While running the job in QMC it throwing error Cannot open file.

vinod22kv — Fri, 07 Sep 2018 08:42:56 GMT

I am the admin and i have access to all the files.

Re: While running the job in QMC it throwing error Cannot open file.

marcus_sommer — Fri, 07 Sep 2018 08:51:51 GMT

Does your user runs also also the qmc-services? More common is that they run with a generic admin-account and not with an user-account which has admin-rights.

- Marcus

Re: While running the job in QMC it throwing error Cannot open file.

Peter_Cammaert — Fri, 07 Sep 2018 09:15:11 GMT

In addition to what Marcus already stated, make sure that the Service Account that is running the QlikView Distribution Service has access to the network share that is listed in the error message. Remember that network shares have two sets of privileges: those for the share itself, and those for the underlying directory.

Since you're an admin, you can easily test this access problem by running QV Desktop as the Service Account on your server and performing a reload as the Service Account.

Re: While running the job in QMC it throwing error Cannot open file.

vinod22kv — Fri, 07 Sep 2018 14:09:29 GMT

yes i tried it but it is not working.

Re: While running the job in QMC it throwing error Cannot open file.

vinod22kv — Fri, 07 Sep 2018 14:11:46 GMT

If it is security problem how multiple files are loading. and can you please confirm how to check the security of the shared folder

Re: While running the job in QMC it throwing error Cannot open file.

vinod22kv — Fri, 07 Sep 2018 14:21:12 GMT

Can you please advise how to test that Please.....

Re: While running the job in QMC it throwing error Cannot open file.

michelknecht — Fri, 07 Sep 2018 14:26:50 GMT

First, check the properties of the shared folder. In your case, i guess the folder is ...\Company\... somewhere on the Server FPSERVER. In my case, the User SRV*** is running the QlikView-Services on the QlikView-Server and has access to the folder SETUP, due to the permission level of the owner. A read permission would already do this job. Make sure this also applies on subfolders.

Secondly, check the security on the file itself. It needs the right to read the file. In my case, SRV*** has full access to the used file.