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

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

Clever_Anjos — Tue, 03 May 2016 17:29:38 GMT

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

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

Wed, 04 May 2016 06:50:17 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

avinashelite — Wed, 04 May 2016 07:02:43 GMT

This a answer or question for the community

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

Wed, 04 May 2016 07:05:35 GMT

This is a question

Thanks

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

sunny_talwar — Wed, 04 May 2016 07:47:06 GMT

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

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

avinashelite — Wed, 04 May 2016 07:52:21 GMT

Oh I was not aware of this

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

Clever_Anjos — Wed, 04 May 2016 14:49:32 GMT

Weird thing

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

Anonymous — Wed, 04 May 2016 15:21:58 GMT

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

Best,

Qlik Community Team

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

joydevdawn — Wed, 04 May 2016 15:31:46 GMT

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