Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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!
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:
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
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.
Thanks in advance!
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?
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.
Celebrate your team's excellence! Applications are now open for a chance to be recognized on our global stage.
Qlik Reporting Service received a significant upgrade with several new features!
Join us on Jan. 15 for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!