We had Log streaming Task # source is RDS postgres  where as we had 2 different targets  1 is EDB  postgres and other is RDS aurora ..

We had Source table having 54 columns and target table having only 52 columns .. we had removed 2 columns in the Tasks...

Do we have any limitations ?

Some sample errors#

Stream component 'st_0_PG_TCDP_MDHP_Tgt' terminated
Stream component failed at subtask 0, component st_0_PG_TCDP_MDHP_Tgt
Error executing data handler
Failed to get update statement for table parts_master_raw.parts_maintenance_cd, stream position 345;638516567649827200;20240418151639010679B|00007CB3/8E010800.2.00007CB3/8E010800
Failed to prepare statement 'UPDATE "parts_master_raw"."parts_maintenance_cd"

Stream component 'st_0_PG_TCDP_MDHP_Tgt' terminated
Stream component failed at subtask 0, component st_0_PG_TCDP_MDHP_Tgt
Error executing data handler
Endpoint is disconnected
Connection error
Failed to execute insert statement, stream position is 331;638515507882112120;20240418151639010679B|00007C97/64B259D0.2.00007C97/64B259D0
RetCode: SQL_ERROR SqlState: 08S01 NativeError: 35 Message: The connection has been lost;
The connection has been lost
Failed (retcode -1) to execute statement: 'INSERT INTO

Is there any way to notify if a engine node doesn't response or fails.

When users complained about getting errors as attached, found that in QMC one node became offline but Windows services shows running. Which is common.

So how I can set a notification if such things happens. So that I can quickly jump in and restart the services on that specific node?

Is there any logs I can check to find out what caused it?

Hi All, I am Emmanuel Katto from Uganda. Now living in UK. I am doing AWS cloud certification and learning various tools. Can someone please tell me how can I utilize the Qlik Cloud with AWS?

Thanks in advance!

Emmanuel Katto

Hello,

we are running Nprinting v21.14.07-May2021-SR03, which was installed in 2022 and that time LEF file with date 2022-12-31 on PRODUCTLEVEL line was used to activate product.

Last year our support contract ended so license expired 31-12-2023.

Now in May 2024 I downloaded Nprinting v23.20.1-May2023 and upgraded our server.
That version was released in 2023 so that time it was covered by active license and we should be able to use that version.

After upgrade web console is telling me "product expired".
I tried to generate/download with success LEF file. It has date 2023-12-31 on line beginning with string PRODUCTLEVEL. I'm not able to activate this upgraded server with this LEF file.
I think if I upgraded server in December 2023, it could work, but how to upgrade now, when LEF is expired?

I would like to upgrade to the highest version we have paid for when license was active, so I think v23.20.9-May2023-SR03 is the latest version we should be able to use.

Do you have any advice how to fix this "product expired" issue?

Thanks
Robert

I need to extract some data from Z transactions on SAP, the user only have Qlik Cloud.

In the past I extract this data with Report Connector in QlikView, but in Qlik Cloud I have no idea that how can I do this.

Thanks for helping

Hi,

  I have a requirement where I need to do a calculated dimension and use it as a dimension in qlikview bar chart. I use the below in expression tab and works fine. Not sure how to use it as a dimension,

if(rangesum( above( aggr(sum(Counts),Month),0,4) )<=1,'No count',if(rangesum( above( aggr(sum(Counts),Month),0,4) )>=61,'Normal count','Low count'))

My solution is to use this as a dimension and I calculate the count of employees under each category for a bar chart. I am using the above expression to calculate the rolling 3 months on employee level. Is it better to do it at a script level or chart level. 

For Qlik Compose for DW 2023.11.0.69 and SQL Server 2019 we have a full load task that runs couple of times a day. If this task is at 98% completion (1612/1633) and fails due to insufficient system memory or connectivity or any other server related issue, is there a way for Qlik Compose to recover or pick up where the load failed? Although not ideal, but if there's no way for Qlik Compose to recover is not possible, is a manual rerun of the failed and remaining ETL task statements an option? 

Thanks.

Hi there.

I'm following this document about to install the Data Movement Gateway: Setting up the Data Movement gateway 

Before init install, I checked the prerequisites about SO, as like write on document, the version 9 of Red Hat is compatible, so I install the CentOS Stream 9:

When I runned the command:

QLIK_CUSTOMER_AGREEMENT_ACCEPT=yes rpm -ivh qlik-data-gateway-data-movement.rpm

I received the error bellow:

Could someone help me about this error occurs?

=sum(Aggr(avg([Pieces Produced]),[2024 Jan Feb Prod.Part#]))

Above formula gives me average of Jan and Feb data.  (450+500+800)/3 = 583 (which is great).

However, can someone tell me how to modify above formula if I just want to see month of January Average?  It should be (450+500)/2= 475.  Thank you.