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 

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: 

• Dynamic Subscriptions: Subscriptions can now utilize dynamic expressions, and users can preview them. You can perform an ad hoc multi-sheet download, and if you like it, you can schedule it for future delivery. 

• On-Demand Reports: Report developers can make Tabular or PixelPerfect reports available on-demand within an app, allowing users to set their selections and download reports immediately.  

• Cycling Feature: Developers have increased control with the addition of cycling (repeating a report per dimension) within task configurations. 

• Task History: Developers can now see up to 90 days of report task execution history. 

• PDF Output: PDF output for Tabular reporting has been introduced. 

• Integrated PixelPerfect Editor: An in-app integrated PixelPerfect report editor is now available, enabling users to create visually stunning, highly customized reports with pixel-level precision. Reminder - Developers can enhance their editing skills through a free e-learning module. 
   

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: 

• New Report Authoring Tools: In addition to PixelPerfect, an embedded in-app HTML editor is in development to support authoring of HTML report templates. These templates can serve as the email body for task distributions when using the email channel; HTML attachments will also be supported. 

• Multi-Template Distribution: The report task will expand to allow multi-template report distribution. Developers will manage tasks that include HTML report bodies and attachments for Tabular, PixelPerfect, and HTML templates. 

• Enhanced Reporting Guardrails: We will also expand some of our reporting guardrails in line with customer reporting growth. 
• New Straight Table - download column totals: The new straight table is getting a boost with some ad hoc download controls including the inclusion of column totals.  
   

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

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

if a user has selected 2024 in Capex cost, 2024,2025,2026 in running cost the output should be as shown below

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

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)