topic Re: Server error in QlikView

Server error

bbi_mba_76 — Tue, 10 Dec 2013 14:22:49 GMT

Hi,

in the events log file I found several error: could you help me to understand why there are those errors?

2013-12-10 05:00:29 2013-12-10 14:15:03 4 100 Notice License: License leased to user ZZZ

2013-12-10 05:00:29 2013-12-10 14:19:49 1 300 Error Server: An exception (T) occured during open of RRRR.

2013-12-10 05:00:29 2013-12-10 14:19:49 2 500 Warning Document Load: The document PPPP\RRRR failed to load because of no access [15].

2013-12-10 05:00:29 2013-12-10 14:20:09 1 300 Error Server: An exception (T) occured during open of RRRR.

2013-12-10 05:00:29 2013-12-10 14:20:09 2 500 Warning Document Load: The document PPPP\RRRR failed to load because of no access [15].

2013-12-10 05:00:29 2013-12-10 14:20:13 1 300 Error Server: An exception (T) occured during open of RRRR.

2013-12-10 05:00:29 2013-12-10 14:20:13 2 500 Warning Document Load: The document PPPP\RRRR failed to load because of no access [15].

2013-12-10 05:00:29 2013-12-10 14:20:15 4 100 Notice CAL usage: Using CAL of type "Named User" for user "XXX". Named user cals in use: 1

2013-12-10 05:00:29 2013-12-10 14:20:15 4 100 Notice License: License leased to user XXX

2013-12-10 05:00:29 2013-12-10 14:25:16 4 100 Notice CAL usage: Named CAL session for user "XXX" stopped

2013-12-10 05:00:29 2013-12-10 14:30:13 4 100 Notice CAL usage: Document CAL session for user "YYY" stopped

2013-12-10 05:00:29 2013-12-10 14:35:31 4 100 Notice CAL usage: Using CAL of type "Named User" for user "ZZZ". Named user cals in use: 1

2013-12-10 05:00:29 2013-12-10 14:38:25 4 100 Notice CAL usage: Using CAL of type "Named User" for user "ZZZ". Named user cals in use: 1

2013-12-10 05:00:29 2013-12-10 14:38:25 4 100 Notice CAL usage: Named CAL session for user "ZZZ" stopped

2013-12-10 05:00:29 2013-12-10 14:38:25 4 100 Notice License: License leased to user ZZZ

2013-12-10 05:00:29 2013-12-10 14:44:35 1 300 Error qvpx: Exception while handling request

2013-12-10 05:00:29 2013-12-10 14:44:39 1 300 Error qvpx: Exception while handling request

Re: Server error

Anonymous — Tue, 10 Dec 2013 14:46:33 GMT

Hello,

you have SECTION ACCESS in the script

Re: Server error

bbi_mba_76 — Tue, 10 Dec 2013 15:01:31 GMT

Yes there is section access in the scripts, but why the error?

Users are giving bad credentials?

Re: Re: Server error

Anonymous — Tue, 10 Dec 2013 15:50:01 GMT

During the programmation in the server is necessary that you add the credentials SECTION ACCESS

Re: Server error

bbi_mba_76 — Tue, 10 Dec 2013 16:03:46 GMT

I use a batch to reload the qvw. The errors are during the user navigation, using the browser, not in the reload.

Re: Server error

Bill_Britt — Tue, 10 Dec 2013 17:09:52 GMT

Are the users using AJAX or Plugin? If it is the plugin, I would look at the session log and see what version of the plugin they are using. I bet you will find some old versions.

Bill

Re: Server error

bbi_mba_76 — Wed, 11 Dec 2013 09:25:32 GMT

You are right, the user are using the version 11440 and not the 12129.

I'll ask to upgrade the plugin to the new version and then I'll tell you if this solve the issue.

Thanks

Re: Server error

bbi_mba_76 — Tue, 11 Feb 2014 08:53:27 GMT

I contacted the Support, in our section access there are two tables: a temporary table(dropped at the end of the section access) and the a final one

We have to join/concatenate to have only one table.