Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,039 members
  • 6,767 online
  • 1,997,760 posts
  • 149,770 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    Log full of Invalid license error, but everything working correctly

    Hello, i have a strange behaviour on my QlikSense, on premise, installation: everything is working fine, in QMC i have no error on licence, even if i ... Show More

    Hello,

    i have a strange behaviour on my QlikSense, on premise, installation: everything is working fine, in QMC i have no error on licence, even if i reload information from web, the analyzer and professional and user can log and work.

     

    However i have a constant error in the log located in: ProgramData\Qlik\Sense\Log\Licenses

    Around every ten seconds it report this couple of line

    {"caller":"handler.go:53","errorMessage":"invalid license error, no license found, tenant not found","errorType":"LICENSES-ForbiddenRequest","level":"info","logTraceId":"7003c215e34da346b906beed9bcdb019","statusCode":403,"timestamp":"2024-05-09T09:37:40.8800623Z"}
    {"audience":"","caller":"middleware.go:114","level":"info","license":"","logTraceId":"7003c215e34da346b906beed9bcdb019","message":"http request","name":"V1LicensesDefinitionGet","req.method":"GET","req.url":"/v1/licenses/definition?privileges=true&xrfkey=GFycs5f2YXBS8w15","res.statusCode":"403","subType":"","tenant":"","timestamp":"2024-05-09T09:37:40.8806126Z","userAgent":"nl-app-search"}

     

    Do you have any idea how to fix this?

    For context: Windows firewall is disable and the server, at the moment, reach everything on the net, included http://license.qlikcloud.com/

     

    Thanks a lot

     

    The version is the latest Qlik Sense February 2024 Patch 3 - 14.173.6

     

    Show Less
  • forum

    Deployment & Management

    Hub in HTTP not working on Edge and Chrom, fine on Firefox

    Hello, we currently have an old installation of QlikSense 2019 that works fine, but we decided to upgrade and deploy a new installation with the most ... Show More

    Hello,

    we currently have an old installation of QlikSense 2019 that works fine, but we decided to upgrade and deploy a new installation with the most recent version : QlikSense 2024 February Patch 3 14.173.6

    Everything works fine when we use HTTPS , but for internal reasons we have to allow HTTP connection.

    Unfortunately, the HTTP works perfectly fine in Firefox, but does not work in Edge and Chrome: in both browsers, the hub loads , apparently in a correct way, but after a second it gives a Connection closed error and keeps reloading indefinetely showing the error every time.

    Do you have any idea how this could be fixed?

     

    Thanks a lot

    Show Less
  • forum

    Deployment & Management

    QlikSense Change Qlik Logo on Error Page

    Hi everyone Due to security requirements, we need to change the Qlik logo on QlikSense when a user hits an error, such as error 400 or Error 404. We n... Show More

    Hi everyone

    Due to security requirements, we need to change the Qlik logo on QlikSense when a user hits an error, such as error 400 or Error 404. We need to remove or change only the logo so that the application is unidentifiable. Could someone point to a direction I can take to accomplish this?

    Show Less
  • forum

    Deployment & Management

    Automatically Update Qliksenserepository password

    In the following link  https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-in-Qlik-Sense/ta-p/1712725 ,... Show More

    In the following link 

    https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-in-Qlik-Sense/ta-p/1712725

    , we see instructions on how that password can be amended manually. However, if we wanted to automated this, would it be possible?
    More specifically, I am enquiring about this part within the QlikSenseUtil. Is it possible to do the same think via cmd line? 
    "Adjust the connection string using QlikSenseUtil
    Open QlikSenseUtil (C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil)
    Open the Connection String Editor tab
    Click Read
    Adjust the password
    Click Save Value in config file encrypted
    "
     

    Show Less
  • forum

    New to Qlik Analytics

    Qliksense Upgrade Steps

    How to upgrade Qliksense2022.02 to 2024.02 steps
  • forum

    Design and Development

    Exception in routine but the job exit as 0

    For example, let say i create a routine that will pretty print JSON on log package routines; import org.apache.log4j.*; import routines.system.JSONOb... Show More

    For example, let say i create a routine that will pretty print JSON on log

    package routines;
    
    import org.apache.log4j.*;
    import routines.system.JSONObject;
    
    public class PrettyPrintJSON {
      private static org.apache.log4j.Logger log = LogManager.getLogger(PrettyPrintJSON.class);
    
      public static void print(String jsonPayload, String description) {
        try {
          JSONObject json = new JSONObject(jsonPayload); // Convert text to object
          log.info(description + " JSON  : \n" + json.toString(4));
        } catch (Exception e) {
          e.printStackTrace();
        }
        return;
      }
    }

     

    So when I use this routine on Tjava or inside another routine that uses non JSON string

    String json ="sorry I not JSON man!";
    PrettyPrintJSON.print(json,"Wakanda create case payload");

     

    Seem the job still keep continue running and exit with status 0.

     

    I expecting it to stop or exits with status 1

    Show Less
  • forum

    Design and Development

    Talend Studio: Job hierarchy - How do I know if a Job is a Master Job?

    Hello everyone, How do I know if a Job is a "Master" Job, meaning it is not being called from any other Job?I'm using Talend Studio and I know there i... Show More

    Hello everyone,

    How do I know if a Job is a "Master" Job, meaning it is not being called from any other Job?
    I'm using Talend Studio and I know there is an option accessible by right-clicking on a Job to "Open Job Hierarchy". It shows the flow starting from that Job onwards. But it doesn't show if that particular Job is being called by another Job.
    So, my question is: how do I know if a Job I'm looking at is being called by another Job, thus being its child.

     

    Thank you so much.

    Rui
     

    Show Less
  • forum

    QlikView Integrations

    Task Schedular Does not recognize a running instance of Outlook

    I'm attempting to use the mSendMail() subroutine in VBScript to first check if Outlook is already running. If Outlook is running, the script will proc... Show More

    I'm attempting to use the mSendMail() subroutine in VBScript to first check if Outlook is already running. If Outlook is running, the script will proceed with sending the email using the existing instance of Outlook. Otherwise, it will start Outlook before sending the email.

    The script works correctly when executed manually in the QlikView macro editor. However, when I attempted to run it from the Task Scheduler, it did not recognize the already running instance of Outlook. Instead, it opened another instance and could not send the email.

    I expected the Task Scheduler to recognize the running instance of Outlook.

    Below is the code:

    Sub mSendMail(pdfFilePath)
    Dim objOutlk
    Dim objMail
    Const olMailItem = 0

    ' Check if Outlook is already running
    On Error Resume Next
    Set objOutlk = GetObject(, "Outlook.Application")
    On Error GoTo 0

    ' If Outlook is not running, start it
    If (objOutlk = "") Then
    StartOutlook
    ' Wait for Outlook to start
    ActiveDocument.GetApplication.Sleep 5000 ' Wait for 5 seconds for Outlook to start
    ' Create a new instance of Outlook application
    Set objOutlk = CreateObject("Outlook.Application")
    End If

    ' Create a new mail item
    Set objMail = objOutlk.createitem(olMailItem)

    ' Recipient's email address
    objMail.To = "example@yahoo.com"

    ' Subject of the email
    objMail.Subject = "Testing " & Date()

    ' Body of the email
    objMail.HTMLBody = "Body of the email, This is an automatic generated email from QlikView."

    ' Add attachment (use the generated PDF file)
    objMail.Attachments.Add pdfFilePath

    ' Send the email
    objMail.Send

    ' Release resources
    Set objMail = Nothing
    Set objOutlk = Nothing
    End Sub

    Sub StartOutlook()
    Dim oShell
    Set oShell = CreateObject("Wscript.Shell")
    oShell.Run "cmd.exe /K ""C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE"" ", 0, False
    End Sub

    Please, what can I do?

    Show Less
  • forum

    Integration, Extension & APIs

    Embedded Sheets Qlik on Web Site

    Hello, Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error mess... Show More

    Hello,

    Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"

    Is there any setting to set up?

    In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.

    Show Less
  • forum

    New to Qlik Analytics

    Duplicates

    Hi, I have data like this and when we do the calculation like below it ends up with duplicates. if(num([cal date])-num(today())>0 and confirmed='N',1,... Show More

    Hi,

    I have data like this and when we do the calculation like below it ends up with duplicates.

    if(num([cal date])-num(today())>0 and confirmed='N',1,0) as "Review Eve"

    expression: sum("Review Eve") gives duplicates

     

    ref cal date major code minor code review quoted amt agreed amt confirmed today()
    00ACCL27 01-04-2016 200 100 Initial Rent   177947.88 Y 09-05-2024
    00ACCL27 01-04-2016 200 130 Initial Rent   14351.93 Y 09-05-2024
    00ACCL27 01-01-2017 200 100 Rent Review   177948 Y 09-05-2024
    00ACCL27 01-01-2017 200 130 Rent Review   14352 Y 09-05-2024
    00ACCL27 01-04-2019 200 100 Rent Review 177947.88 177947.88 Y 09-05-2024
    00ACCL27 01-04-2019 200 130 Rent Review 14351.93 14351.93 Y 09-05-2024
    00ACCL27 01-04-2022 200 100 Rent Review 177947.88 177947.88 Y 09-05-2024
    00ACCL27 01-04-2022 200 130 Rent Review 14351.93 14351.93 Y 09-05-2024
    00ACCL27 01-04-2025 200 100 Rent Review 177947.88 0 N 09-05-2024
    00ACCL27 01-04-2025 200 130 Rent Review 14351.93 0 N 09-05-2024
    00ACCL27 01-04-2028 200 100 Rent Review 177947.88 0 N 09-05-2024
    00ACCL27 01-04-2028 200 130 Rent Review 14351.93 0 N

    09-05-2024

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!