LogFile Query Interpretation of the parameters %s, :1, :2

[lqthinguyen]

Good evening 

Good evening

Please enlighten me as to where to find the values for %s, :1, and :2 in the Qlik Replicate Log or ? for the below query.
Because we received the following Oracle error ORA-00942: table or view does not exist

select object_id, data_object_id 
from %s 
where 
owner=:1 and 
object_name = :2 and 
data_object_id is not null and 
object_type in ('INDEX PARTITION', 'INDEX SUBPARTITION')' for 'BAIM.CU_PHASE_JB_HIST_PK'


Based on reverse engineering &&
queried against the dba_tab_columns table for entities that have object_id, data_object_id, owner, and object_type columns 
I assume :1 => BAIM
:2 => CU_PHASE_JB_HIST_PK
%s => dba_objects, all_objects, etc


Thank you and take care,


Theresa

[lqthinguyen]

Good evening Mr. Wang,

Please enlighten me when does Qlik Replicate queries the dba_objects vs all_objects view to obtain the object_id and data_object_id for an entity.

Note: We are using Oracle 19c

Thank you 

Theresa Nguyen

[john_wang]

Hello @lqthinguyen ,

Looks to me there is confusion in the User Guide General permissions section:

• SELECT on ALL_OBJECTS
• SELECT on DBA_OBJECTS - Required if the Oracle version is earlier than 11.2.0.3.

Obviously it's inaccurate. Please open the support ticket, the support team will help to get confirmation for you.

Regards,

John.

[lqthinguyen]

Good evening Mr. Wang,

It would be nice if you could please clarify for me that 

1. Changes to Index-organized tables with key compression are not supported in both Full-Load as well as CDC

Thank you and take care,

Theresa Nguyen

[lqthinguyen]

Good evening Mr. Wang,

I assume "Changes to index-organized tables with key compression are not supported in CDC" ? while it's with Full-Load?

Otherwise please provide instruction(s) on how to skip on replicating certain index.

Thank you and take care,

Theresa

[john_wang]

Hello @lqthinguyen ,

I just realized I missed your comments, my apologies.

Changes to Index-organized tables with key compression are not supported is a limitation applies to CDC stage only. The Full Load works fine. So far for these types of tables, utilizing a Full Load ONLY task is a work around.

Regards,
John.

[lqthinguyen]

Good evening Mr. Wang,

I have two questions

1) If Qlik Replicate supports ADVANCED COMPRESSION on a partition/sub-partition table with Oracle for the SOURCE ?

2) What does this mean because I have partition/sub-partition table in SOURCE

Replicate changes resulting from partition/sub-partition operations, you need to reload the tables in question. When adding a new empty partition, operations on the newly added partition will be replicated to the target as normal.

Thank you 

[lqthinguyen]

Good evening,

I believe I found the answer to my second question

Data changes resulting from partition/sub-partition operations (ADD, DROP, EXCHANGE and TRUNCATE) will not be replicated and may cause the following errors:

• For ADD operations, updates and deletes on the added data may return a "0 rows affected" warning.
• For DROP and TRUNCATE operations, new inserts may result in "duplicates" errors.

• For EXCHANGE operations, both a "0 rows affected" warning and "duplicates" errors may be encountered.

[john_wang]

Hello @lqthinguyen ,

Thank you so much for the feedback! it's valuable information!

Regarding the Supported compression methods, in Qlik Replicate User Guide the supported Compression Methods are:

From what I read in Oracle related docs, Advanced Row Compression is synonymous with OLTP Compression from Oracle 12C and above. Not sure if you are facing any issue around the Advanced Compressed Table(s)?

Regards,

John.

[lqthinguyen]

Good evening

I am facing issue around the Advanced Compressed Tables; on the other hand they are also partitioned tables too.   Does that mean with partitioned/sub-partitioned tables you have to perform FULL LOAD because CDC doesn't work ? 

Thank you 

Theresa Nguyen

[lqthinguyen]

Good evening Mr. Wang,

Here is a clip of the log file

