Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,998 members
  • 5,703 online
  • 1,997,660 posts
  • 149,763 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    SQL Server LOG_BACKUP full

    We run Replicate and Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has scheduled 4-hour backups for all the company's SQL Se... Show More

    We run Replicate and Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has scheduled 4-hour backups for all the company's SQL Servers which is supposed to truncate the transaction logs for all the databases after doing so. However, the logs for both my test and production data warehouse databases seem to be immune to such truncation:

    JacobTews_0-1715182339478.png

     

    Notice in particular the fact that the log for the test data warehouse is actually bigger than the test data warehouse itself!

    Any systems-knowledgeable folks out there have any insights?

    Is there a setting in Replicate that I have inadvertently toggled to cause such behavior?

    Qlik Replicate 

    Show Less
  • forum

    Qlik Replicate

    Unable to access the URL for Qlik Replicate.

    Hi Team, We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having tr... Show More

    Hi Team,

    We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having trouble accessing the Qlik Replicate Console. Any assistance you can provide would be greatly appreciated. When we kill process id after that we are able to start service also access URL what can be cause for this 

    Thanks!

    Show Less
  • forum

    New to Qlik Analytics

    Pagination Next URL Not working

    i have dat like below in postman request   in qlik connection i am using nextUrl as my pagination  Next Url path :paging/link it bring only one page ... Show More

    i have dat like below in postman request

    ChannaK_0-1715155076241.png

     

    in qlik connection i am using nextUrl as my pagination 

    Next Url path :paging/link

    it bring only one page can you help here

     

    Show Less
  • forum

    Move to SaaS

    How to reload Large Qlik Apps in Qlik SAAS environment since I am getting quote ...

    Hi Team, I am getting below error when loading data in Qlik SAAS environment. Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB.  Reduc... Show More

    Hi Team,

    I am getting below error when loading data in Qlik SAAS environment.

    Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB.  Reduce your data within this application or buy additional capacity.

    Please suggest a solution on this. Can you tell me some ways to reduce the data.

    Thanks

    Vishnu

    Show Less
  • forum

    Design and Development

    tForEach with DBimput & a Subjob

    I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach See attached example screenshot... Show More

    I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach

    See attached example screenshot

     

    When I try to connect the tForeach2 to the Raw transactions I get an error

     

     

    RVeitch_84_0-1715213288902.png

    Thanks for any help 

    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 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

    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
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!