WFA自定义数据源采集失败、并且第1行"id"列的整数值不正确："？N"

最后更新
另存为PDF

Views:

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa<a>WFA</a><a>2008683888</a><a>datasource_acquisition</a><a>custom_script</a><a>incorrect_integer</a><a>for-translation</a>

Specialty:: om

Last Updated:

适用场景

OnCommand Workflow Automation 5.1.1P1

Windows 2012R2

问题描述

数据源采集失败、并且第1行"id"列的整数值不正确："？N"

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