Replication Error (Need Help Backing up Entire Hubspot to Sandbox CRM)

  • 44Views
  • Last Post 2 weeks ago
Lily Signori posted this 2 weeks ago

I currently have a backup of my Hubspot records, but run into this error when trying to import Contacts.

An exception has occurred during insert operation, the message returned from the provider is: Column 'nationbuilder_id' has DbType 'Double', which is different from the target column DbType 'String'.

Does anyone know how I can fix this? Thanks!

Nataliia Nikulina posted this 2 weeks ago

Hello Lily,    


Thank you for contacting Skyvia Support team.    


The root cause of the issue with your Backup is as follows.  

nationbuilder_id is a custom column of a Contacts object that initially had a ‘String’ type when it was backed up.  

A type of custom column was changed from a HubSpot end and became 'Double’ which led to an exception during the Restoration process.  

We recommend that you recreate a Backup or change a column type directly in HubSpot.  


Please update us about the result.  


Kind regards,


Customer Support Engineer