Import CSV into MySQL Fails

  • 41Views
  • Last Post 10 December 2021
0
votes
Tom Troll posted this 09 December 2021

Reworked columns, sizes, etc.  Using SQL Manager, I can import a test csv file with no errors. 

Checked Skyvia connection, column mapping, etc.  Import fails every time, but this time, there are no error messages, no SQL errors, etc.  Each run takes 2-3 second and all I get is "Failed".

Happy to set up Go To Meeting to show set-up.  Can't take but a couple of minutes (1 Connection, 1 Agent to MySQL, 3 tasks.

Suggestion?

Order By: Standard | Newest | Votes
0
votes
Nataliia Nikulina posted this 10 December 2021

Hello Tom,

 

Thank you for contacting Skyvia Support team. 

The error in the log of the package is 'Expression error in 'String Conversion: Error evaluating 'Pool Private' from the expression 'int8("Pool Private")': Cannot convert 'string' to 'int8'. To be able to further investigate the issue we need to check the package settings. Please make sure that the Target connection is valid for that.  Note that we provide technical assistance via email, support portal, or live chat. We do not provide support by phone currently.

We look forward to hearing from you.

 

Best regards,

Nataliia,

Customer Support Engineer 

 

0
votes
Tom Troll posted this 10 December 2021

1.  Where do I see the error message to which you refer?

2.  Chat always seems to be off line on main web page.

Being new to Skyvia, I am just trying to figure out how the program and your support system work.

 

Thanks

0
votes
Nataliia Nikulina posted this 10 December 2021

Hello Tom,

 

Thank you for the update. 

Skyvia logs all the package runs and allows you to view their results. By viewing a certain run, you can check whether there were errors and if yes, what was the reason for them. Follow the link below to know how to check the package run history: https://docs.skyvia.com/data-integration/package-run-history.html

Let us know if you need any further assistance. 

 

Best regards,

Nataliia,

Customer Support Engineer 

 

Close