Error running Report on QVS 9.0 SR7

[#1]

Hi everyone.

I have a strange issue on a document. If I run reports from my QV Developer locally, everything seems to work fine.

If I deploy to a QV Server (Workgroup) SR7 and try to print a report the behaviour is erratic at best:

• usually, the QlikView plugin crashes (so does Internet Explorer)
• sometimes, the report is processed correctly, but the printer (physical printer or virtual PDFCreator) throws an error
• if run from Explorer local in the QV server, crashes
• if run from QV Developer in the server, works as expected

Version SR4 threw "Internal Dependency, Type C" errors.

Now I don't see errors in the server's event viewer anymore, but the erroneous behaviour is still the same.

Could someone help me, please?

[stephencredmond]

Hi,

Quick question - just one report or all reports?

How about with the AJAX client?  (Forces QVS to generate the report in PDF).

Regards,

Stephen

[danielrozental]

Have you upgraded the client's plugin version as well?

[#4]

Thanks Stephen. From the Ajax Client, I receive a "Lost Connection to Server" message.

With SR4, this was associated to an error event in the Server's Windows event log. Now I don't get the event, but the misbehaviour is the same.

I have 3 reports in the document. Every one gives the same problem.

@Daniel: unfortunately, yes.

I would add that the behaviour is the same from at least 4 distinct client computers. Seems the server doesn't handle the report generation.

I already exported the document structure and reimported it in a new doc, just to check if recreating the report would suffice.

[#5]

Anyone has an idea? Even a suggestion for "debugging" what's going on would suffice.

Thank you!

[stephencredmond]

Very little in the way of debugging, I believe.

If you create a very simple QVW with one very simple report, does it work?

Presume that the print spooler service is running OK?  Have you tried re-installing the PDF driver?

Stephen

[#7]

I'll try to reinstall the component (how do I do it?).

One strange thing is that the report(s) seems to work if I run them using my dev laptop as client and do not work if run from other clients (even if using Ajax ZFC).

Many thanks for the advice!

Everything that comes to mind would be helpful... Thank you.

Alberto

[stephencredmond]

On the QlikView download site, there is a "QlikView PDF Writer" option - chose the v9 one.  This is the installer for the correct PDF writer.

Note that you can open a simple wordpad document on your server and try and print to this driver and see if it produces a PDF.

The report will run on your local desktop client, even as a server client, because it is generated still on your desktop, not on the server-side.

Stephen

[#9]

Many thanks

Maybe I found some info that could be of use!

Analyzing log files I found that the problem SEEMS to be related to CAL allocation.

An excert of the Events log:

Server Started    Timestamp    SeverityID    EventID    Severity    Message

2011-05-30 18:31:19    2011-06-01 09:42:56    4    504    Information    Ticket created: Ticket for DOMAIN\USER1.

2011-05-30 18:31:19    2011-06-01 09:42:57    4    504    Information    Ticket Lookup: Ticket 5E70115C1CFC0B040D482FFDCB6275A8ABA42461 was found.

2011-05-30 18:31:19    2011-06-01 09:42:57    4    504    Information    DOC loading: Beginning load of document E:\QLIKVIEWROOTFOLDER\POF\PROJANALYSIS.QVW.

2011-05-30 18:31:19    2011-06-01 09:42:57    4    500    Information    Debug: Opening file E:\QLIKVIEWROOTFOLDER\POF\PROJANALYSIS.QVW on disk

2011-05-30 18:31:19    2011-06-01 09:42:59    4    500    Information    Debug: File E:\QLIKVIEWROOTFOLDER\POF\PROJANALYSIS.QVW opened OK

2011-05-30 18:31:19    2011-06-01 09:42:59    4    108    Information    The document E:\QLIKVIEWROOTFOLDER\POF\PROJANALYSIS.QVW was loaded.

2011-05-30 18:31:19    2011-06-01 09:43:00    4    504    Information    CAL allocation: No Named CAL assigned to user "DOMAIN\USER1" - usage denied.

2011-05-30 18:31:19    2011-06-01 09:43:00    4    504    Information    CAL usage: Named CAL "DOMAIN\USER1" now used - ok.

2011-05-30 18:31:19    2011-06-01 09:43:00    4    504    Information    CAL allocation: No Named CAL assigned to user "DOMAIN\USER1" - usage denied.

2011-05-30 18:31:19    2011-06-01 10:13:15    4    504    Information    Session stop reason: Session expired after idle time

2011-05-30 18:31:19    2011-06-01 14:00:24    4    504    Information    CAL allocation: No Named CAL assigned to user "DOMAIN\USER2" - usage denied.

2011-05-30 18:31:19    2011-06-01 14:00:34    4    504    Information    Ticket created: Ticket for DOMAIN\USER2.

2011-05-30 18:31:19    2011-06-01 14:00:36    4    504    Information    Ticket Lookup: Ticket 179AA0A61444A52FAE24691079E461EA4650E31D was found.

...

2011-05-30 18:31:19    2011-06-06 10:47:18    4    504    Information    Ticket created: Ticket for DOMAIN\USER3.

2011-05-30 18:31:19    2011-06-06 10:47:18    4    504    Information    Ticket Lookup: Ticket EA12BE01902720F953898EAF1422BBCED1CD5C3A was found.

2011-05-30 18:31:19    2011-06-06 10:47:19    4    504    Information    CAL allocation: No Named CAL assigned to user "DOMAIN\USER3" - usage denied.

2011-05-30 18:31:19    2011-06-06 10:47:19    4    504    Information    CAL usage: Named CAL "DOMAIN\USER3" already in use (2 time) on same client - ok.

2011-05-30 18:31:19    2011-06-06 10:52:25    4    504    Information    Session stop reason: Session expired after idle time

It seems that, sometimes (not always), a CAL is found, sometimes not. And it seems the issue is evident only when opening a report. My guess is that invoking the report execution opens a new connection with the QlikView Server and this operation is prone to fail.

Any suggestion on what to check in order to setup correctly CAL usage? Or about additional checks in order to track the issue?

Many, many thanks to everyone in advance!

Alberto

[stephencredmond]

Hi Alberto,

I am not so sure that this is the issue because directly after the "usage denied" message, you get a message about the CAL being used on the same client and an "ok".

I would recommend now that you should raise it with QlikView support and give them all your logs.

Regards,

Stephen