Data Integration Error

  • 208Views
  • Last Post 02 November 2017
  • Topic Is Solved
0
votes
Walter Lowry posted this 27 October 2017

I am evaluating the Skyvia tool for my company and I am testing the replicate tool and the functionality however, when using the replicate tool inorder to migrate from SFDC to a PostgreSQL database, I am receiving errors of the type:

insert;"invalid byte sequence for encoding "UTF8" 

This is causing a loss of records and failing the migration, do you know why this error is happeing? 

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 30 October 2017

Please open editor for your PostgreSQL connection, click the Advanced button and select the Unicode check box:

https://skyvia.com/resources/docs/index.html?postgresql_connections.htm

Save your connection and try running the package again. Please noify us about the results.

  • Supported by
  • Jon Christiansen
0
votes
Walter Lowry posted this 01 November 2017

Hi, this seems to have fixed the errors I was having thanks!

0
votes
Mariia Zaharova posted this 02 November 2017

Glad to see that the issue was resolved.

If you have any further questions, feel free to contact us.

Close