Top

I noticed today that some PixelPerfect reports fail to generate.

The following error appears in the report log. I also get the same error when I open the report in Designer and try to preview it.

WARN: error during report generation: 18:  The type 'NPrinting.Reporting.ReportingApp.PixelPerfect.Controls.PPChart' exists in both 'c:\Program Files (x86)\NPrinting\Designer\libs\NPrinting.PixelPerfect.dll' and 'c:\Program Files\NPrintingServer\NPrinting\Engine\Qlik.Reporting.Legacy.PixelPerfect.dll' 19:  The type 'NPrinting.Reporting.ReportingApp.PixelPerfect.Controls.PPChart' exists in both 'c:\Program Files (x86)\NPrinting\Designer\libs\NPrinting.PixelPerfect.dll' and 'c:\Program Files\NPrintingServer\NPrinting\Engine\Qlik.Reporting.Legacy.PixelPerfect.dll' 20:  The type 'NPrinting.Reporting.ReportingApp.PixelPerfect.Controls.PPChart' exists in both 'c:\Program Files (x86)\NPrinting\Designer\libs\NPrinting.PixelPerfect.dll' and 'c:\Program Files\NPrintingServer\NPrinting\Engine\Qlik.Reporting.Legacy.PixelPerfect.dll' 21:  The type 'NPrinting.Reporting.ReportingApp.PixelPerfect.Controls.PPChart' exists in both 'c:\Program Files (x86)\NPrinting\Designer\libs\NPrinting.PixelPerfect.dll' and 'c:\Program Files\NPrintingServer\NPrinting\Engine\Qlik.Reporting.Legacy.PixelPerfect.dll'

I uninstalled Designer and then reinstalled it but still the same.

Good day,

My apologies if I posted this under the wrong thread.

We currently have an issue when replicating data from Oracle to MSSQL.

A quick overview from our setup. Qlik Replicate reads from our standby (Read-Only) database Oracle, it does an initial full load and then activates the CDC. No problems there. But after a while randomly, let's say after a couple of days. It errors with the following errors:

Stream component 'st_0_FIN_READ' terminated
Stream component failed at subtask 0, component st_0_FIN_READ
Error executing source loop

Oracle CDC stopped

Cannot create Oracle directory name 'ATTUREP_0208B04002FIN_READ' with path '/u03/app/oracle/fast_recovery_area/FIN_READ/archivelog/2026_06_09'
OCI error 'ORA-01031: insufficient privileges'

As far as I understand, it's not supposed to create directories in this case - it's only supposed to read.

Can someone help with some ideas please?

I've been stuck on this problem for a few days now, slowly driving me crazy. I've looked all throughout this forum, but haven't found an instance of this specific issue. 

My problem is pretty involved, but I've distilled it down as much as possible to the below. The example below of course isn't my use case, it's just an easily reproducible example of the core behaviour I'm trying to achieve - using nested functions and evaluating their output inside other functions. 

So I have a function, say 

Set f_Format = Pick(Match($1, 'num','text'), NUM($2), TEXT($2));

It takes 2 parameters. $1 to choose whether the value will be formatted as a NUM or as TEXT, and $2 is the value to be formatted.

I have another function. 

Set f_Calc = PICK(Match($1, 'add', 'sub'), $2 + $3, $2 - $3);

This takes 3 parameters. $1 to decide whether to add, or subtract numbers. $2 and $3 takes two values to add or subtract. 

I want to use the f_Calc function to decide what calculation to use (whether to add or subtract), return that value, then use that value in the f_Format function to format it accordingly. The issue I have is the commas in f_Calc are being used to parse f_Format, so f_Calc is never evaluated.

$(f_Format(
	'num',
	$(f_Calc('add',4,3))
))

Hi

I am trying to build a docker image with the 2026 version of qlik replicate. I followed this manual: Installing Replicate on a docker | Qlik Replicate Help

I can build the image (base image is redhat ubi10), but when I run start_replicate.sh, it fails because this script calls /opt/attunity/replicate/bin/areplicate stop but this file does not exist.

