topic Re: LogFile Query Interpretation of the parameters %s, :1, :2 in Qlik Replicate

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

lqthinguyen — Sun, 05 Nov 2023 00:04:48 GMT

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

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

john_wang — Sun, 05 Nov 2023 01:38:31 GMT

Hello @lqthinguyen ,

Thanks for reaching out to Qlik Community!

I did not find a similar query in my task log files however you are right - Qlik Replicate utilizes these queries to verify if the tables/views exist. The system view name should be ALL_OBJECTS (%s). The schema name and table/view name (parameters :1 & :2) can be found in the string:

for 'BAIM.CU_PHASE_JB_HIST_PK'

Besides that, the task log file context (eg the previous line(s)) may indicate the object identifier as well if you enable the components (eg source_capture/source_unload/target_apply/target_load) logging to Trace or Verbose.

In general Oracle error ORA-00942: table or view does not exist. meaning the account have not privilege to access the table/view, or it does not exist indeed. you may verify that by executing the query with the same account:

select * from BAIM.CU_PHASE_JB_HIST_PK where 1=0;

Hope this helps.

John.

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

lqthinguyen — Sun, 05 Nov 2023 03:51:42 GMT

Good evening Mr. Wang,

Thank you for the quick reply; meanwhile CU_PHASE_JB_HIST_PK is a primary key but the following queries were executed prior to logging this case

1) CU_PHASE_JB_HIST_PK is a partitioned index

SQL> select index_name, partitioned from all_indexes where index_name = 'CU_PHASE_JB_HIST_PK';

INDEX_NAME

--------------------------------------------------------------------------------

PAR

---

CU_PHASE_JB_HIST_PK

YES

2) There is NO object_id value based on the Qlik Replicate log

Changes to partitioned IOT 'BAIM.CU_PHASE_JB_HIST' cannot be captured as its object ids cannot be retrieved

3) There is NO data_object_id value also RETURNED for this index

SQL> select object_name, data_object_id from all_objects where owner='BAIM' and object_name in ('CU_PHASE_JB_HIST_PK');

OBJECT_NAME

--------------------------------------------------------------------------------

DATA_OBJECT_ID

--------------

CU_PHASE_JB_HIST_PK

You have confirmed for me that %s is ALL_OBJECTS; therefore I will need to investigate on my end when it comes to the OBJECT_ID for this query.

Thank you and take care,

Theresa

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

lqthinguyen — Sun, 05 Nov 2023 04:12:23 GMT

Good evening

Clarification: I need to run the query again to make sure that there is a object_id for the CU_PHASE_JB_HIST_PK primary key. data_object_id signifies the foreign key value

I also need to educate myself how Qlik Replicate handles IOT partitioned tables and indices.

Once again you did answered my question that %s = ALL_OBJECTS/

Thank you

Theresa

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

john_wang — Sun, 05 Nov 2023 04:38:55 GMT

Hello @lqthinguyen ,

Thank you so much for your feedback. BTW, looks like there is about 12 hours' time difference between us, reply delay is expected sometimes.

From the information you provided, seems the table type is IOT:

Changes to partitioned IOT 'BAIM.CU_PHASE_JB_HIST' cannot be captured as its object ids
 cannot be retrieved

please take note there are some limitations of the index relative tables:

Function-based indexes are not supported
Index-organized tables with an overflow segment are not supported in Change Processing (CDC) tasks
Changes to Index-organized tables with key compression are not supported

Please confirm if the table is in above limitation scope.

Best Regards,

John.

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

lqthinguyen — Sun, 05 Nov 2023 08:18:21 GMT

Good morning Mr. Wang,

THANK YOU!! for the reminder with "Limitations and considerations when using an Oracle source" when it comes to an Index-Organized tables with an overflow segment.

Do you have a suggestion how to bypass it?

Unless we have to manually export from SOURCE and then import into TARGET.

Take care,

Theresa Nguyen

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

john_wang — Sun, 05 Nov 2023 08:36:44 GMT

Hello @lqthinguyen ,

Thanks for your verification.

The limitation applies to CDC stage. We may use a "Full Load ONLY" task (both of the "Apply Changes" & "Store Changes" are turned off in Task Change Processing setting) to replicate these types of tables. And also, we can run the Full Load ONLY task in a period loop eg running it once per day etc. I'm attaching a task setting sample:

Feel free to let me know if you need any additional assistance.

Best Regards,

John.

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

lqthinguyen — Tue, 07 Nov 2023 17:06:54 GMT

Good morning Mr. Wang,

We performed another "Full Load ONLY"; yet still encounter the same error. Please advise sir; meanwhile I am doing my research also. THANK YOU!

The exact messages coming out of the log file

00004892: 2023-11-03T15:43:07 [METADATA_MANAGE ]E:  ORA-00942: table or view does not exist  [1020416]  (oracle_endpoint_table.c:2707)

00004892: 2023-11-03T15:43:07 [METADATA_MANAGE ]E:  Failed to execute statement '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' [1020416]  (oracle_endpoint_table.c:2708)

00004892: 2023-11-03T15:43:07 [METADATA_MANAGE ]W:  Changes to partitioned IOT 'BAIM.CU_PHASE_JB_HIST' cannot be captured as its object ids cannot be retrieved  (oracle_endpoint_table.c:2817)

00004892: 2023-11-03T15:43:07 [METADATA_MANAGE ]E:  Failed to get the capture list from the endpoint [1020416]  (metadatamanager.c:4389)

00004892: 2023-11-03T15:43:07 [TABLES_MANAGER  ]E:  Cannot get captured tables list [1020416]  (tasktablesmanager.c:1040)

00004892: 2023-11-03T15:43:07 [TASK_MANAGER    ]E:  Build tables list failed

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

lqthinguyen — Wed, 08 Nov 2023 02:56:54 GMT

Good evening Mr. Wang,

It turned out that the interested that I inquired at the very beginning of this thread was querying against the 'dba_objects' view; instead the 'all_objects' one. This showed up on our Oracle trace file

select object_id, data_object_id from dba_objects where owner=:1 and object_name = :2 and data_object_id is not null and object_type in ('INDEX PARTITION', 'INDEX SUBPARTITION')

We will perform a Full Load Replicate again; once the DBA team execute the GRANT SELECT ON dba_objects TO <username>

Thank you, Mr. Wang

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

john_wang — Wed, 08 Nov 2023 07:02:19 GMT

Thank you so much for the feedback @lqthinguyen

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

lqthinguyen — Fri, 17 Nov 2023 03:49:14 GMT

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

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

john_wang — Fri, 17 Nov 2023 13:44:36 GMT

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.

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

lqthinguyen — Wed, 22 Nov 2023 05:31:12 GMT

Good evening Mr. Wang,

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

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

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

lqthinguyen — Wed, 22 Nov 2023 06:04:31 GMT

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

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

john_wang — Wed, 22 Nov 2023 07:03:21 GMT

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.

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

lqthinguyen — Fri, 01 Dec 2023 05:06:39 GMT

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

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

lqthinguyen — Fri, 01 Dec 2023 05:30:33 GMT

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.

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

john_wang — Fri, 01 Dec 2023 08:01:36 GMT

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.

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

lqthinguyen — Sat, 02 Dec 2023 02:16:27 GMT

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

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

lqthinguyen — Sat, 02 Dec 2023 02:23:56 GMT

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)