topic Include statement on a shared drive not working in QlikView

Include statement on a shared drive not working

Tue, 02 Aug 2016 15:32:51 GMT

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?

Re: Include statement on a shared drive not working

Thu, 25 Aug 2016 14:57:50 GMT

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?

Re: Include statement on a shared drive not working

agomes1971 — Thu, 25 Aug 2016 17:02:59 GMT

Hi,

security/permissions to read the file?

HTH

André Gomes

Re: Include statement on a shared drive not working

Thu, 25 Aug 2016 18:25:41 GMT

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?

Re: Include statement on a shared drive not working

vishsaggi — Thu, 25 Aug 2016 19:06:57 GMT

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);

Re: Include statement on a shared drive not working

Thu, 25 Aug 2016 19:24:56 GMT

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.

Re: Include statement on a shared drive not working

Thu, 25 Aug 2016 19:36:48 GMT

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

Re: Include statement on a shared drive not working

Fri, 23 Sep 2016 13:18:06 GMT

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.

Re: Include statement on a shared drive not working

Tue, 03 Jan 2017 21:06:09 GMT

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.

Re: Include statement on a shared drive not working

vishsaggi — Tue, 03 Jan 2017 21:28:55 GMT

Oh thanks for the info.