WFA 数据源失败 java.sql.SQLException :( Conn=11936 )不正确的整数值: " ? N"
适用场景
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