Internal Setting useZeroDestid

PJP — Thu, 19 Aug 2021 12:54:06 GMT

Hi,

Did a search in Qlik Support and google but nothing is found for internal setting "useZeroDestid" on the advanced tab for source endpoint.

Anyone know what it means/does?

Thank you.

Re: Internal Setting useZeroDestid

john_wang — Thu, 19 Aug 2021 23:51:22 GMT

Hello @PJP ,

Thanks for you contacting Qlik Support.

DEST_ID, Log archive destination parameter identifier, is a non-negative integer value from 1 - 31 for each possible standby destination. In Oracle docs, it says "The value is 0 if the destination identifier is not available.":
https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/V-ARCHIVED_LOG.html#GUID-51618DF3-0C20-40E1-B94F-212FDF7CD729

However, in real world, some Oracle database instances are working with DEST_ID set to 0. To support this rare scenario you need enable this parameter (the name is case sensitive) in Replicate Oracle source endpoint, see "Internal parameters" in

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

Hope this helps.

Regards,

John.

topic Re: Internal Setting useZeroDestid in Qlik Replicate

Internal Setting useZeroDestid

Re: Internal Setting useZeroDestid