changes PK to a PK that was previously updated in the same bulk

[david_lange]

How do I dtermine what database table/pk is causing this?

00000520: 2022-08-23T16:04:27 [TARGET_APPLY    ]T:  The current bulk was applied. The last confirmed record id = 0, the last record id = 16760073264  (bulk_apply.c:2485)

00000520: 2022-08-23T16:04:27 [TARGET_APPLY    ]T:  First bulk event: record_id = 16760073265, stream_position ='0000007d.2430478c.00000001.0000.01.0000:81615.560588.16'  (bulk_apply.c:1189)

00000520: 2022-08-23T16:04:38 [TARGET_APPLY    ]T:  Update on table 79 changes PK to a PK that was previously updated in the same bulk  (bulk_apply.c:1451)

00000520: 2022-08-23T16:04:38 [TARGET_APPLY    ]T:  Bulk finished. First record 16760073265. Last Record Id 16760902056. Skip until record Id 0  (bulk_apply.c:2236)

[Michael_Litz · Accepted solution]

Hi David,

Please check the task log that is related to the full load phase of the task. During the full load each table is named and assigned a number.

00000520: 2022-08-23T16:04:38 [TARGET_APPLY    ]T:  Update on table 79 changes PK to a PK that was previously updated in the same bulk  (bulk_apply.c:1451)

Search for 79 and you should see the table name.

Let me know if this helps out.

Thanks
Michael

[shashi_holla · Accepted solution]

Another way to get the table details is from task diagnostics package (DP) but it requires that you are on Replicate server and have admin access on the machine.

1) Generate the DP 

2) Open command prompt (as Administrator) and navigate to <installation dir>\Attunity\Replicate\bin

If the Replicate is installed in C drive then <installation dir> would  be C:\Program Files (It's just to provide the idea). 

3) Run the following command:

repctl dumpmetadata sqlite_file="<unzipped diagnostics package folder>\Metadata\dynamic_metadata.sqlite" out_dir="<directory where Replicate has access to>\Metadata" create_sub_dir=true

4) This will create a folder in the mentioned patch and it will have a json named "table_descs.json" which has ID and definition of all the tables in the task.

Hope this helps.