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

[Clever_Anjos]

Maybe because you are using a mapped drive.

This drive is not accessible using the user that runs your Qlik Services.

Try using the UNC:

\\[ServerIP or Servername\Report\Qlik\File_Appoggio\BUDGET.xls

[#2]

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

[avinashelite]

This a answer or question for the community

[#4]

This is a question

Thanks

[sunny_talwar]

Happened to me before also. You can see at the top that it tells you that it is branched from an earlier discussion

[avinashelite]

Oh I was not aware of this

[Clever_Anjos]

Weird thing

[Anonymous]

Hi all, I've marked this discussion as a question.

Best,

Qlik Community Team

[joydevdawn]

Have you get access the folder (\\192.168.0.7\dfs\Report\Qlik\File_Appoggio)  ? Verify from your desktop.