topic Re: Qlik Replicate Reload Reporting in Qlik Replicate

Qlik Replicate Reload Reporting

apouliou — Wed, 18 Oct 2023 07:40:36 GMT

Hi all, we use Qlik Replicate and want to automate one. We use this as a source
IBM DB2 for iSeries and target Oracle. I would like to know if it is possible to report a reload on a transformation. This means that when a reload has taken place, an entry should be created in a report table in the target database by entering the tabel-name, task and time of the last reload.

Re: Qlik Replicate Reload Reporting

boaz_newman — Wed, 18 Oct 2023 07:54:39 GMT

Hello

Replicate has a control table named attrep_history, you can add this table to each of your tasks, and it will create an entry in that table indicating the time of each realod (among other details)

Please see this page in the UG for more details:

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Control%20Tables/replication_history.htm#Replication%20history

Regards

boaz

Re: Qlik Replicate Reload Reporting

sureshkumar — Thu, 19 Oct 2023 02:16:10 GMT

Hello @apouliou

In addition to Boaz comment, In Replicate UI go to Monitor windows--> Tools--> History
where you can find Full Load history and you can export the details using "Export to TSV" option.

Regards,
Suresh

Re: Qlik Replicate Reload Reporting

apouliou — Thu, 19 Oct 2023 05:53:39 GMT

Hallo,

in der Tabelle attrep_history wird nur der Task-Name hinterlegt, nicht die Tabelle für die der Reload vorgenommen wurde. Gibt es Log-Tabelle / Methode bei der auch der Tabellen-Name hinterlegt ist?

Gruß Apostolos

Re: Qlik Replicate Reload Reporting

apouliou — Thu, 19 Oct 2023 05:54:51 GMT

Hallo,

ich wollte es automatisieren, ohne manuellen Eingriff.

Gruß

Re: Qlik Replicate Reload Reporting

boaz_newman — Wed, 25 Oct 2023 08:02:59 GMT

Hello

There is no option in Replicate to get a full load history on a table level. This information is available only in the task log.

Boaz

Re: Qlik Replicate Reload Reporting

Heinvandenheuvel — Fri, 27 Oct 2023 12:15:25 GMT

@boaz_newman "no option in Replicate to get a full load history on a table level."

Hmm, I think there is. Through the Enterprise Manager API the call is GetTableStatuses

Response:

{
"table_details":[
{
"schema_on_source":"{string}",
"table_on_source":"{string}",
"schema_on_target":"{string}",
"table_on_target":"{string}",
"state":"{enum}",
"data_errors_count":"{int64}",
"table_full_load_info":{
"start_time":"{string}",
"end_time":"{string}",
"estimated_row_count":"{int64}",
"estimated_end_time":"{string}",
"transferred_row_count":"{int64}",
"transferred_volume_mb":"{int64}"
},
"table_cdc_info":{ ...

The same information can be obtained (unsupported) through the REPCTL commandline interface:

repctl -d <\Replicate\data> gettablesstatus ?

state:optional enum, valid values: [btw... input and output Enums]
00 - TABLE_NOT_EXIST
01 - TABLE_BEFORE_LOAD
02 - TABLE_FULL_LOAD
04 - TABLE_COMPLETED
08 - TABLE_CANCELED
16 - TABLE_ERROR
127 - TABLE_ALL
128 - TABLE_UPDATES

fl_start_time:optional int64
fl_last_time:optional int64

Hein.