Hello.

When Teradata is specified as the target endpoint, My understanding is that Qlik Replicate creates log and error tables (with table names ending in *L0, *E1, or *E2 and so on).

Could you please confirm when these tables are generated, and whether they need to be manually deleted?

If manual deletion is required, we assume that the relevant task should be stopped beforehand.
Aside from that, if there are any other precautions or considerations we should be aware of, your guidance would be greatly appreciated.

[Background of the question]
A large number of log and error tables have been created and the customer would like to clean them up as part of system maintenance.

Best Regards.

Hello,

I have an app with two sheets.

One sheet A, user can select three dimension [Area] (Region), [Destination], and [Department] (Departement).

One sheet B with different table where one table is filtered by only one Area (that's the view the final user would like). My dimension [Area] has multiple data but the final user want to see only 4 areas - It means 4 differrent table.

My column [Destination] is filtered too.

I have attached the sheet B in order you can see how I would like the sheet look like at the end.

My problem is when the user is selecting an[AREA] or a [DESTINATION] on sheet A, all my table on sheet B are filtered by the user selection which is Qlik normal way. But that's not what I want !

I've tried to use set analysis on column but with no success.

Please find below the set expression of each column :

[AREA] (Region) : =If(Left(AREA,2)<>'11',Null(),AREA_NAME)

[DESTINATION] : =If(Lower(Destination)<>'bureau' AND Lower(Destination)<>'commerce' AND Lower(Destination)<>'services publics' AND Lower(Destination)<>'industrie' ,Null(),Destination)

[202506-12M] : SUM($(vSLC_12M_AnneeMois))

[202506-12M] : SUM($(vSLC_12M_AnneeMois-Y-1))

Etc...

Hope it's clear ! Not easy to explain in english 😉

Thanks for your  help

Hello

[Background of the Question]
My customer does POC IBM DB2 for iSeries Source.
Customer gets below errors for some tables when he run task. (I am receiving inquiries every time it occurs.)
- converter 836 not found.
- converter 1027 not found.

I understand that those errors occure when Qlik Replicate doesn't have converter correspond to source table's CCSID and that I need to set "Override CCSID to Character Set Mapping" in IBM DB2 for iSeries source endpoint.

I found below post and I already know I can map the CCSID 836 to 935.
https://community.qlik.com/t5/Qlik-Replicate/Cannot-refresh-source-table/td-p/2141999

[Question]
1. What can I map the CCSID 1027 to?
2. I think customer may get similar error for other CCSID yet in future test.
I need ask you everytime?
Is there a way I can find alternative CCSID for any problematic CCSID?

Best Regards
Nakagawa

Hi all,

New to Talend but I've been around a long time with data and coding.

I need to pull data from a bunch of servers that have a consistent database and table name structure. I've set up a basic tDBConnection->tDBInput->tLogRow->tDBClose prototype that works fine.

Then I've added a tJava at the very beginning to try to get the Connection as an object, with a view to updating the Host in the Connection dynamically. The aim is to change this to some kind of Iterator, once I've proven this can work.

Unfortunately I'm not having any luck getting the Connection in the tJava, which throws this at runtime:

Starting job ConnectionTest at 14:38 28/08/2025.
[statistics] connecting to socket on port 3689
[statistics] connected
Exception in component tJava_1 (ConnectionTest)
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.getMetaData()" because "c" is null
at xxx.connectiontest_0_1.ConnectionTest.tJava_1Process(ConnectionTest.java:552)
at xxx.connectiontest_0_1.ConnectionTest.runJobInTOS(ConnectionTest.java:2397)
at xxx.connectiontest_0_1.ConnectionTest.main(ConnectionTest.java:2035)
[FATAL] 14:38:56 xxx.connectiontest_0_1.ConnectionTest- tJava_1 Cannot invoke "java.sql.Connection.getMetaData()" because "c" is null
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.getMetaData()" because "c" is null
at xxx.connectiontest_0_1.ConnectionTest.tJava_1Process(ConnectionTest.java:552) [classes/:?]
at xxx.connectiontest_0_1.ConnectionTest.runJobInTOS(ConnectionTest.java:2397) [classes/:?]
at xxx.connectiontest_0_1.ConnectionTest.main(ConnectionTest.java:2035) [classes/:?]
[statistics] disconnected

Job ConnectionTest ended at 14:38 28/08/2025. [Exit code = 1]

See attachment for what I have, which is working so long as the tJava is disabled.

Any suggestions would be gratefully received.