WFA Custom datasource acquisition failing with Incorrect integer value: '?N' for column 'id' at row 1

Applies to

OnCommand Workflow Automation 5.1.1P1

Windows 2012R2

Issue

Datasource acquisition failing with Incorrect integer value: '?N' for column 'id' at row 1

Datasource acquisition failure log:

Caused by: java.sql.SQLException: (conn=18661) Incorrect integer value: '?N' for column 'id' at row 1
	at org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:198)
	at org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
	at org.mariadb.jdbc//org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228)
	at org.mariadb.jdbc//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:334)
	at org.mariadb.jdbc//org.mariadb.jdbc.MariaDbStatement.executeUpdate(MariaDbStatement.java:520)
	at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:430)
	at deployment.wfa-0.5.ear.common-0.5.jar//com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:208)
	... 210 more
Caused by: java.sql.SQLException: Incorrect integer value: '?N' for column 'id' at row 1
Query is: LOAD DATA INFILE 'C:/Program Files/NetApp/WFA/jboss/standalone/tmp/wfa/clusterlocation.csv' INTO TABLE wfa_staging.clusterlocation_ns_clusterlocation
	at org.mariadb.jdbc//org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:119)
	at org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:200)
	at org.mariadb.jdbc//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:328)
	... 213 more