Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Use to open qvd the file button in script screen, ¿are you using relative o full patch? check that.
I hope to help you.
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
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.
Hi,
Are you using some spaces in the Detail*.qvd files? If so, remove them or wrap the path into square brackets:
FROM
Does you user or the user that runs QlikView have permissions enough as to read and write files in that folder?
Miguel
I have the following statements. could this be the problem. Can we have two load statements ?
DETAIL:
LOAD
DETL_ID,
DETL_DESC
FROM
SUMMARY:
LOAD
EX_SUMM_ID,
EX_SUMM_TYPE
FROM
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.