Hello Everyone, 

Hope you all are having a great summer and doing fine . 

I have a weird case that I 'm trying to solve : 

I got 2 applications (Qliksense) , let's say A & B. I did session access (the simpliest way possible) on application A, and it works fine . For any reason , session access (same session access script as Application A) on application B doesn't work ! 

I got a general script error at the end of the Loading script of B's application . Without the session access script , application B loading is working fine . 

Can you help me ! feel free to ask any question . 

Hi everyone,

I´m facing a new issue with QLIK Replicate because the Task does not replicate the column size from the source to the target table correctly. 

ERROR in the attrep_apply_exceptions:

The following source column(s) contain data that exceed(s) the size limit of the corresponding target column:
source column "TRMC80" is 32 bytes while target column "TRMC80" is 8 bytes;
source column "MOTY80" is 16 bytes while target column "MOTY80" is 4 bytes;
source column "HDID80" is 48 bytes while target column "HDID80" is 12 bytes;

Endpoints types in use:

Souce: IBM DB2 for LUW

Target: Microsoft SQL Server 2022 (160 Compatibility)  

Any help will be very appreciated.

Thank you !!

Best Rgds,

Leandro Medeiros

We have a table that is over 1.5 million rows. This table is replicating from MYSQL to Snowflake via a CDC task. We have to increase the LOB limit because the json values are being truncated. What are some alternatives to repopulating the historical data without having to do a full reload. 

Hi,

I post about this topic a while ago and some tried to help me.
I'm posting again because there is an update with more context on the issue.
This is my previous post.

As in the previous post,
I need to display Actual Vs. Budget for 3 sales measures - Number of Transactions, Items Sold and Sales Amount.
It works partially as suggested in the previous post. The problem is that I'm not getting total rows.

There are two additions:
* I need to display the data broken down by month (actual vs. budget for every month) and add o total columns for the selected period. The problem again is displaying the totals.
* I need to add a row for the GeneralCost under the totals, and add an additional total row to show the Profit (TotalSalesAmount - GeneralCost).

I attached an image (with a partial example) showing the output I'm trying to achieve.

I'd appreciate your help with building the pivot table.

HI team,

I have Qlik Sense server on which Nov 2024 Qlik sense is running. PosgresDB is unbundled and available at D:\program files\PostgresSQL\14.

Version of PostgresSQL is 14.8.

The Qlik Sense Repository database service is removed already and not present in services.

I need to upgrade Qlik Sense from Nov 2024 to May 2025 , Please guide me steps and things to take care?

Few queries from my side? 

1. I see QPI May 2025 tool available on Qlik downloads, May I know do we need to use it in Upgrade of Qlik Sense or my server already has 14.8 version, no need to do anything with it?

2. what backup is must to restore the complete site i.e. repo dump etc?

3. In case in future I need to upgrade PostgresSQL14.8 to PostgresSQL 16, how to do it? any document is available ?

Thanks in advance

Rohit

I am a Qlik Sense and NPrinting developer. What permissions do I need to be able to see all the reports in the NewsStand? The former guy just seemed to receive every single NPrinting report- lots of emails. I would just like to see all the reports being sent there and encourage company use. I currently have the Administrator role in NPrinting which has everything checked for Apps, Users, and Admin. What am I missing?

I'm trying to produce a pivot table that shows who each task is assigned to and the % complete that task is.

What I'm actually getting is just the one name - so if there is a Task3 with Nigel against it it also shows it as allocated to Task 2 and TaskName.  Is there a way around this? I need to be able to roll up the data for overall % complete which is why a straight table isn't sufficient but I can't find a away to show where more than one person is responsible for the subtasks?

Subtasks have been created using hierarchy:

Tasks:
Hierarchy ( TaskId,TaskParentTaskId,TaskName,'ParentTask')

I have tried mapping but the same issue occurs - any help or suggestions appreciated

Carol

Hi All,

After upgrading Qlik NPrinting from September 2019 to February 2025 SR1, we encountered an issue where reports are not sent to some user emails. The tasks run successfully, but some emails fail to deliver with the following error message:

20250714065008 Error Failed to send email for user 'XXXXXXX' {XXXX-XXXX-XXXX-XXXX-XXXX}. ERROR: 4.3.2 Concurrent connections limit exceeded. Visit https://aka.ms/concurrent_sending for more information. [Hostname=server.outlook.com]

Previously on NPrinting September 2019, all reports were sent without any issues.

We have contacted support and already tried adjusting the following parameters in the scheduler.config file as suggested in the release notes:

• max-mail-client-connection-attempts: (default is 2)

• mail-client-connection-attempts-delay-ms: (default is 500 ms)

Reference: https://community.qlik.com/t5/Release-Notes/Qlik-NPrinting-Release-notes-February-2024-Service-Release-3/ta-p/2474564#:~:text=SMTP%20connection%20retry%20configuration 

Despite these changes, the problem persists. We’re unable to ask the SMTP admin to change server-side settings, especially since everything worked fine before the upgrade.

Has anyone else experienced this issue after upgrading? Any advice or workarounds would be greatly appreciated.

Thanks

Hi,

I put 4 charts in a container and each chart has the enable using buttons to with condition visible. like click on button the chart will visible. But when edit sheet is completed the container is not able to show the default view as i updated the default chart view. Please help to keep the default view in container