WFAカスタムデータソースの取得が、行1の列「id」に対して誤った整数値で失敗しました

最後の更新
PDFとして保存

Views:: 6

Visibility:: Public

Votes:: 0

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

Specialty:: om

Last Updated:

環境

OnCommand Workflow Automation 5.1.1P1

Windows Server 2012 R2の場合

問題

データソースの取得に失敗しました。整数値が正しくありません：行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