Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Due to some reason in recent months we are getting alot of error entries in C:\ProgramData\Qlik\Sense\Log\AppDistributionService\Trace which increased the size and count of the log file and also these log files are not getting archieved to our D drive causing storage issues in C drive.
what is causing this error and why is it the log is not getting archived ?
error content is given below
# Timestamp LogLevel MachineName Thread ThreadId ServiceUser Message Exception ProcessId TransactionId DeploymentId
12610 20250118T000025.736+09:00 WARN HQLIK01 83 HQLIK01\manager01 Could not "POST" on "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" - Response code: "Forbidden" Reason phrase: "Forbidden" 2912
12611 20250118T000025.738+09:00 ERROR HQLIK01 83 HQLIK01\manager01 Exception caught sending request to : "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" Message: "Response status code does not indicate success: 403 (Forbidden)." System.Net.Http.HttpRequestException: Response status code does not indicate success: 403 (Forbidden).↵↓ at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()↵↓ at AppDistributionService.Model.WorkflowExceptionStrategy.ThrowException(HttpResponseMessage response)↵↓ at AppDistributionService.Sense.QrsRestClient.HandleHttpResponse(Func`1 clientCall, String uri, HttpStatusCode[] ignoreExceptions) 2912
12612 20250118T000025.740+09:00 ERROR HQLIK01 83 HQLIK01\manager01 Cannot rotate file. Response status code does not indicate success: 403 (Forbidden). System.Net.Http.HttpRequestException: Response status code does not indicate success: 403 (Forbidden).↵↓ at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()↵↓ at AppDistributionService.Model.WorkflowExceptionStrategy.ThrowException(HttpResponseMessage response)↵↓ at AppDistributionService.Sense.QrsRestClient.HandleHttpResponse(Func`1 clientCall, String uri, HttpStatusCode[] ignoreExceptions)↵↓ at AppDistributionService.Sense.QrsRestClient.ArchiveLogs(String[] fileNames)↵↓ at AppDistributionService.Configurations.LogsRotationService.ExecuteAsync(CancellationToken stoppingToken) 2912
12613 20250118T000025.835+09:00 WARN HQLIK01 83 HQLIK01\manager01 Could not "POST" on "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" - Response code: "Forbidden" Reason phrase: "Forbidden" 2912
Hi,
I'm wondering if there is a similar PDF guide for tuning to an Azure Synapse target as there is for the Databricks guide that I found online (attached)
Regards,
Mohammed
hello guys.
i'm just wondering how do you guys deal with large datasets that require multiple aggregations and treatements cause for me the loading time takes forever and sometimes fails to complete and using the application becomes quite laggy i tried to resort to making views for the aggregations and import them but the more i make the slower app becomes for example:
Marque_Tom:
LOAD
[Marques],
Q35_DES,
Marques_TOM;
SELECT
Q35 as Marques,
Q35_DES,
Count(Q35) as Marques_TOM
FROM DataShare.dbo.FAIT_Q35
Group By Q35_DES,Q35;
became like this
[Marque_TOM]:
SELECT Marque,
Vague,
Code,
"Marques_TOM"
FROM "Market_Study".dbo."Marque_TOM";
it's just an example i removed aggregations from the data loading part and yes if it was this alone it would not be a problem but i have plenty more and it made it very slow cause it keeps creating correspondence keys and basically impossible to use i hope you help me
Hi,
I'm looking at the documentation for Amazon Kinesis and I am confused as to what exactly this timestamp represents. My assumption is that it represents the time at which the change occurred on the source database. Is this correct?
Furthermore, can someone please help me understand the ChangeSequence field. Is this field only created by Qlik Replicate for each change that the task needs to apply? If I was to replay changes by timestamp, would they have the same change sequence or would it change?
Regards,
Mohammed
Hello All,
I'm planning to pass the QSBA certification. However, I found a simulator on the Qlik site with only 10 questions. Do you have any idea where I can find good test exam examples with recent topics and questions? Any tips or guidance to help orient my preparation would be greatly appreciated.
Is there any questions about Qlik Cloud SAAS ?
Thank you in advance.
#QSBA #QLIKSENSE #Certification
With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansion of reporting capabilities on Qlik Cloud Analytics.
We packed 2024 with enhancements in reporting capabilities, featuring sought-after additions to both enterprise reporting and interactive distributions.
Quick recap:
For details on the 2024 releases, check out the "What's New" section and filter on Analytics > Reporting and Alerting.
Reporting from Qlik Cloud Analytics on the help site should be your starting point for understanding the power and flexibility of reporting on Qlik Cloud Analytics. Take the time to review it in detail, it is very comprehensive!
Looking ahead to 2025*
Work is already underway on some exciting capabilities:
We are also investigating other areas of customer feedback, such as dynamic filter import, and dynamic filename definition. Please continue sharing your ideas on our community ideation portal - the status of reporting topics in ideation is up to date as of this post. Stay tuned and start planning for Qlik Connect!!!
*Disclaimer: This post includes Qlik® roadmaps statements to provide a general overview of our anticipated product direction as of the date hereof. Qlik undertakes no intention or obligation to update or revise any forward-looking statements contained herein, whether as a result of new information, future events or otherwise.
Hi Everyone,
I have a requirement, Can you please help me with the same,
I have a data as shown below here,
Below is the pivot table, I have created, Cost as a category and year with the sum of data, the requirement here is based on the selection in single measure only has to be filtered
Dimension1 | Dim2 | Capex Cost | Running Cost | Operation Cost | ||||||||||||
2024 | 2025 | 2026 | 2027 | 2028 | 2024 | 2025 | 2026 | 2027 | 2028 | 2024 | 2025 | 2026 | 2027 | 2028 | ||
abc | bcd | 0 | 12 | 23 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 17 | 28 | 39 | 50 |
ZXC | cve | 0 | 13 | 24 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 18 | 29 | 40 | 51 |
wes | qws | 0 | 14 | 25 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 30 | 41 | 52 |
tvs | xsz | 0 | 15 | 26 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 20 | 31 | 42 | 53 |
tre | dfv | 0 | 16 | 27 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 21 | 32 | 43 | 54 |
For example if a user has selected 2024 in Capex cost only 2024 for capex has to be filtered and remaining should be as is the output should be as shown below
Dimension1 | Dim2 | Capex Cost | Running Cost | Operation Cost | ||||||||
2024 | 2024 | 2025 | 2026 | 2027 | 2028 | 2024 | 2025 | 2026 | 2027 | 2028 | ||
abc | bcd | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 17 | 28 | 39 | 50 |
ZXC | cve | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 18 | 29 | 40 | 51 |
wes | qws | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 30 | 41 | 52 |
tvs | xsz | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 20 | 31 | 42 | 53 |
tre | dfv | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 21 | 32 | 43 | 54 |
if a user has selected 2024 in Capex cost, 2024,2025,2026 in running cost the output should be as shown below
Dimension1 | Dim2 | Capex Cost | Running Cost | Operation Cost | ||||||
2024 | 2024 | 2025 | 2026 | 2024 | 2025 | 2026 | 2027 | 2028 | ||
abc | bcd | 0 | 0 | 0 | 0 | 5 | 17 | 28 | 39 | 50 |
ZXC | cve | 0 | 0 | 0 | 0 | 5 | 18 | 29 | 40 | 51 |
wes | qws | 0 | 0 | 0 | 0 | 5 | 19 | 30 | 41 | 52 |
tvs | xsz | 0 | 0 | 0 | 0 | 5 | 20 | 31 | 42 | 53 |
tre | dfv | 0 | 0 | 0 | 0 | 5 | 21 | 32 | 43 | 54 |
if a user has selected 2024,2028 in Capex cost, 2024,2025,2026 in Running cost the output should be as shown and 2027,2028 in Operation cost the output should be as shown below
Dimension1 | Dim2 | Capex Cost | Running Cost | Operation Cost | ||||
2024 | 2028 | 2024 | 2025 | 2026 | 2027 | 2028 | ||
abc | bcd | 0 | 0 | 0 | 0 | 0 | 39 | 50 |
ZXC | cve | 0 | 0 | 0 | 0 | 0 | 40 | 51 |
wes | qws | 0 | 0 | 0 | 0 | 0 | 41 | 52 |
tvs | xsz | 0 | 0 | 0 | 0 | 0 | 42 | 53 |
tre | dfv | 0 | 0 | 0 | 0 | 0 | 43 | 54 |
based on the selection in that particular year the data has to be filtered for that particular category,
can you please help me with this requirement, Appreciate your help
thanks in advance, Even alternate states works
I have a table with these columns: name, category, status, dtime. I want to get latest status for each name from the same category even if I filter specific dtime and latest name’s status dtime is before filtered dtime. For example name - jack, category - worker, status - available, dtime - 2025-01-19 20:00:00, name - jack, category - worker, status - unavailable , dtime - 2025-01-19 21:00:00, name - mike, category - worker, status - available, dtime - 2025-01-19 20:00:00. So if I filter to 2025-01-19 21:00:00 I want to get name - jack, category - worker, status - unavailable , dtime - 2025-01-19 21:00:00, name - mike, category - worker, status - available, dtime - 2025-01-19 20:00:00
Hi Team,
PFA of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the rolling months it has to show zero in the bar chart and if user select any timeframe monthyear dim has to be changed accordingly as per the selected timeframe example week or year or date, All these are achieved.
now the issue is if i add another dim in the chart and disable the include null value , i am not getting the zero value. bar chart has to show allways rolling 6 bars, if no data then it shd be zero and similarly pivot shd show the rolling 4 months.
I exported a job from my old qlik server into my new qlik server. The source is DB AS400 and the target is PostGres. The data record is not showing up correctly. It is showing zero instead of 100. 100 is on the old server. the new server is showing 0. I went through all the configurations for both servers and they are the same. I have enabled verbose on the problem server.
Error:
0004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: get_capture_table_list: fetched table XXXX.XXX (db2i_endpoint_imp.c:1369)
00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]V: Construct statement execute internal: 'select CARDINALITY from SYSIBM.SQLSTATISTICS where TABLE_SCHEM='XXXX' and TABLE_NAME='XXXX' and TYPE=0' (ar_odbc_stmt.c:4040)
00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)
0004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_step_ex_stmt: (rc == SQLITE_DONE || rc == SQLITE_ROW) failed (at_sqlite.c:525)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <19>, Message <UNIQUE constraint failed: load_status.seq_num>. [1000505] (at_sqlite.c:525)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_step_ex_stmt:525: Failed (at_sqlite.c:545)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_do_immediate: rc == SQLITE_DONE failed (at_sqlite.c:990)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <1>, Message <cannot start a transaction within a transaction>. [1000505] (at_sqlite.c:990)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_do_immediate:990: Failed (at_sqlite.c:994)
00005956: 2025-01-15T16:43:44:157964 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: Retrieved system names 'XXXX '.'XXXX ' for 'XXXX'.'XXXX' (db2i_endpoint_util.c:961)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:4040)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)
00005956: 2025-01-15T16:43:44:649307 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)
Attendees get two free certification exams included with their event registration (valued at $500).
Qlik Reporting Service received a significant upgrade with several new features!
Join us 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!