Hallo zusammen.,

die aktuelle NPrinting Version (Feb2025 SR1) benutzt eine alte log4net.dll (2.0.9.0) die von unserem Schwachstellenscanner  erkannt wird. Ist es absehbar wann die benutzte Version auf einen neuen Stand gebracht werden soll?

Danke Alex

We are setting up a new Qlik Replicate for the 2019 Microsoft SQL server source hosted on AWS and here are the details below. I am getting the below error message. Seeking your expert suggestions to get this issue resolved.

RDS Instance Details

RDS Type : Microsoft SQL Server

Version : 2019

Settings Summary:

• $type : MicrosoftazuresqlmscdcSettings
• additionalConnectionProperties : useTrustServerCertificate=yes;
• database : ccData
• dbid : 100
• mscdcCaptureDDLChanges : false
• partitionIdsCatchup : false
• server : sqlserver2019_test.us-east-1.rds.amazonaws.com
• skipMscdcJobFitnessCheck : true
• suspendTableWithComputedColumn : true
• username : qlik_user
• useWindowsAuthentication : false

Error Message:

• SYS-E-HTTPFAIL, Failed to connect.
• SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 08001 NativeError: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.

Es sencilla mi pregunta, simplemente no se me esta permitiendo descargar, no c en que link o en cual dirección deba hacerlo, ya rellene los forms para poder acceder a una demo, pero simplemente no me envían nada, y dentro de https://community.qlik.com/t5/Download-Qlik-Products/tkb-p/Downloads simplemente no me deja descargar la versión de desktop, alguien sabe si me estoy saltando algo?

Learn from Luciane Ellis, the Senior Product Marketing Manager at Qlik, about embedding AI-powered analytics to add value for your users and overcome challenges. This guide covers how to choose the right integration, simplify development, scale with ease, and deliver real-time AI powered insights directly in your app.

Read the Full Guide

Hi SME, 

Someone created the below rule to allow ADGroup to access an app, and I don't know what it's supposed to do.  So I have 3 questions and hope someone here can help.

1) ABC group has 10 users, does qlik automatically reserve 10 login passes even though no one has used it yet?

2) DFG group has 15 users of which 5 exists in ABC, if Q1 holds true where qlik reserves 10 login passes, will qlik also hold 15 regardless what exists in ABC?

3) 1 login pass has a predefined time of 60 minutes.  Let's say Jack login today and used up 10 minutes and closed out the browser.  A week later, he logged back in and used another 10 minutes, in this scenario, is Jack using only 1 login pass since he logged in twice and technically used 20 minutes out of the 60?  Does this mean 1 login pass = 60 minutes and for duration of 28 days?

(((user.group=resource.@ADGroupLoginAccess and resource.stream.name like "*")
or (user.group=resource.app.@ADGroupLoginAccess
and (resource.approved="true"
or (resource.owner.userId=user.userId and resource.approved="false" )
or resource.published="true"
)))

Thank you in advance!

Trying to run the existing preparation from the talend cloud from the studio. It ran successfully on the cloud but facing some issue when called from studio and below is the log.

Starting job data_prep__steward at 15:12 16/06/2025.
[statistics] connecting to socket on port 4000
[statistics] connected
[FATAL] 15:12:40 qps.data_prep__steward_0_1.data_prep__steward- tDataPrepRun_1 Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
java.lang.NullPointerException: Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
	at org.talend.dsel.functions.custom.IsOfTypeUtility.isSemanticType(IsOfTypeUtility.java:60) ~[daikon-ee-dsel-8.5.4.jar:?]
	at org.talend.dsel.functions.custom.IsOfTypeUtility.evaluate(IsOfTypeUtility.java:28) ~[daikon-ee-dsel-8.5.4.jar:?]
	at org.talend.dsel.functions.custom.IsInvalid.call(IsInvalid.java:28) ~[daikon-ee-dsel-8.5.4.jar:?]
	at org.talend.maplang.el.interpreter.impl.function.ExprLangFunctions.call(ExprLangFunctions.java:45) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitStandardFunction(ExprEvalVisitorImpl.java:363) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:351) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:482) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:113) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:445) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:108) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:443) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsExprValue(ExprInterpreterImpl.java:199) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsBoolean(ExprInterpreterImpl.java:107) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
	at org.talend.components.processing.functions.AbstractBaseFunction.isRecordMatchingFilter(AbstractBaseFunction.java:233) ~[processing-functions-1.68.1.jar:?]
	at org.talend.components.processing.functions.AbstractBaseFunction.applyOnRecord(AbstractBaseFunction.java:171) ~[processing-functions-1.68.1.jar:?]
	at org.talend.components.processing.functions.AbstractBaseFunction.transform(AbstractBaseFunction.java:156) ~[processing-functions-1.68.1.jar:?]
	at org.talend.components.processing.functions.technical.Composite.transform(Composite.java:53) ~[processing-functions-1.68.1.jar:?]
	at org.talend.components.dataprep.preparation.Preparation.transform(Preparation.java:50) ~[dataprep-1.68.1.jar:?]
	at org.talend.components.dataprep.processor.DataPrepProcessor.onElement(DataPrepProcessor.java:99) ~[dataprep-1.68.1.jar:?]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
	at org.talend.sdk.component.runtime.base.LifecycleImpl.doInvoke(LifecycleImpl.java:87) ~[component-runtime-impl-1.79.0.jar:?]
	at org.talend.sdk.component.runtime.output.ProcessorImpl.onNext(ProcessorImpl.java:303) ~[component-runtime-impl-1.79.0.jar:?]
	at org.talend.sdk.component.runtime.di.AutoChunkProcessor.onElement(AutoChunkProcessor.java:38) ~[component-runtime-di-1.79.0.jar:?]
	at qps.data_prep__steward_0_1.data_prep__steward.tFileInputDelimited_1Process(data_prep__steward.java:2821) [classes/:?]
	at qps.data_prep__steward_0_1.data_prep__steward.runJobInTOS(data_prep__steward.java:3927) [classes/:?]
	at qps.data_prep__steward_0_1.data_prep__steward.main(data_prep__steward.java:3565) [classes/:?]
