Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,986 members
  • 8,701 online
  • 1,997,651 posts
  • 149,761 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    NPrinting Connection fails to generate metadata

    Hello, I just finished a fresh install of Qlik NPrinting May 2021 SR2 and am looking to connect to Qlik Sense which is also on May 2021 (Patch 4). Whe... Show More

    Hello,

    I just finished a fresh install of Qlik NPrinting May 2021 SR2 and am looking to connect to Qlik Sense which is also on May 2021 (Patch 4).

    When verifying the connection, I get all green checkmarks, but when it comes time to generating the Qlik metadata, it just times out with no intelligent error message:

    November 24, 2021 11:32:58 AM Info Execution reset by scheduler startup
    November 24, 2021 11:33:08 AM Info Execution reset by scheduler startup
    November 24, 2021 11:33:18 AM Info Execution reset by scheduler startup
    November 24, 2021 11:33:28 AM Warn Exceeded maximum number of retries

     

    When I check the NPrinting log files, I do see this:

    20211124T113220.167-05:00 [39] INFO Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator - Engine.Navigator.QlikSense.SDK 21.14.5.0 Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator 20211124T113220.166-05:00 INFO MYNPRINTINGSERVER1 0 0 0 0 0 0 0 0 trying to get login cookie via a qlikTicket from: https://MYQLIKSENSESERVER1.fss.anitech.com/hub/?qlikTicket=CLjdwBN92wWXWzwJ

    And then right above it, I see:

    20211124T110319.461-05:00 [26] ERROR Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator - Engine.Navigator.QlikSense.SDK 21.14.5.0 Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator 20211124T110319.461-05:00 ERROR MYNPRINTINGSERVER1 0 0 0 0 0 0 0 0 An issue occurred in MashupServer.GetAuthenticationCookiesAndConsumeQlikTicket. Proceeding anyway by using Windows authentication to load the mashup page. ERROR: System.Net.WebException: The remote server returned an error: (400) Bad Request.↓↓ at System.Net.HttpWebRequest.GetResponse()↓↓ at Engine.Navigator.QlikSense.SDK.QRSApi.TryGetResponse(HttpWebRequest request) in C:\Jws\release-may2021-QJBWLpX4f\server\NPrinting\src\Engine.Navigator.QlikSense.SDK\QRSApi.cs:line 92↓↓ at Engine.Navigator.QlikSense.SDK.QRSApi.GetQlikTicket(QlikSenseConnectionString conn) in C:\Jws\release-may2021-QJBWLpX4f\server\NPrinting\src\Engine.Navigator.QlikSense.SDK\QRSApi.cs:line 437↓↓ at Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator.GetAuthenticationCookiesAndConsumeQlikTicket() in C:\Jws\release-may2021-QJBWLpX4f\server\NPrinting\src\Engine.Navigator.QlikSense.SDK\Rendering\SenseAuthenticator.cs:line 98↓↓ at Engine.Navigator.QlikSense.SDK.Rendering.SenseAuthenticator.RefreshAuthCookies() in C:\Jws\release-may2021-QJBWLpX4f\server\NPrinting\src\Engine.Navigator.QlikSense.SDK\Rendering\SenseAuthenticator.cs:line 74

     

    Aside from generating the certificate from the Central node and copying it over to the NPrinting server, are there any other steps I need to take to get past this? The NPrinting metadata generation only fails because it seems like it's just simply timing out. Not sure where else to be looking. For background information, we also have three rim nodes which are used as load balancing engines, but I don't think I need to generate anything from them.

    Thanks for your time!

    Show Less
  • forum

    Qlik Replicate

    SQL Server - MERGE

    I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we k... Show More

    I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we know that CDC cannot be activated, I would like to know what the restrictions are in relation to transactional replication, if This impacts merge replication that already exists, if Qlik uses other logs than the one already being used by MERGE.

    Show Less
  • forum

    Qlik Replicate

    Snowflake Target Endpoint - Support new Hybrid Tables as Targets

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA. Will the Snowflake target endpoint connector be modified to support replicatin... Show More

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA.

    Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?

    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables

     

    Show Less
  • forum

    Qlik Enterprise Manager

    QEM service can't start - Failed to connect to SQLite repository 'rtdata.sqlite'

    Hi Support,   We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error... Show More

    Hi Support,

     

    We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
    "[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "

    We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.

    Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.

    This instance of Enterprise Manager is v2023.11.0.259

     

    Thanks,

    Nak

    Show Less
  • forum

    Design and Development

    Parse delimited file with delimiter present in text data enclosed in double quot...

    Hi , I need to parse and load DB a pipe delimited file having data in the below structure using Talend. Col1|Col2|Col3 "abc|111"|100|"zzz" "xyz|222"|2... Show More

    Hi ,

    I need to parse and load DB a pipe delimited file having data in the below structure using Talend.

    Col1|Col2|Col3

    "abc|111"|100|"zzz"

    "xyz|222"|200|"yyy"

    • Text fields are enclosed in double quotes.
    • Few text columns contain the delimiter inside them.

    I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).

    Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.

    Please help.

    Thanks

    Show Less
  • forum

    App Development

    Filter Pivot Table with Button

    I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green... Show More

    I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green, Yellow & Red).  Sample screenshot shown below:

    trevorcrow_0-1715116426998.png

     

    What I'm trying to accomplish, if possible, would be to have a couple of Qlik buttons that could perform filtering of what is being displayed on the Pivot Table.  For example, Button 1 could filter out any Queues with zero records.  Button 2 would filter the pivot table to only display queues that have records in a Red SLA status.  Is this possible?  I've tried numerous things that I've found online but haven't found the right answer or example yet.  

    Thanks for any assistance that can be given!

    Show Less
  • forum

    Qlik Application Automation

    how to loop dimension values and generate each report for that values in Qlik Se...

    how to loop dimension values and generate each report for that values in Qlik Sense SAAS
  • forum

    App Development

    Using Set Analysis to Filter a Histogram by Date

    Hello, I'm trying to create a histogram from my data that selects for only the current date.  Currently, I have this as my "Field": ={<[DATE_FIELD] = ... Show More

    Hello,

    I'm trying to create a histogram from my data that selects for only the current date. 

    Currently, I have this as my "Field":

    ={<[DATE_FIELD] = {"$(=Date(Today(), 'M/D/YYYY'))"}>} [VALUE_FIELD]

    But this isn't filtering out the other dates. Is there another approach I should be taking?

    Thanks in advance!

    Show Less
  • forum

    Move to SaaS

    How to generate report based on dimension values in Qlik SAAS

    Hi Team, How to generate a report based on dimension values in Qlik Sense SAAS version. for example we have region with east & west values. The report... Show More

    Hi Team,

    How to generate a report based on dimension values in Qlik Sense SAAS version.

    for example we have region with east & west values. The report should be generated for both east and west separately and dynamically. Can you please suggest a solution ?

    Thanks

    Show Less
  • forum

    Qlik Application Automation

    Application Automations Monitoring v1.1 fails with HTTP protocol error 422 (Unpr...

    Hi, I have deployed the app Application Automations Monitoring v1.1 in the SaaS tenant and was reloading successfully till last month.  https://commun... Show More

    Hi,

    I have deployed the app Application Automations Monitoring v1.1 in the SaaS tenant and was reloading successfully till last month. 

    https://community.qlik.com/t5/Official-Support-Articles/How-to-automation-monitoring-app-for-tenant-admins-with-Qlik/ta-p/2025392

     

    Now, the reload fails with error below. No changes have been made to the data connection. 

    Any ideas on how to fix it?

    "
    No Incremental QVDs found.
    Connected RestConnectorMasterTable << RestConnectorMasterTable Lines fetched: 33 Automation << RestConnectorMasterTable Lines fetched: 32
    RestConnectorMasterTable << RestConnectorMasterTable
     
    The following error occurred:
    (Connector error: HTTP protocol error 422 (Unprocessable Content): {"limit":["The limit may not be greater than 200."]})
     
    The error occurred here:
    RestConnectorMasterTable: Load *, 'fc80c290-0c6a-11ee-8bf8-b3a699186b55' as AutomationId, '' as AutomationName
    "
    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!