Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,400 members
  • 3,946 online
  • 1,991,777 posts
  • 149,214 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    QlikView App Dev

    tRESTClient

    Where can i download tRESTClient Jar to import?
  • forum

    Qlik Cloud Data Integration

    Post method in the tREST

    Hi Guys,I am trying to print the HTTP body in the tLogRow sending it through the tREST.How can I Print the REquest Body?
  • forum

    App Development

    Funnel Chart - Width vs Order Display

    Team, When working with Funnel chart, if option was order the values getting displayed properly in all parameters but in width option values not getti... Show More

    Team,

    When working with Funnel chart, if option was order the values getting displayed properly in all parameters but in width option values not getting displayed, but width Visualization was better for my requirement, any hint how to display the values. Highlighted the screen shot for reference.

    Farsana_0-1711721983336.png

     

    Thanks

    Farsana

    Show Less
  • forum

    New to Qlik Analytics

    Formation of a variable.

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we ... Show More

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we select a date and the other all the after data including the selected date data.

    I want all the data date wise, for example if we select today's date then all the data previous and all the data after it.

    Show Less
  • forum

    Connectivity & Data Prep

    Tasks failed as Error: Connection aborted (System error: The handle is invalid.)

    Hello experts, There are connectivity problems in our site, which occurs on TASK relods only as far as we experienced. Its both occurs on ODBC & Rest ... Show More

    Hello experts,

    There are connectivity problems in our site, which occurs on TASK relods only as far as we experienced. Its both occurs on ODBC & Rest connections.

    When i check script logs we get this error immidiately after "Lib Connect to xxx" statement.

    20240327T120257.655+0300 0023 LIB CONNECT TO 'SOME_ODBC_DB_Connection'
    20240327T120339.724+0300      Error: Connection aborted (System error: The handle is invalid.)
    20240327T120339.726+0300      Execution Failed
    20240327T120339.730+0300      Execution finished.

    the time from lib connect to statment and error differs from 30 to 150 seconds. 

    Btw <generatePublisherEvidence enabled="false"/> is set on all of our Qlik servers inside of <runtime> tag which is located on machine.config. We have to manually control the failed task list and manually send a re-start order to mitigate this, but its very exhausting effor to chase up a site with more than +2000 tasks. And this is still not a solution because sometimes its ends as a fail again, we always have to check if its finishes as success.

     

    Qlik Sense Version: Qlik Sense February 2023 Patch 6 | 14.113.9

    Show Less
  • forum

    App Development

    Jobs failing intermittently with General Script Error in Qliksense

    Hello,One job in Qliksense  failed with an error below:20210603T124122.213+0200 0015 LOAD *20210603T124122.213+0200 0016 SQL SELECT DISTINCT QVD_NAME ... Show More

    Hello,

    One job in Qliksense  failed with an error below:

    20210603T124122.213+0200 0015 LOAD *
    20210603T124122.213+0200 0016 SQL SELECT DISTINCT QVD_NAME FROM QVMANAGEMENT.QVMGT_QVD_MASTER_T
    20210603T124122.213+0200 0017 WHERE QVDID = ''
    20210603T124124.892+0200 General Script Error in statement handling
    20210603T124127.700+0200 Execution Failed
    20210603T124127.703+0200 Execution finished.

    It failed once on 03/06/2021 When triggered twice, it was a success. We have not done any recent changes in app script and anything in app schedule or app related changes.

    We've checked the environment, it was up and  RAM and CPU was not fully exhausted.

    We have found some errors regarding connector at the time of failure :

    CGenericConnection: Failed to send QVX_TERMINATE to process 9240 (reason 999); C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvOdbcConnectorPackage.exe
    CGenericConnection: Skipping QVX_TERMINATE for process 9240 (reason 999); C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvOdbcConnectorPackage.exe

    we are running on version 'September 2020' and no changes in app script since it is deployed. Running fine right now as well.

    Any suggestions ?

    Show Less
  • forum

    App Development

    Qlik Sense Data Architect & Qlik Sense System Administrator

    Hi all, Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge? just read and try everything on... Show More

    Hi all,

    Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge?

    just read and try everything on qmc?

    Show Less
  • forum

    Qlik Replicate

    AWS RDS for Postgres as source - supported versions

    Hi Qlik Community Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow... Show More

    Hi Qlik Community

    Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow read/write on read replicas which enables setting the wal level to 'logical' on the read replica. This is significant progress as Teams opt to use read replicas instead of replicating directly from the primary instance.

    That said, there's limitations like enabling 'Create DDL events' and 'WAL heartbeats'. We'd like to capture the DDL events, and also benefit from keep the slots alive. But these require a 'create statement being run, and Postgres 16.1 is also not supported. Currently we don't have a solution for reading from a Postgres read replica if we want to replicate changes - 'cause full load works but not viable for large databases.

    Can I ask if there's plans to include Postgres 16.1 on the supported source endpoints. If so, when? And if we'd be able to replicate from a read replica, plus benefit from 'Create DDL events' and 'WAL heartbeats'.

    Regards.

    Show Less
  • forum

    Connectivity & Data Prep

    Failed to send QVX_TERMINATE to process 10328 (reason 991) Qlik Sense June 2020

    Hello everyone,After we updated Qlik Sense to Version June 2020 Patch 5, we have met with this error in Qlik Engine System Log by reloading the tasks?... Show More

    Hello everyone,

    After we updated Qlik Sense to Version June 2020 Patch 5, we have met with this error in Qlik Engine System Log by reloading the tasks? 

    "Failed to send QVX_TERMINATE to process 10328 (reason 991)"

    The server needs the Administrator always log in the system to manuelly trigger the reload. Other user can only trigger the reloads after the local Admin has logged in. 

    We have already turned all security software off from the server... And the Qlik service user has admin access to this server. 

    In windows Event logs we can see no error with access nor anything else. 

    Is this problem Version related? Since in another Test server with the same setup, we didn't install the Patch 5, there exists no problem. 

    Thanks in advance for any hint or advise.

    Best Regards,

    Lan

    Show Less
  • forum

    Integration, Extension & APIs

    Embedding Qlik Sense in a website: problems with fonts and cookies

    Hello fellow devs I've recently updated a ~1 year old installation of Qlik Sense Enterprise to the Feb 2024 Patch 2 release. While Qlik Sense itself s... Show More

    Hello fellow devs

    I've recently updated a ~1 year old installation of Qlik Sense Enterprise to the Feb 2024 Patch 2 release.

    While Qlik Sense itself seems to work fine, I also make extensive use of the mashup api to embed Qlik objects inside my company's web pages.

    Since the update, however, the mashup pages have been misbehaving: most don't load, or load very slowly, or load with messed up fonts (all the icon fonts are missing).

    So, I started debugging by building a very simple mashup page, following the tutorial in the Qlik documentation, and here is the first problem I've found: as soon as I invoke require to obtain the Qlik Sense engine, like this:

    require(["js/qlik"], (qlik: any) => {
    	console.log("obtained qlik engine", qlik);
    	this.qlikEngine = qlik;
    });
     
    I start getting errors and warnings in the browser console:
    master_t_0-1711714702212.png

     

    as you can see, not only are fonts failing to load but it also takes almost 10 seconds to obtain the Qlik Sense engine, which explains the slowness and missing icon fonts that I noticed in my mashup pages.

    If I look at the network panel, I can see that the problem (the font one at least) is that the browser (Chrome) is not sending the X-Qlik-Session cookie when requesting the fonts, and thus Qlik is responding with a 302 status code to redirect to the authentication page:

    master_t_1-1711714904076.png

     

    I've checked online, and from what I understand it is normal for browsers to not send cookies when downloading web fonts... so is this a Qlik Sense bug? Why do the mashup APIs include fonts that are behing authentication? This didn't happen in the older version of Qlik (I think it was a November 2022), so it must be a pretty recent change.

    How can we avoid this issue? Did I mess something up in my mashup or is this an issue with Qlik itself? Can it be worked around?

    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!