Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
Do you have any functionality in Qlik Replicate or AEM to disable few tasks or a particular task when an issue occurs at the source to prevent the data corruption at the target so that it cannot be resumed or restarted manually.
Please suggest.
Thank you,
Pranathi
Hi All,
I'm running the same query directly on the Postgres DB and from Qlik replicate Postgress DB source, the output the data returned are different.
Does anyone know, what is the logic and why it is different?
Here is my query:
text='' OR text is NULL) and timestamp >'2023-06-30 12:56:28.714588' and (1=1) order by 1 ASC LIMIT 100;--?
Hello,
I use Talend 7.3.1 and today, when I open Talend, I have a red message telling me update is required, and the button "update". After click in this button, Talend does not open any more.
A log file is created in configuration folder after I click on Talend-Studio-win-x86_64.exe.
but no error inside, only:
!SESSION 2024-03-18 18:21:26.978 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_202
java.vendor=Azul Systems, Inc.
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86_64
!ENTRY org.talend.platform.logging 1 0 2024-03-18 18:21:30.564
!MESSAGE 2024-03-18 18:21:30,557 INFO org.talend.platform.logging.Activator -
!!------------------------------------------------------------------------------!!
!! !!
!! TALEND !!
!! Starting Talend's platform log system.VERSION= 7.3.1.20220906_1110-patch !!
!! !!
!!------------------------------------------------------------------------------!!
how can i fix this?
Thanks in advance
I'm trying to replicate a table from MS SQL Server to SF, and setting the task to be Full Load only. This table has an LOB column and it has no PK.
Per the post attached below: "A full load-only task can get around a limitation with LOB columns that are in a table with no primary key.", I followed the post to set the task so that "Full Load Processing is ON", but the LOB column is still skipped when loading.
https://community.qlik.com/t5/Official-Support-Articles/An-Introduction-to-Qlik-Replicate-Tasks-Full-Load-vs-CDC/ta-p/2019167
Could you please kindly advise if this is not a valid walkaround, and the only solution is to add PK to the source table?
Hi Team
I was having a job which was running without any issues for last few months. But suddenly the job got failed with the below issue.
Exception in component Common_Access_token_Generator_1_tREST_2
com.sun.jersey.api.client.ClientHandlerException: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:155)
at com.sun.jersey.api.client.Client.handle(Client.java:652)
at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)
at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
at com.sun.jersey.api.client.WebResource$Builder.post(WebResource.java:570)
Please help in resolving this issue.
Hi! I have a requirement to generate a report with Excel sheets for a set of months. This works fine but how do I show the most recent month as the first worksheet?
お世話になります。QlikSenseのテーブルチャートで、以下のような実装が可能かお教えいただきたいです。
ロードしたデータ
Name | v1 | v2 | v3 |
---|---|---|---|
A | 10 | 200 | 300 |
B | 100 | 600 | 400 |
C | 25 | 400 | 1000 |
表示させたいテーブルのイメージ
Name | v1+v2 | rank(v1+v2) | v3 | v3Total |
---|---|---|---|---|
B | 700 | 1 | 400 | 400 |
C | 425 | 2 | 1000 | 1400 |
A | 210 | 3 | 300 | 1700 |
実装上、aggr関数とabove関数を使ってrank順でのソートまではできたのですが、累計表示がどうしてもName順でしかできません。
QlikSenseのヘルプページ等によると、メジャーの修飾子「累計」やaggr関数での累計表示を行う場合、ソートは軸の単項目(上記の場合「Name」)でのみ可能と理解したのですが、
上記イメージのように、計算結果を使って並び替えた上での累計表示は不可能でしょうか。
ロードスクリプトであらかじめ「v1+v2」を計算しておき、軸項目とすれば実現可能なのではと予想しておりますが、もしチャート上だけで実現する方法があればお教えください。
お世話になっております。 BBSの丸山です。
お客様の環境にて、
以下の公式URLを参考にバックアップを実施し、
https://help.qlik.com/ja-JP/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backup-and-restore.htm
以下の公式URLを参考にリストア作業を実施しました。
(ホスト名については、リストア作業前にホスト名とIPアドレスを移行前サーバーと同一にしているため、
ホスト名が同じマシンへの Qlik Sense サイトの復元の手順を実施しております。)
https://help.qlik.com/ja-JP/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm
移行作業自体は完了し、各ユーザーのUser Directory等もサーバーホスト名と同一で問題ないのですが、
一部のユーザーでログイン出来ないエラーが発生しました。
Windowsユーザーは、移行先サーバーでは一括でパスワード等も旧サーバーと同一になるように設定しており、ログインできないユーザーについても、同一のパスワードを再設定するとログイン出来ました。
このようなQSの移行によるユーザーの一部のみがログイン出来ない事象について、考えられる原因などあれば伺いたいです。
Hi,
I'm encountering an issue while trying to securely connect to my Qlik Sense server hosted on an AWS EC2 instance from a remote machine using curl
. I followed the steps provided in the Qlik documentation to export a set of certificates for this purpose.
The exported server.pem
certificate correctly contains the public DNS of the EC2 instance as the Subject Common Name (CN). This aligns with my expectation to use the public DNS for remote connections.
However, when I attempt to establish a connection using curl
with the specified certificates, I encounter SSL verification issues. To diagnose the problem, I used the openssl s_client
command to inspect the SSL handshake and the certificate being presented by the server:
`openssl s_client -connect <public DNS>:4242 -servername <public DNS>`
Surprisingly, the output indicates that the server is presenting a certificate with the Subject CN set to the private DNS of the EC2 instance, rather than the public DNS specified in server.pem
. This discrepancy leads to a "no alternative certificate subject name matches target host name" error from curl
, as there's a mismatch between the host I'm connecting to and the CN in the presented certificate.
I'm trying to understand why there's a difference between the CN in the exported server.pem
certificate and the CN in the certificate presented during the SSL handshake with the server. Is there a configuration within Qlik Sense that determines which certificate is presented for remote connections, or could this be related to the AWS setup?
Any insights or guidance on resolving this discrepancy would be greatly appreciated, as I aim to establish a secure connection using the public DNS of the EC2 instance.
Qlik Compose for Data Warehouses
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
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 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.
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.
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!