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

  • 77Views
  • Last Post 21 July 2021
0
votes
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!

0
votes
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,

Nataliia

Customer Support Engineer

Close