I am trying to restore a backup from our production hubspot account to our development/test account. I previously reported a problem - which turned out to be because the several hundred custom properties in our production account didn't exist in our newly created dev account.
So I wrote a program to use the hubspot api to get all the property definitions from our Prod account & create them in our dev account, WITH ALL PROPERTY THE DEFINITIONS - like, type, name, options, etc . That worked.
Then I tried to restore the entire production snapshot to dev, but got the error that "blogs can not be inserted".
So then I tried to restore just the contacts & companies. Some of them were restored/inserted into our dev account, but we got 10096 successful inserts, 3040 insertion errors, with a single error message "The value is too large to fit in the comumn data area of the buffer"
There were about 600 compnay insertion errors & 2300 contact insertion errors, so it wasn't just a single field/property.
Any idea how to find out what properties are erroring? And why? The fields/properties should be the same in both accounts.