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

  • 77Views
  • Last Post 21 July 2021
Lily Signori posted this 19 July 2021

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 21 July 2021

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