topic problem with replicate [Oracle source to Oracle target] in Qlik Replicate

problem with replicate [Oracle source to Oracle target]

Daud — Tue, 26 May 2020 08:26:57 GMT

Hello all

I am new to Attunity (Qlik). I am testing it and trying to learn it before I deploy it to production environment.

The setup is very simple; the source is Oracle 11 and the target is also Oracle 11.

I created one task to replicate just a single table; this table has over 11m records.

It is easy to setup the replication but it does not work as expected. The changes are not getting applied at the target after the initial load. If i look at the task, the initial load shows 100% complete. But for the changes, everything is 0 even though there are changes getting commited in the source table.

I have enabled supplemental logging in the source database. There is no transformation; it is a one-to-one mapping for each column from source to target.

Did I miss something? In the log file, i saw what looked like an error or warning. See below.

How do I solve this?

thanks.

Daud

Re: problem with replicate [Oracle source to Oracle target]

PGN — Tue, 26 May 2020 18:59:40 GMT

Under the task properties, is Apply Change Processing set to on? I believe the default is Yes, but it may have gotten changed. You would not need store changes (the second option), unless you plan to use _CDC (change data capture) tables.

Re: problem with replicate [Oracle source to Oracle target]

Daud — Wed, 27 May 2020 01:00:07 GMT

Yes it is on.

The first 2 options are on. Only the 'Store Changes' are off.

Thanks.

Re: problem with replicate [Oracle source to Oracle target]

rommel_oli — Wed, 27 May 2020 02:28:58 GMT

Have you followed all the requirements needed in the source specifically the grants needed?

Re: problem with replicate [Oracle source to Oracle target]

Daud — Wed, 27 May 2020 02:45:58 GMT

Yes, I have.

Re: problem with replicate [Oracle source to Oracle target]

Ola_Mayer — Thu, 28 May 2020 16:16:09 GMT

I think at this point it is impossible for us to debug your setup over this forum discussion. Can you please open a support case?

Thank you

Re: problem with replicate [Oracle source to Oracle target]

Daud — Thu, 28 May 2020 23:32:32 GMT

The problem seems to be our choice of using Attunity Log Reader. When we switched to using oracle logminer, it seems to work fine.

My colleague in the US will log a report with Attunity.

Thanks.

Re: problem with replicate [Oracle source to Oracle target]

Attunity_user — Tue, 02 Jun 2020 13:37:52 GMT

Hi Daud,

If it is an Attunity log reader issue, maybe it's because of the redo log file that gets saved in the Attunity server is not getting logged successfully. This tool is fairly new for us and the source & target is Oracle as well.

Thanks