Hi Team,

When I choose "LocalHost" for Target Exec job shows stats but when i select Job server stats gets disappeared.

Could you please help to resolve the issue.

Please help me to solve this query into qliksense script 

Where

(
 ( Nvl(pts7.actual_amount,0)>0 and nvl(PIs7.ACTUAL_AMOUNT,0)>0)
) and NVL(pis7.TRANSFERRED_TO_AP_FLAG,'N')='Y';

Our Source and Target system are cloud rds Postgres and Cloud Aurora Postgres respectively.

We had Source and Targets having same no of columns and Same primary Keys ..

However couple of table are frequently failing with 

Table 'lcadm'.'spb_shipment_route_exp (subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record

Table 'lcadm'.'spb_order' (subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record

(or)Table 'lcadm'.'spb_shipment_route_exp' (subtask 0 thread 1) is suspended. Failed to get delete statement for table lios_raw.spb_shipment_route_exp,
stream position 0000005F/4CECD9C8.53.0000005F/4CECF7188

We had referential integrity constraints (FK)  @ source. Does the source tables having Foreign keys will triggers above compute errors and suspend tables ? Please advise.  

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?

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

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