Hi,
It seems that the data contained in your .csv file doesn't match the data type defined in MySQL table structure.
But without knowing what the csv file contains, nor the table structure it's difficult to be more specific.
Does your CSV files contains a header displaying the column names ?
Could you may be share the first line of your csv file and a 'describe wfa_staging.mytable_dfstarget' ?
(You can remove the sensible data if any from this csv extract, the value matter less than knowing what kind of data this field contains)
As documented in the releases notes, here are the main changes introduced by WFA 5.0 :
• Added security hardening to secure WFA systems
• New features for OnCommand Workflow Automation (WFA) 5.0
◦ HTML5-based UI for Operator Portal
◦ The wfa-server service on Linux runs as a non-root user. This is done to improve security for WFA on Linux
◦ HTTP access to the WFA Web UI and REST interface is unavailable. All WFA HTTP Web URLs redirect to HTTPs
• Upgraded software The following software versions are included:
◦ Wildfly upgrade from Wildfly 8.2 to Wildfly 12.0
◦ ActiveState ActivePerl 5.24.3 (2404) with OpenSSL 1.0.2k (Windows only)
◦ Perl components of NetApp Manageability SDK 9.5
◦ Data ONTAP PowerShell Toolkit 4.7.0.0
◦ Oracle Java SE Runtime Environment (JRE) 1.8.0_192
◦ MySQL Community Edition 5.7.24
Your script may be affected by the upgrade of either the Powershell Toolkit or the Manageability SDK.
Have a look at their respective releases notes foor further details regarding the changes introduced and if they may affect your code.
Bests Regards,