I also found articles that a non-systemd installations of replicate can be started, stopped etc through a command that is named as <instancename> and that the default instancename is areplicate. 

So, why is my installation missing the <instancename> command/file?

Thanks

Hello Team,

I am working on writeback table for the User Entries. The requirement is when the User Enters the data, I want to store them in the backend and once I am reloading the application, those data appear in the filter, charts, KPIs and in the Table, also it shows the Updated data. I am not having S3 as connector to connect with Qlik Sense.  Available options I am having is PostgreSQL, Amazon RedShift, Rest API (Direct Access gateway), Athena (But this is a Query Editor not a Database storage)

Due to Access Limitation, I am not having a permission to create an API key. 

which would be the best option for me to discuss with the client for the Access.

Note: I am thinking of using PostgreSQL and connecting with Qlik sense using Username and Password.

I highly welcome your suggestion on the above-mentioned doubt.

Hello Support Team,

I hope you are doing well.

I would like to clarify the recommended settings when the source database uses Oracle SQL*Loader's Direct-Path INSERT.

My understanding is that because Oracle SQL*Loader's Direct-Path INSERT writes blocks directly to the disk without going through the buffer cache,
it does not generate REDO logs or archive log files.
Therefore, if we want to ensure REDO logs are generated, we need to either enable the table's LOGGING setting or switch to FORCE LOGGING mode.

Based on this, I assumed that Qlik Replicate would not be able to perform CDC on data inserted into the source DB via Oracle SQL*Loader's Direct-Path INSERT.
However, upon reviewing the limitations, I could not find any specific limitations or recommendations regarding Direct-Path INSERT.

Are there any recommended settings on the source Oracle database side when using Oracle SQL*Loader's Direct-Path INSERT?

Best regards.

Hi,

We have upgraded Qliksense to the latest May 2026 version, and it seems the multi-KPI visualization has been deprecated and Qliksense recommends using the natively supported custom styles option for sheet styling. I've tried to migrate CSS code from multi-KPI to sheet styling, but running into a problem that only half of the CSS code can be copied into the styles text editor. Is this intended? If so, why is there such a limitation on how many characters or lines of code we can use? Can someone explain? 

Hi Qlik/Talend Community,

I am facing an issue with a Talend job running in Talend Management Console / Talend Cloud.

I created a very simple test job that only contains a tOracleConnection component. The Oracle connection is fully parameterized using context variables.

The same job runs successfully in Talend Studio, but it fails when executed from TMC.

The context variables used in the tOracleConnection component are:

context.connection_oracle_lcllaborprod_host
context.connection_oracle_lcllaborprod_port
context.connection_oracle_lcllaborprod_sid
context.connection_oracle_lcllaborprod_schema
context.connection_oracle_lcllaborprod_username
context.connection_oracle_lcllaborprod_Password

The TMC error is:

tDBConnection_1 IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]"

java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]"
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:903)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:820)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:80)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:620)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)

To troubleshoot, I added a temporary tJava component before the tOracleConnection to print the context values in TMC. The result shows that the values are blank or null:

Oracle Host = 
Oracle Port = null
Oracle SID/Service = 
Oracle Schema = 
Oracle Username = 

I did not print the password for security reasons.

This confirms that the issue is not the Oracle connection itself. The issue appears to be that TMC is not passing or resolving the context parameters at runtime, even though the same context works correctly in Studio.

Could someone please advise on the correct way to configure and pass context variables in TMC/Talend Cloud?

Specifically, I would like to confirm:

1. Do context variables need to be manually defined in the TMC Run Profile, Environment, or Task configuration?

2. Is there a specific place in TMC where these context parameters must be mapped before running the job?

3. Is there any known issue where Studio context values are not automatically published/deployed to TMC?

4. What is the recommended approach for managing Oracle connection context variables between Studio and TMC?

Any guidance would be appreciated.

Thank you!

I'm having trouble with an automation the deletes and rebuilds an Excel file on SharePoint. This is my flow:

The "Add Row To Table" gets this error:

I'm not sure which property is wrecking it. Maybe the Row? I've entered the names of the columns of the table.

Material, Material Description, Total Open Qty, Inventory Qty, Build Qty