Exception in component tDataPrepRun_1 (data_prep__steward)
java.lang.NullPointerException: Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
	at org.talend.dsel.functions.custom.IsOfTypeUtility.isSemanticType(IsOfTypeUtility.java:60)
	at org.talend.dsel.functions.custom.IsOfTypeUtility.evaluate(IsOfTypeUtility.java:28)
	at org.talend.dsel.functions.custom.IsInvalid.call(IsInvalid.java:28)
	at org.talend.maplang.el.interpreter.impl.function.ExprLangFunctions.call(ExprLangFunctions.java:45)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitStandardFunction(ExprEvalVisitorImpl.java:363)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:351)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:41)
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:482)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:113)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:41)
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:445)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:108)
	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:41)
	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:443)
	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsExprValue(ExprInterpreterImpl.java:199)
	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsBoolean(ExprInterpreterImpl.java:107)
	at org.talend.components.processing.functions.AbstractBaseFunction.isRecordMatchingFilter(AbstractBaseFunction.java:233)
	at org.talend.components.processing.functions.AbstractBaseFunction.applyOnRecord(AbstractBaseFunction.java:171)
	at org.talend.components.processing.functions.AbstractBaseFunction.transform(AbstractBaseFunction.java:156)
	at org.talend.components.processing.functions.technical.Composite.transform(Composite.java:53)
	at org.talend.components.dataprep.preparation.Preparation.transform(Preparation.java:50)
	at org.talend.components.dataprep.processor.DataPrepProcessor.onElement(DataPrepProcessor.java:99)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.talend.sdk.component.runtime.base.LifecycleImpl.doInvoke(LifecycleImpl.java:87)
	at org.talend.sdk.component.runtime.output.ProcessorImpl.onNext(ProcessorImpl.java:303)
	at org.talend.sdk.component.runtime.di.AutoChunkProcessor.onElement(AutoChunkProcessor.java:38)
	at qps.data_prep__steward_0_1.data_prep__steward.tFileInputDelimited_1Process(data_prep__steward.java:2821)
	at qps.data_prep__steward_0_1.data_prep__steward.runJobInTOS(data_prep__steward.java:3927)
	at qps.data_prep__steward_0_1.data_prep__steward.main(data_prep__steward.java:3565)
[statistics] disconnected

Job data_prep__steward ended at 15:12 16/06/2025. [Exit code  = 1]

So what is my exact problem I have three chart image so in automation i have send that image not a pdf just an image in email by formatting if I add images and give the html code it is not sending the mail with proper images because the height is a matter it is providing more spaces I have created to work on that is there any other way to send images in proper formatting in email i dont want to use any python automation. On the top left i have one image and in top right I have one image then the second row in center i have one image but the height between center and top iages is exceedin.Someone help me with this

Hello everyone,

I was wondering if there is another way, besides using tBufferOutput component, to pass information from a child Job to a parent Job.

I'm using context variables with the same name. And I read it somewhere, on some forum, that there is a way that does not involve the tBufferOutput component to pass the information from a child Job to its parent, when using context variables with the same name.

I haven't found any documentation that supports this.

Can someone please tell me if there's another way to pass the information without using the tBufferOutput component (I don't want to write the information into a table or a file either)?

Thank you,

Rui

Hello, we have an app with a pivot table that contains monthly values across multiple years, so when the columns are expanded, we have a two-level header. The top-level is the year and the bottom-level is the month. We'd like to use an Automation to extract data from this pivot table and put it into an Excel spreadsheet. Which block should we use to get data from a pivot table?

I need to create a column to the right that shows the change in historical values (both the difference and percentage change).

I have tried to prepare this in Excel and have provided a screenshot.

I have attached both the data and the Qlik Sense pivot table.

Data set

Qlik Sense Pivot table

Requirement