topic Re: File not Found Error When File is actually there. in QlikView

File not Found Error When File is actually there.

Mon, 01 Oct 2012 15:30:49 GMT

I created a qvd file and I copied the path of the file from the explorer. I verfied it is correct. However, when I run the data model and load try to load the file, it gives me an error saying the file cannot be read and the file cannot be found. What could be the possible reason ? Pease advise.

Thanks.

Re: File not Found Error When File is actually there.

Mon, 01 Oct 2012 15:36:09 GMT

Use to open qvd the file button in script screen, ¿are you using relative o full patch? check that.

I hope to help you.

Re: File not Found Error When File is actually there.

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 15:37:19 GMT

Hi,

Log in as the account that runs QlikView, and make sure that there are no mapped drives such as "D:" or Z:" but UNC paths instead to shared folders, such as "\\SERVER\SharedResource\Folder".

Make sure that the file is readable and it is not locked by any other software i. e.: antivirus

Hope that helps.

Miguel

Re: File not Found Error When File is actually there.

Mon, 01 Oct 2012 15:44:19 GMT

No luck so far. Am I doing something wrong ? Seemingly simple problem!

DETAIL:

LOAD

DETL_ID,

DETL_DESC

FROM

C:\Dashboards\Data\Detail*.qvd (qvd);

Error:

Cannot open file 'C:\Dashboards\Data\Detail*.qvd' The system cannot find the file specified.

But the qvd files are there and I can see the data if I open them in QV. Using QlikView 11 Desktop.

Thanks.

Re: File not Found Error When File is actually there.

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 15:47:31 GMT

Hi,

Are you using some spaces in the Detail*.qvd files? If so, remove them or wrap the path into square brackets:

FROM

(qvd);

Does you user or the user that runs QlikView have permissions enough as to read and write files in that folder?

Miguel

Re: File not Found Error When File is actually there.

Mon, 01 Oct 2012 16:08:42 GMT

I have the following statements. could this be the problem. Can we have two load statements ?

DETAIL:

LOAD

DETL_ID,

DETL_DESC

FROM

(qvd);

SUMMARY:

LOAD

EX_SUMM_ID,

EX_SUMM_TYPE

FROM

(qvd);

Re: File not Found Error When File is actually there.

Mon, 01 Oct 2012 16:12:41 GMT

Thank you for extending quick help. I figured it out. When I changed the field names in the Data model to uppercase, it is working.

Thanks.