topic Re: Error: Cannot open file 'file.xls' The system cannot find the path specified in QlikView

Error: Cannot open file 'file.xls' The system cannot find the path specified

Tue, 03 May 2016 16:49:20 GMT

I created a QlikView file where you need to read a Excel file. This file is shared to a folder. When I work with a QlikView Client I don't have a problem. When I schedule the Qlik file with a Qlik Console does not work.

This is the script:

Directory S:\Report\Qlik\File_Appoggio;

BUDGET:

NoConcatenate

LOAD Anno_Budget_1 *100+Mese_Budget_2016 AS ANNO_MESE,

Anno_Budget_1,

Cod_Cliente_1 AS KeyCodiceCliente,

Ragione_Sociale_1,

Mese_Budget_2016,

NUM (Valore_Budget_2016,'#.##0') AS Valore_Budget

FROM

(biff, embedded labels, table is BUDGET$);

This is the log with error:

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0773 Directory S:\Report\Qlik\File_Appoggio

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0774 BUDGET:

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0775 NoConcatenate

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0776 LOAD Anno_Budget_1 *100+Mese_Budget_2016 | | | AS ANNO_MESE,

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0777 Anno_Budget_1,

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0778 Cod_Cliente_1 AS KeyCodiceCliente,

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0779 Ragione_Sociale_1,

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0780 Mese_Budget_2016,

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0781 NUM (Valore_Budget_2016,'#.##0') | | AS | Valore_Budget

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0782 FROM

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0783

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: 0784 (biff, embedded labels, table is BUDGET$)

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: Error: Cannot open file 'S:\Report\Qlik\File_Appoggio\BUDGET.xls' The system cannot find the path specified.

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: General Script Error

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: Execution Failed

03/05/2016 18:18:47.2013124 Information 03/05/2016 18:18:47: Execution finished.

The QMC server have all privileges for this folder

Thank you in advance

Paolo

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

trdandamudi — Tue, 03 May 2016 17:31:58 GMT

It is because you are using mapped drive.

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Wed, 04 May 2016 07:01:24 GMT

Hi,

I changed the script; now I have a different error message; logon failure because unknown user name or bad password

This the script:

Directory S:\Report\Qlik\File_Appoggio;

BUDGET:

NoConcatenate

LOAD Anno_Budget_1 *100+Mese_Budget_2016 AS ANNO_MESE,

Anno_Budget_1,

Cod_Cliente_1 AS KeyCodiceCliente,

Ragione_Sociale_1,

Mese_Budget_2016,

NUM (Valore_Budget_2016,'#.##0') AS Valore_Budget

FROM

[\\192.168.0.7\dfs\Report\Qlik\File_Appoggio\BUDGET.xls]

(biff, embedded labels, table is BUDGET$);

This is the log:

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0773 Directory S:\Report\Qlik\File_Appoggio

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0774 BUDGET:

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0775 NoConcatenate

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0776 LOAD Anno_Budget_1 *100+Mese_Budget_2016 | | | AS ANNO_MESE,

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0777 Anno_Budget_1,

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0778 Cod_Cliente_1 AS KeyCodiceCliente,

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0779 Ragione_Sociale_1,

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0780 Mese_Budget_2016,

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0781 NUM (Valore_Budget_2016,'#.##0') | | AS | Valore_Budget

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0782 FROM

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0783 [\\192.168.0.7\dfs\Report\Qlik\File_Appoggio\BUDGET.xls]

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: 0784 (biff, embedded labels, table is BUDGET$)

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: Error: Cannot open file '\\192.168.0.7\dfs\Report\Qlik\File_Appoggio\BUDGET.xls' Logon failure: unknown user name or bad password.

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: General Script Error

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: Execution Failed

04/05/2016 08:24:58.6257171 Information 04/05/2016 08:24:58: Execution finished.

Thank you in advance

Paolo

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

marcus_sommer — Wed, 04 May 2016 10:58:17 GMT

You will need a unc-path for this like:

\\YourServerNameOrIP\S\Report\Qlik\File_Appoggio\BUDGET.xls

and this drive must be accessable from the qlikviewserver and for the user which runs the qmc.

- Marcus

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

trdandamudi — Wed, 04 May 2016 12:30:42 GMT

Are you running this on Desktop version ? Also is the excel is password protected ?

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Clever_Anjos — Wed, 04 May 2016 14:45:36 GMT

Which user your services use to run? Do they have permissions to connect to that drive?

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Thu, 05 May 2016 07:53:12 GMT

Hi Clever,

user is the domain administrator and have the permissions for this drive

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Thu, 05 May 2016 07:55:46 GMT

Hi Marcus

The drive is accessable from the qlikviewserver and the user is the domain administrator.

The domain administrator have a permission for this drive

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Thu, 05 May 2016 08:00:13 GMT

Hi Thirumala,

yes running with Desktop version 11.20, but with QlikView Console, doesn't function. No password in Excel file

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Clever_Anjos — Thu, 05 May 2016 17:11:08 GMT

Try logging using that user and check if you can access that drive

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

jakob_rasmussen — Wed, 10 Aug 2016 12:24:58 GMT

Hi Paolo,

Did you ever find a solution to this issue?

/Jakob

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

Mon, 22 Aug 2016 13:09:33 GMT

Hi Jakob,

No solution for this issue;

I created a folder on the Qlik server

Paolo

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

spividori — Mon, 22 Aug 2016 13:48:11 GMT

Hi.

I had the same problem and solved it with "c$":

[\\192.168.0.7\c$\Report\Qlik\File_Appoggio\BUDGET.xls]

Regards.

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

jakob_rasmussen — Wed, 24 Aug 2016 10:31:06 GMT

That solution didn't work in our case. Everything worked fine from the QlikView server using QlikView Desktop and same user that us running the QlikView services. But when trying to reload from QMC it failed.

We ended up moving the source files in question to another file share. It's 99% a Windows access thing, but exactly what is causing the difference between the same user running the same file through QV Desktop and QMC, I cannot tell.

Re: Error: Cannot open file 'file.xls' The system cannot find the path specified

marcus_sommer — Wed, 24 Aug 2016 12:29:28 GMT

I think the differences is that in the first case these user is logged in and in the second case no user is logged in and the qmc runs as a background-service and not as a "normal" program and this caused any small differences by the access respectively security rights (and I think you will need a very experienced windows admin to find those differences and solve them).

- Marcus