Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
お世話になっております。 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
I have couple of reports which I am sending as excel attachment via NPrinting email. In them I have columns which have numerical data e.g. Amounts.
The problem is in the excel attachment these columns get converted into 'text' type due to which sub-totals are not calculated.
I have already taken below steps to troubleshoot this:
1. The specific column is 'measure' in the Sheet (straight table widget) with 'Number' formatting.
2. In the NPrinting template of the report have disable 'Keep Source Formats'.
3. Have changed the format of the column to 'Number' in the NPrinting excel template.
Please advise what can I do to solve this.
Hello Qlik Team,
I am reaching out to know about documentation for Qlik Sense Cloud.
Could anyone please provide me with the necessary documentation resources required for Qlik Sense Cloud?
Thank You.
Hi, please I need solution about an issue I've been haven past days, I work with a tenant in qlikcloud, but I embed all my charts using capability api for that, and also I use enigma to buil functions that help me give service to my customers, the problem is that rencently the request made using capability or enigma are failing and a message appears that shows what follows
here we can see the message, and it appears without reason apparently, the network state is stable, there are no other users logged in
here we can see how the charts I'm trying to embed takes a long time to be visible or completly fails and doesn't load
Please if anyone can help me, or explain what could be the problem, I would be grateful, thanks in advance
My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT.
Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is UTC.
My Analytics data (retrieval_time) is showing as matching Eastern Time values.
What I'm concerned about is (a) I need all my analytic data to be stamped by UTC and (b) conversions become complicated with DST.
What is the best way to get my analytics data by UTC time?
I have thought of altering the TZ at the windows OS level, but concerns this could affect other dependencies like maintenance & patching processes.
Any "best practices" anyone could share?
Thanks.
Hi Qlik Community
Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow read/write on read replicas which enables setting the wal level to 'logical' on the read replica. This is significant progress as Teams opt to use read replicas instead of replicating directly from the primary instance.
That said, there's limitations like enabling 'Create DDL events' and 'WAL heartbeats'. We'd like to capture the DDL events, and also benefit from keep the slots alive. But these require a 'create statement being run, and Postgres 16.1 is also not supported. Currently we don't have a solution for reading from a Postgres read replica if we want to replicate changes - 'cause full load works but not viable for large databases.
Can I ask if there's plans to include Postgres 16.1 on the supported source endpoints. If so, when? And if we'd be able to replicate from a read replica, plus benefit from 'Create DDL events' and 'WAL heartbeats'.
Regards.
If we have the applications created in Qlik cloud saas , that means the data shared to Qlik vendor how the security is provided to our applications data.
Hi,
I'm following AEM API documentation here
and able to login and getting APISessionID, but when APISessionID returned is passed to other APIs such as
/api/v1/servers it's returning application-status as 500 and error as "SYS-E-UNRECREQ, Unrecognized request pattern 'GET: /v1/servers'."
Can someone help me, what's missing?
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!