topic Re: Loading Error in QlikView

Loading Error

Wed, 27 Jan 2016 18:09:45 GMT

Error: Bad call to OpenFileOrURL: "\INLB157.tmp" and DefaultDir was empty !

Wonder if anyone has encountered this error before.

Happened during reload from Server;

reloading manually works ok.

Michael

Re: Loading Error

marcus_sommer — Thu, 28 Jan 2016 15:24:22 GMT

It sounds very to an access- and/or right-issue which meant that the path to the file is invalid fron the server point of view and/or the user which runs the server has no access-rights to these folder and/or file.

- Marcus

Re: Loading Error

alexpanjhc — Thu, 28 Jan 2016 15:38:03 GMT

Can you use the ID which run the QV services to run this QVW. Can you run other QVWs in the server?

Re: Loading Error

Fri, 29 Jan 2016 19:42:47 GMT

It happens to my inline table. It was not a problem before. I can still reload from my local developer end. But when try to Reload from server this error happens. Wonder if this is a bug for v12.00

Re: Loading Error

marcus_sommer — Fri, 29 Jan 2016 23:59:28 GMT

Your manually load is also with qv 12? How looked these inline-statement?

- Marcus

Re: Loading Error

Sat, 30 Jan 2016 00:01:24 GMT

No, My manually load is with QV 11.20 SR12

The Inline-Statement are exactly the same.

Re: Loading Error

marcus_sommer — Sun, 31 Jan 2016 07:45:57 GMT

Maybe the best will be to move these posting to QlikBug with a few more details, like releases, script, logfiles and so on.

- Marcus

Re: Loading Error

mataylesbury — Wed, 23 Mar 2016 15:28:43 GMT

Hi, Does anyone have any further updates on this? any workaround? We have one user currently experiencing this issue since upgrading to QV12. Other users are fine on the same server.

Re: Loading Error

gonzaloruizgonz — Fri, 03 Jun 2016 11:25:16 GMT

I have the same problem in 12:00 sr2, have someone found the cause of this issue?

//Gonza

Re: Loading Error

henrikalmen — Tue, 30 Aug 2016 14:06:04 GMT

I have almost the same very frustrating problem! I have upgraded our QlikView server from version 11 to version 12 SR 5 (12.0.20400.0) today. I create a new qvw file and create nothing but this simple script:

my_table: LOAD * INLINE [

ID, Value

1, A

2, B

];

When trying to reload in the Desktop Client on the server machine I get this error message:

Bad call to OpenFileOrURL: "\INL6A7E.tmp" and DefaultDir was empty !

If I run the QlikView desktop client on another computer the same qvw reloads fine, but not when I run it in the desktop client on the server machine. Log file for the qvw doesn't give any more information than this, it states the error mentioned and then on the next line "Execution finished." I tried moving the qvw to various locations, for example C:\ProgramData\QlikTech\Documents but no difference.

But it is only in the desktop client on the server machine that it does not work. If I move the qvw to a directory that is available from QV Access Point I can trigger reload in QVMC and it works! But it still doesn't work if I open the qvw in desktop client from that location.

The logged in user has full access to root on the available drives, otherwise that could have been the problem according to https://community.qlik.com/thread/84331#356807‌ where a similar (but not identical) issue was discussed.

So for me, a qvw with an inline table can be reloaded in QVS or in desktop client on another machine, but not in desktop client on server machine. Right now I have no idea why...

Re: Loading Error

henrikalmen — Tue, 06 Sep 2016 09:44:01 GMT

With the help of QLik Support my problem is now solved, and your problem might have a similar solution.

The windows user executing the reload (in your case the user running the qlikview services) had faulty directories listed in windows registry under these nodes:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders

and

HKEY_USERS\[userid]\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

In my case some of the keys were pointed at nonexisting network drives. That has obviously not been a problem before we upgraded to QV12, nevertheless the solution to my problem was to point to existing folders. Qlik Support also mentioned that they have seen similar problems when such keys point to network shares even when those folders exist, and in that case the solution would be to point at directories on the local hard drive.

During my attempts to solve this I found similar shell folder keys in other places in the registry, so If you don't find errors under these exakt places in your registry you might find them somewhere similar in the registry.