Hi Team,

I have QLik replicate 2022.11 version currently. I need to upgrade the version to 2023.5 (latest version). I would like to understand whether we can do downgrade install ie again from 2023.5 to 2022.11  in case of any issue? If so , what is the steps? 

i) As per the release note, it is necessary to uninstall the current version and install the version needed. In that case, will that impact the existing setup and all configurations ? what about license? Whether it is required to do license again after uninstall?

ii) If i want to stop all the task in qlik replicate before installation/uninstallation, what is the process for stopping and starting all task in one go (without any manual process) 

Thanks,

Mythili Boopathy

Hi,

I came across a scenario where the passthrough filter is surprisingly slower than the table filter in full load. What are the scenarios which can cause this to happen?

My understanding is that the passthrough filter offer greater performance as it alters the actual select statement sent to the source endpoint.

Regards,

Mohammed

We are running our replicate on windows server with Standard_E8s_v3 size. There will be two tasks always running on the server. 

One will always be in CDC mode and other runs full loads 3 times a day and continues in CDC mode remaining time.

The issue we are seeing is when there is a full load running on the second task the CPU is in upwards of 80% and there is a latency on the CDC task.

I heard that when a task is in full load each table will occupy 1 CPU , is it correct ? and each task will need 1 cpu when it is running

Hi,

I have run into some interesting behaviour while I was doing some testing. I have a task that goes from Oracle to SQL server with one table only. The source table and target tables don't have any primary key or unique indexes defined on them. However, in Replicate -> Table Settings -> Transform, I've defined a combination of three columns as keys.

I tested inserting some duplicates on the source database however these duplicates are not applied to the target database, even though the target has no primary key or unique index defined on it. How exactly does this work? How does Replicate identify duplicates? Does it read the incoming records then compare them against the target table to decide whether or not to apply them? Is this less performant than having the actual PK/Unique Index on the target table? Please help me understand how this works, it is appreciated as always. Thanks.

Regards,

Mohammed

Using Nov 2022 Qlik Replicate Version from Oracle 19c to Snowflake on AWS.

We are taking data from an application table and creating a hash on the concatenation of the key columns eg:

ifnull(colA,'')||ifnull(colB,'')||ifnull(colC,'') for all key columns and then set the hash of this as our primary key in snowflake (Target). However, I see that when a record gets updated, QLIK tries to set the target key column as null. This calls a not null constraint on our Snowflake DDL.

Our source has the same 3 columns as a unique index, but we hash and concat them into our solo target key.

Is there any way around having QLIK temporarily set the column to NULL or should we remove the not null constraint on our target table? The exception table is showing that is it updating our hash_key to null where hash_key = theoldvalue.

I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

Hi team , 

I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under expression builder>>functions>>UDF .

need some help on this . please let me know if additional details needed 

followed this . 
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note

Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser but when using the Qlik Mobile App, the CSRF call doesn't return a token. 

I submitted a support ticket but it was suggested to post here as well.

Hi,

I have a number of  periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersects with a period as per the example table below. 

I have tried with the DayNumberOfYear() function, which works fine as long as I'm in the same year, i.e. line 1, but when intervals and periods span over 31-dec, as per line 2 & 3, this approach is no longer giving correct results.  

Any assistance on how to solve this is highly appreciated. Regards//Peter

PS. interval_from & interval_to are user input hence solution need to be outside of the script.

The user has the following question:

Hello, I need to configure a condition in which the email is only triggered when my condition is satisfactory.

In my case, it will only send the email to those who are experiencing delays in the process.

When there was no such situation = late, the email should not be sent.

It happens that when the condition is satisfactory, it is sending an email without the attachment but with the email body message and the error message

In this case, the email was not supposed to be sent, as the condition is different from "Delayed"

Is this Qlik's default behavior?

Best Regards,
Junior de Sousa