any ideas?

Thanks!

Mike

Hello all,

I know that there are several similiar topics, but too specific with no big picture included 🙂 I wanted to summarize here and verify with you all possible backup options of Qlik Cloud platform. As far as I know there is no native backup from Qlik side and once someone will remove space/app/qaa/datafile/dc by accident, there is no way how to restore it using Qlik support (there is probably some, but not official and if so I suppose it will be extra paid service).

I have several options on my mind and I would like to hear your opinion or experience so far:

1. Manually and regurarly download content (non sense, too much work)
2. Use Qlik CLI to export all apps as json files + folders as space + other objects as json? 
3. Use QAA and backup apps to Github as json files + folders as spaces + others if possible? (some version here)
   1. Not ideal case for Github version control logic
4. Use some paid external 3rd party tools (products from Motio etc.)

But what I miss in all mentioned solution is to be able to save also configuration of following items (not only apps):

• spaces - members + permissions
• datafiles - reside in spaces
• data connections - reside in spaces
• QAA's - reside in personal space

As there is API utilization possibility within QAA/Qlik CLI there is a chance to cover this portfolio at least partially, but not all mentioned areas can be covered as endpoints are limited and does not contain the content itself, just some metadata of items.

Any idea how to make backups with as much items as possible with reasonable solution?

Regards

petrus

Hi All,

I have a delimited file, which look like that:

father_id;father_name;children_id;children_name;children_birthdate

01;ndika;120;toto;25/04/2020
01;ndika;121;titi;20/032019

02;nj0120;523;nantes;10/06/2000
03;jf2563;426;leHavre;5/07/2001

And i want to generate a XML file by father di which will be for example like that for father_id = 01

Hi all,

I'm replicating mainframe data using this pipeline:

ARC CDC Solution (defined in Attunity Studio) → Qlik Replicate → Google BigQuery

Replicate reads from an ARC CDC Solution (non-relational source). The final string-to-numeric conversion happens in BigQuery.

Design choice: to avoid decimal-separator issues (comma/point) and loss/shift of decimal digits during numeric-to-numeric conversion across systems, we are bringing every field across as a STRING and reconverting it to numeric in BigQuery.

This works fine for DISPLAY (zoned) fields, including those with an explicit comma, e.g.:

ISTIPULA PIC 9(13),9(02)
RESIDUO PIC 9(13),9(02)

These carry through cleanly as strings because the bytes are already readable characters.

The problem is a packed-decimal field:

IMP_RINEGOZIATO PIC S9(15) COMP-3

When this field is read/exposed as char/string, we get garbage/non-printable characters (e.g. ¥, corrupted symbols) instead of the digits, because the underlying bytes are packed (8 physical bytes, nibble-encoded) and are not being decoded.

In the .tbl / source metadata the field is currently defined as:

<field datatype="decimal" name="IMP_RINEGOZIATO" size="15"/>

My questions:

1. What is the recommended/supported way to define a COMP-3 packed-decimal field in an ARC CDC Solution so Replicate receives the correctly decoded numeric value? Should it stay a numeric/decimal type in the source metadata rather than char/string?

2. For COMP-3 fields that DO have an implied decimal (e.g. PIC S9(13)V9(2) COMP-3), how should scale be set so the decimal position is preserved and not shifted?

3. Is there a documented data-type mapping table for ARC/packed COMP-3 source types? I found the "ARC source data type mapping" help page pointing to the CDC Solution reference, but I'd appreciate a pointer to the exact section.

Thanks in advance for any guidance.

When a Qliksense app is loading a excel file from SharePoint site, I am getting an message as "Bad Zip File: Failed to open ooxml file" attached the image of the error.

Hello, community!

I found the second LogVoyagers, presented by @igoralcantara  and edited by @marksouzacosta , very interesting. It is always impactful to discover how a historical tragedy became an important source of scientific knowledge.

The post shows how famine experienced during pregnancy can leave lasting effects on health for decades, and how the data helped researchers better understand the relationship between nutrition, epigenetics, and disease.

Highly recommended!

Link: The Voyagers Log 02 - The dataset that should have never existed