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

[#1]

Hi

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

[trdandamudi]

It is because you are using mapped drive.

[#3]

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

[marcus_sommer]

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

[trdandamudi]

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

[Clever_Anjos]

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

[#7]

Hi Clever,

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

[#8]

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

[#9]

Hi Thirumala,

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

[Clever_Anjos]

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