WFA データソースが java.SQL.SQLException ：（ conn=11936 ）不正な整数値： '?N'

最後の更新
PDFとして保存

Views:: 3

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa

Specialty:: om

Last Updated:

環境

OnCommand Workflow Automation （ WFA ） 5.1.1P1

問題

WFA のカスタムデータソースが以下のエラーで失敗します。

2021-06-29 12:13:42,353 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-731 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=3, name='Import Autotiering Settings', connectionDetails=ConnectionDetails{id=5, ip='D:\Program Files\NetApp\config\autotiering_settings.xlsx', port=9999, userName='wfa', password='******', databaseName='null', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=16, productType='Autotiering Settings', productVersion='1.0.0', scheme='autotiering_settings'}}, schemeId=Scheme{id=8, name='autotiering_settings'}, dataSourceName='Import Autotiering Settings', schemeName='autotiering_settings'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException:

Failed to load from 'D:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\settings.csv' into wfa_staging.autotiering_settings_settingsatorg.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:246)

Caused by: com.netapp.wfa.util.SqlShellException:

Failed to load from 'D:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\settings.csv' into wfa_staging.autotiering_settings_settings

at deployment.wfa-0.5.ear.common-0.5.jar//com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:221)

Caused by: java.sql.SQLException: (conn=11936) Incorrect integer value: '?N' for column 'id' at row 1