Going to prepare the statement 'select NVL(compression,' '), compress_for, NVL((select NVL(encrypted, ' ') from dba_tablespaces where dba_tablespaces.tablespace_name = all_tab_partitions.tablespace_name), ' ') from all_tab_partitions where table_owner=:1 and table_name = :2 (oracle_endpoint_table.c:2589)
00009592: 2023-11-30T21:41:26:186137 [METADATA_MANAGE ]T: Going to prepare statement 'select object_id, data_object_id from all_objects where owner=:1 and object_name = :2 and data_object_id is not null and object_type in ('TABLE PARTITION', 'TABLE SUBPARTITION')' (oracle_endpoint_table.c:2694)
00009592: 2023-11-30T21:41:47:514221 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110131219' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:514221 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110151135' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:616326 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110181110' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:616326 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110190935' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:716366 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110201010' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:716498 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110201930' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:801909 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110210922' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:801909 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110212042' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:898920 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202110220640' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:898920 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210120912' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:994368 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210121925' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:47:994368 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210130843' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:91067 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210131810' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:91067 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210141148' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:188160 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210141915' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:188160 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202210171128' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:285327 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202310101127' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:285327 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202310101839' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:430548 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202310111209' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00009592: 2023-11-30T21:41:48:430548 [METADATA_MANAGE ]I: Table 'COST.AUTH_ST_202310111929' is compressed for ADVANCED (oracle_endpoint_lists.c:1065)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Stream stream_0. Source locks buffer 0 (stream.c:2071)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Source buffer in use 0 (stream.c:3266)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Target buffer in use 0 (stream.c:3267)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Data buffer 0. Ready 0, Records 0, used 0 (stream.c:3277)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Data buffer 1. Ready 0, Records 0, used 0 (stream.c:3277)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Enqueue notify record 'TASK_COMMAND' to stream stream_0 (stream.c:1531)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Stream stream_0. Source flushes buffer 0. Records in buffer 1 (stream.c:1705)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Source buffer in use 0 (stream.c:3266)
00004308: 2023-11-30T21:43:59:109886 [STREAM ]V: Target buffer in use 0 (stream.c:3267)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 0. Ready 1, Records 1, used 176 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 1. Ready 0, Records 0, used 0 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Stream stream_0. Source locks buffer 0 (stream.c:2071)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Source buffer in use 0 (stream.c:3266)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Target buffer in use 0 (stream.c:3267)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 0. Ready 0, Records 1, used 176 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 1. Ready 0, Records 0, used 0 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Enqueue notify record 'TASK_COMMAND' to stream stream_0 (stream.c:1531)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Stream stream_0. Source flushes buffer 0. Records in buffer 2 (stream.c:1705)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Source buffer in use 0 (stream.c:3266)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Target buffer in use 0 (stream.c:3267)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 0. Ready 1, Records 2, used 344 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [STREAM ]V: Data buffer 1. Ready 0, Records 0, used 0 (stream.c:3277)
00004308: 2023-11-30T21:43:59:110887 [INFRASTRUCTURE ]T: requested to load class <AR_ENDPOINT_SERVERS_MGR> from <arepcustom> (at_loader.c:388)
00004308: 2023-11-30T21:43:59:110887 [INFRASTRUCTURE ]V: load_dll: -> (at_loader.c:146)
00004308: 2023-11-30T21:43:59:110887 [INFRASTRUCTURE ]T: intend to load dll <arepcustom> (at_loader.c:153)
00004308: 2023-11-30T21:43:59:110887 [INFRASTRUCTURE ]V: load_dll: -> (at_loader.c:110)
00004308: 2023-11-30T21:43:59:110887 [INFRASTRUCTURE ]T: full dll path is <C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_loader.c:255)
00004308: 2023-11-30T21:43:59:110887 [IO ]V: combine_path: rootPath=<null>, addPath=<null> (at_dir.c:1014)
00004308: 2023-11-30T21:43:59:110887 [IO ]V: combine_path: result before canonize=<C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_dir.c:1025)
00004308: 2023-11-30T21:43:59:110887 [IO ]V: combine_path: result=<C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_dir.c:1031)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: checking if dll init method exists <at_ldr_on_load> (at_loader.c:75)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: no init method for the loaded dll (at_loader.c:96)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]V: load_dll: <- (at_loader.c:209)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: going to call loaded method for class <AR_ENDPOINT_SERVERS_MGR> (at_loader.c:348)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: load method for class <AR_ENDPOINT_SERVERS_MGR> was called successfully (at_loader.c:352)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class type is <AR_ENDPOINT_SERVERS_MGR class> (at_loader.c:418)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class version is 1.1 (at_loader.c:280)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: load info class version is 1.1 (at_loader.c:281)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: calling class init method (at_loader.c:309)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: requested to load class <ar_custom_endpoint_client> from <arepcustom> (at_loader.c:388)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]V: load_dll: -> (at_loader.c:146)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: intend to load dll <arepcustom> (at_loader.c:153)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]V: load_dll: -> (at_loader.c:110)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: full dll path is <C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_loader.c:255)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: rootPath=<null>, addPath=<null> (at_dir.c:1014)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: result before canonize=<C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_dir.c:1025)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: result=<C:\Program Files\Attunity\Replicate\bin\arepcustom.dll> (at_dir.c:1031)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: checking if dll init method exists <at_ldr_on_load> (at_loader.c:75)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: no init method for the loaded dll (at_loader.c:96)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]V: load_dll: <- (at_loader.c:209)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: going to call loaded method for class <ar_custom_endpoint_client> (at_loader.c:348)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: load method for class <ar_custom_endpoint_client> was called successfully (at_loader.c:352)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class type is <ar_custom_endpoint_client class> (at_loader.c:418)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class version is 1.1 (at_loader.c:280)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: load info class version is 1.1 (at_loader.c:281)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: calling class init method (at_loader.c:309)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class init method was called (at_loader.c:314)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: rootPath=<C:\Program Files\Attunity\Replicate\>, addPath=<C:\Program Files\Attunity\Replicate\> (at_dir.c:1014)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: result=<C:\Program Files\Attunity\Replicate\endpoint_srv> (at_dir.c:1031)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: rootPath=<C:\Program Files\Attunity\Replicate\endpoint_srv>, addPath=<C:\Program Files\Attunity\Replicate\endpoint_srv> (at_dir.c:1014)
00004308: 2023-11-30T21:43:59:114065 [IO ]V: combine_path: result=<C:\Program Files\Attunity\Replicate\endpoint_srv\bin> (at_dir.c:1031)
00004308: 2023-11-30T21:43:59:114065 [INFRASTRUCTURE ]T: class init method was called (at_loader.c:314)
00009592: 2023-11-30T22:12:19:313711 [METADATA_MANAGE ]T: Going to prepare the statement 'select INDEX_NAME, NVL(prefix_length, 0) from ALL_INDEXES where table_owner = :1 and table_name = :2 and INDEX_TYPE like 'IOT%%'' for 'COST.JNLU_REF' (oracle_endpoint_table.c:2466)
00009592: 2023-11-30T22:12:19:403535 [METADATA_MANAGE ]T: Going to prepare the statement 'select object_id, NVL(data_object_id, 0) from ALL_OBJECTS where owner=:1 and object_name = :2 and object_type = 'INDEX'' for 'COST.JNLU_REF_PK' (oracle_endpoint_table.c:2516)