Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 240,857 members
  • 3,265 online
  • 2,023,615 posts
  • 152,177 Solutions
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Move to SaaS

    Data Gateway 'failed to read data at {0:9}

    Hello all, We have switched to Qlik SAAS since 31/12. To get the data from our on premise Progress database we are using the Qlik Direct Access Data G... Show More

    Hello all,

    We have switched to Qlik SAAS since 31/12.

    To get the data from our on premise Progress database we are using the Qlik Direct Access Data Gateway.
    The thing is that retrieving 1 table does not always succeed, sometimes it does, and after about 10 million lines gives an error message:

    'Error:(Connector error: Status(StatusCode="Internal", Detail="Failed to read data at {0:9}") (DirectAccess-1512))'

    In total, I am reading 17 fields from a table with about 17.5 million lines, good for a 300 MB QVD file.

    There is another larger table that I read from and it works perfectly (QVD of 5 GB). Anyone who can deduce from the error message where my problem is?

    Thanks in advance!
    Peter

     

    Show Less
  • forum

    New to Qlik Analytics

    Simple If statement exits script

    This one is almost embarrassing. But, they say there's no dumb questions... Set vLastActionTime = '1'; If($(vLastActionTime = 1, Trace $(vLastActionTi... Show More

    This one is almost embarrassing. But, they say there's no dumb questions...

    Set vLastActionTime = '1';

    If($(vLastActionTime = 1, Trace $(vLastActionTime));

    Seems pretty simple, but all this does is exit my data load script.  If I run the Trace command before the conditional the value is 1.  I started with a more complex expression but can't seem to get anything to work.  I've probably tried a couple of dozen different syntax combinations to make this simple thing work.  It has to be some fundamental issue that I just can't find in the documentation. I can see in the debug window that the variable gets set.

    Show Less
  • forum

    New to Qlik Analytics

    Grab max timestamp for each date

    Hello, either in my script or in the chart itself or a calculated dimension, how do I grab the max timestamp per date?  So basically, how do I flag/gr... Show More

    Hello, either in my script or in the chart itself or a calculated dimension, how do I grab the max timestamp per date?  So basically, how do I flag/grab only the yellow rows below? Thank you for your time

    drohm002_0-1736969262859.png

     

    Show Less
  • forum

    Qlik Application Automation

    DOS command to Export a Table from QlikView QVF

    Howdy, I have a chart in a QVF that is updated each week.  I would like to run a DOS command to export the data to a CSV file. I've read quite a few p... Show More

    Howdy,

    I have a chart in a QVF that is updated each week.  I would like to run a DOS command to export the data to a CSV file.

    I've read quite a few posts, but I'm not seeing anything like this.  Is it possible?

    Thanks!

    Show Less
  • forum

    App Development

    (StatusCode="ResourceExhausted", Detail="Received message exceeds the maximum co...

    I have a simple query, with Oracle ADW Connection with Data Gateway, without Bulk Reader. A Select with a CLOB field. If I select more than 20 rows, i... Show More

    I have a simple query, with Oracle ADW Connection with Data Gateway, without Bulk Reader.

    A Select with a CLOB field. If I select more than 20 rows, it returns this error:

    The following error occurred:
    Internal error. (Connector error: Status(StatusCode="ResourceExhausted", Detail="Received message exceeds the maximum configured message size.") (DirectAccess-1512))

     

    Show Less
  • forum

    New to Qlik Analytics

    Copy productive Qlik Server

    Hi experts We have destroyed our test server due to an earlier update, IT was not able to restore it. Question: Why not make a copy of the production ... Show More

    Hi experts

    We have destroyed our test server due to an earlier update, IT was not able to restore it. Question: Why not make a copy of the production server to install the latest Qlik version? Are there any points to consider?

    Thanks for your comments, Tom

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Sense crashes when string in SQL server field is too long

    Hello fellow Qlik'ers,  Within our company we're moving to the latest version of Qlik Sense November 2022 Patch 3. The old environment is still runnin... Show More

    Hello fellow Qlik'ers, 

    Within our company we're moving to the latest version of Qlik Sense November 2022 Patch 3.
    The old environment is still running on Qlik Sense April 2019. 

    Within the new version I've set up a connection to our Microsoft SQL Server (on-premise) like I have in the old environment. In the new environment when creating the connection you have one setting called [Max string length]. The maximum value that you can enter here = [16384]. In the old environment there is no setting like this. 

    When I'm trying to load a table which has a very long string in a field (in my case I'm loading a table with BASE64 images) the app crashes. Where the documentation is saying that if a string is longer than the set value, it will be truncated, and the exceeding characters will not be loaded. I've the feeling that this is not true, but that it crashes if the string is too long. 

    We are getting errors like: 
    [Error row status 5 at 37] 
    [
    Connector error: Failed to fetch remaining data!]

    ]

    Where the old version of Qlik just loads the field without any issues. Is there a way to solve this issue or work around it? Because it's pretty annoying, you have to guess or debug the data set my making it smaller (in terms of rows and fields) step by step. 

    TeunJacobs_0-1675864019688.png

    Thanks in advance! 

    Show Less
  • forum

    New to Qlik Analytics

    How I can generate this type of chart in QlikSense?

    I am familiar with the waterfall chart but not sure we can achieve above results with it?  
  • forum

    App Development

    Setting up Foreign Keys (ServiceNow)

    I have two tables from a call to ServiceNow. Incident and User. User is easy. It has user_name and a sys_id. Incident has a number of references to us... Show More

    I have two tables from a call to ServiceNow. Incident and User.

    User is easy. It has user_name and a sys_id.

    Incident has a number of references to user. If has an opened_by_sys_id, a closed_by_sys_id, and an assigned_to_sys_id. What is the relationship between these? I cannot set up a simple additional column because it would cause synthetics. How do I load the incident table so that it will look up the three columns in the user table? 

    Show Less
  • forum

    Qlik Application Automation

    Silent Install not working using service account.

    When I was installing Qlik sense November 2022 version using silent mode using admin it was going through successfully. But when I try to silent insta... Show More

    When I was installing Qlik sense November 2022 version using silent mode using admin it was going through successfully. But when I try to silent install the application using service account it was not going through and getting service user validation failed. If I provide correct credentials also. Please provide me suggestion to resolve this issue.

    Thanks in advance.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!