I have been able to sync most of my required tables. For a few of the very large tables, the initial sync failed, 0 records transferred. We have now resolved the reasons for the failure, and sync is running again. It looks like on this second run, the table is not being split according to ‘maximum records per engine’, and the engine times out? using the BC admin tool and checking the background sessions, I can’t see anything active.
Is there a way to reset the table ‘split’ status so I can trigger a new refresh? I also tried to delete and re-add the table, I also tried to use the RESET function but this didn’t work.
Or is there another reason why tables wouldn’t be split?
thanks so much
Table split only works on tables with a integer based primary key. And only as the first replication (or after a Reset) on the table.
An alternative way, with a bit more control, is that you schedule the split yourself. Open “Replication Todo List” and add replication tasks (you name the engines and the filters they to use).
thanks!