Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Include statement on a shared drive not working

I recently migrated to a new machine and am having some problems that I can't seem to troubleshoot. My QV app's load script has an include statement that grabs a script from a network drive. However, it doesn't seem to be able to actually READ the file.

I changed it over to a Must_Include statement to get better error handling--the load process doesn't throw an error so I know it's finding the script. However, nothing appears in the loading box (when I should get logs of everything being loaded) nor do I end up with any data at all in my script.

Bizarrely, if I move the script to my desktop and point the include statement at that, it seems to work fine.

I've edited the script down, for debugging purposes to just a single inline table, thinking maybe I had typos somewhere, but still can't solve the problem.

Any suggestions about ways to debug this?

My load script looks like this:

 $(Must_Include=g:\alumni\jake t\datawarehouse\test-script2.qvs);

And the contents of test-script2.qvs are:

goals:
     LOAD * INLINE [
         goal_tmu,goal_uc, goal_td, goal_ess_overall, goal_ess, goal_turf, goal_builinfra, goal_facdev, goal_projconf, goal_schol, goal_af_tmutotal, goal_af_yearly, goal_af_urest, goal_bbc, goal_cfa,goal_af_dnr_ALUM, goal_af_dnr_ESTATE, goal_af_dnr_FACULTY, goal_af_dnr_FOUNDATION, goal_af_dnr_ORG, goal_af_dnr_OTHER, goal_af_dnr_PARENT, goal_af_dnr_STUDENT, goal_af_dnr_TRUSTEE, goal_af_dnr_PAST_TRUSTEE
         85000000,27200000, 15500000, 16000000, 13000000, 3000000, 2000000, 2300000, 1000000, 10000000, 11000000, 2400000, 1400000,100000,30000,500000, 100000, 25000, 450000, 250000, 85000, 40000, 0, 340000, 145000
         ];

Any guesses?

9 Replies
Not applicable
Author

Bumping this to see if anybody has any suggestions. I tried moving the script to g:\alumni\test-script2.qvs in hopes that the problem was the space in the "jake t" directory....still nothing.

Any guesses?

agomes1971
Specialist II
Specialist II

Hi,

security/permissions to read the file?

HTH

André Gomes

Not applicable
Author

I can open/access the file just fine outside QV. And if I use a Must_Include statement, I don't get an error, so it seems to be loading, but not actually reading the script, somehow?

vishsaggi
Champion III
Champion III

Shared drives must be always start with like below something like that try this:

$(Must_Include=\\Shareddrivename\s$ \alumni\jake t\datawarehouse\test-script2.qvs);

Not applicable
Author

This seems like it might be right.Here's the documentation that talks about pointing to shared files within Qlikview.

I changed the link to use a UNC style address instead. Unfortunately, I'm getting the same behavior as before: Must_Include doesn't bomb out, but no data gets loaded.

Not applicable
Author

PS. I have a coworker, who's still on QV v11, for whom it works just fine.

Not applicable
Author

Just FYI, I'm in talks w/ Qlik support about this. There's some serious weirdness going on where QV12 isn't reading the file correctly.

Not applicable
Author

Got the final word on this: it's a bug in Qlikview. It is NOT slated to be fixed. So I'm out of luck.

vishsaggi
Champion III
Champion III

Oh thanks for the info.