Knowledge

Using IFrames to render QlikView mashups may result in two sessions being consumed and two usage CALs used if .htm file is not correct

Article Number: 000048426 | Last Modified: 2018/09/07

Description

A customer was testing a very simple mashup that displays one visual. When accessing the mashup, there are two sessions being consumed in the QlikView logs and two GetWebTicket requests in the Webserver log. In addition, if using Usage CALs, a customer may see two CALs being consumed when accessing the mashup.

This behavior, where multiple sessions are seen should not happen. A mashup showing a visual should have one GetWebTicket request, get assigned one type of CAL depending on what is available and see one session in the logs.

Resolution

We performaed a lot of testing and confirmed the behaviors in a vapp environment, limiting the license type and accessing the mashup using the same .htm file as the customer.
Jira issue QV-13566 "QlikView mashup call creates 2 sessions and consumes 2 Usage Cals" was created.

R&D concluded the document name inside the htm file must be exactly the same (including case) in the "view" parameter of the QV.Init.Workbench call and in the avqview parameter in the object.

Notice, the htm file content below. The qvw document names do not match: tiles-lcense_test and tiles-license_test.qvw

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>QlikView MultipleObject integration in HTML
</title>
<link rel="shortcut icon" type="image/x-icon" href="/QvAjaxZfc/htc/Images/favicon.ico" />
<link rel="stylesheet" type="text/css" media="screen" href="/QvAjaxZfc/htc/default.css" />
   <script type="text/javascript" src="/QvAjaxZfc/htc/QvAjax.js"></script>
   <script type="text/javascript">
Qv.InitWorkBench({
View: 'tiles-license_test',
Host: null
});
   </script>
   <style>
       .QvInlineObject
       {
           position:relative;
           margin-left:0px;
           margin-right:0px;
           float:left;
       }
   </style>
</head>
<body>
   <div class="QvFrame" avqview="tiles-license_test.qvw" avq="object:.Document\TX89" id="Document\TX89" style="margin-left:0px;left:0px;width:200px;height:150px;top:0px;">
</div>
   
</body>
</html>

Once the mismatch was corrected (by making sure both file names had the qvw extension in the htm file) the mashup was retested. The number of sessions, GetWebTicket calls, Usage Cals all showed only one each.

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us

Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case

Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.

Call Us