topic Re: Qlik Replicate : Replication from SAP Oracle DB, Few tables are errored out as unsupported advanced compression in Qlik Replicate

Qlik Replicate : Replication from SAP Oracle DB, Few tables are errored out as unsupported advanced compression

Kohila — Thu, 20 Apr 2023 22:14:32 GMT

Hi Team,

We are doing replication from source SAP Oracle source (application end point), few tables in the ls task are getting suspended with the below error

Changes to table 'schema.tablename' cannot be captured as it is compressed using unsupported compression method ADVANCED.

We are using oracle version - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Access redo log via - Replicate log reader.

I could see all the tables in source are compressed with "for advance" option.

our replicate version - 2021.11

Also I have gone through the replicate guide, I could see above Oracle 11 g, OLTP compression method is supported. Is OLTP and advanced row compression is different from other? Is advanced is supported.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Oracle/Supported_Compression_Methods.htm

Some of our tables with Advanced compression capture the source changes. Could you please provide some input what would the cause of the issue here?

Thanks,

Re: Qlik Replicate : Replication from SAP Oracle DB, Few tables are errored out as unsupported advanced compression

SachinB — Fri, 21 Apr 2023 02:32:41 GMT

Hello @Kohila ,

As per the UG we do support below compression method based on log miner or log reader, Hope you are using as Log reader.

Version	Basic	OLTP	HCC (from Oracle 11g R2)	Others
Oracle 11 or later - Replicate Log Reader	Yes	Yes	Yes See Note below.	No
Oracle 11 or later - Oracle LogMiner	Yes	Yes	Yes	*Yes

Version

Basic

OLTP

HCC (from Oracle 11g R2)

Others

Oracle 11 or later - Replicate Log Reader

Yes

See Note below.

Oracle 11 or later - Oracle LogMiner

Yes

*Yes

OLTP compression and Advanced Row Compression are both row-level compression techniques, Advanced Compression is a more advanced form of compression that offers block-level compression and additional compression algorithms and techniques.

We would request you to set source_capture in verbose and provide us enhanced logs along with diagnostic package in order to trouble shoot the root cause of the issue, We would request you to create a support case so that we can guide you accordingly.

Thanks for understanding !!

Regards,

Sachin B

Re: Qlik Replicate : Replication from SAP Oracle DB, Few tables are errored out as unsupported advanced compression

Dana_Baldwin — Fri, 21 Apr 2023 17:34:06 GMT

Hi @Kohila

To add to what @SachinB shared - I checked Oracle's documentation on the difference between OLTP and advanced compression and it is not clear - they seem to be synonymous after version 11g. If you open a support case for this, we can elevate to our internal support team for a definitive answer.

Thanks,

Dana