Datasync Error

Question

Hi,

Just set up sync with 2 databases one hub in west europe and another in asia

The hub database is populated with data, the asia database is empty.

When I set up the data sync both databases provisioned ok and are shown as good but the initial sync failed with

When syncronising the data gives the error

Sync failed with the exception "We have encountered an issue in syncing your data."

For more information, provide tracing id ‘d8fe7a32-9cf0-4ef6-a9de-749df5b04106’ to customer support.

Any help would be appreciated, needs to be deployed before monday :)

Answer 1

Update: Tried to reprovision the database so I could add one table at a time to the sync to try and narrow down the problem, data sync failed to reprovision and got stuck in the repovision state so I couldnt delete the sync!

Had to drop both databases and recreate again, added the sync, both databases provisioned correctly then got an error at the same point when the data tries to sync..

Sync failed with the exception "We have encountered an issue in syncing your data."

For more information, provide tracing id ‘354540af-2348-49f7-8315-f8fdd6aa347d’ to customer support.

Any ideas on how to narrow down the error? the above message doesnt really help, neither does customer support as I was told that they dont support data sync!!

Answer 2

Hi Martin,

It's because one of the row size of table 'gen_binary' exceeded the maximum batch size which is 10m currently.

Answer 3

Thanks Charles

Found two records that are over 10M, I'm rejigging the schema to limit the binary columns to 10M.

Regards

Martin