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

[jakob_rasmussen]

Hi Paolo,

Did you ever find a solution to this issue?

/Jakob

[#3]

Hi Jakob,

No solution for this issue;

I created a folder on the Qlik server

Paolo

[spividori]

Hi.

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

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

Regards.

[jakob_rasmussen]

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.

[marcus_sommer]

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