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

[john_wang]

Hello @lqthinguyen ,

Thank you so much for your feedback!

These are two different factors. Looks to me it does not matter with Advanced Compression but because of Partition/sub-partition operations are not supported.

In this scenario, the easiest way to overcome the Partition/sub-partition operations is reload the table. 

Regards,

John.

[lqthinguyen]

Good evening Mr. Wang,

Apparently they're external partitioned tables.   I assume you have to do a Full Load with Qlik Replicate when it comes to external tables ?

Thank you 

Theresa

[john_wang]

Hello @lqthinguyen ,

Please open support ticket and attach:

1. source table creation DDL

2. Set METADATA_MANAGE / SOURCE_CAPTURE/ SOURCE_UNLOAD to Verbose, recreate the issue and provide the Task Diagnostics Packages.

Support Team would like to check further for you.

Thanks,

John.