WFA 错误第 1 行查询中 "id" 列的整数值不正确： "n"

最后更新
另存为PDF

Views:: 10

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa

Specialty:: om

Last Updated:

适用场景

Onacommand Workflow Automation （ WFA ） 5.2

问题描述

日志中的错误如下所示，

server.log

2021-06-25 12:06:48,427 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-334 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=2, name='Import Volume Move Info', connectionDetails=ConnectionDetails{id=8, ip='UM_FQDN', port=3306, userName='wfa', password='******', databaseName='', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=18, productType='OnCommand Unified Manager - Volume Moves', productVersion='7.3,9.4', scheme='cm_volume_moves'}}, schemeId=Scheme{id=9, name='cm_volume_moves'}, dataSourceName='Import Volume Move Info', schemeName='cm_volume_moves'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException:Failed to load from 'D:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\address=(host=UM_FQDN)(port=3306)(type=master)-cm_volume_moves.volume-8164484079706107723.dump' into wfa_staging.cm_volume_moves_volume

at org.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:246)

at org.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:362)

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

Caused by: com.netapp.wfa.util.SqlShellException:Failed to load from 'D:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\address=(host=UM_FQDN)(port=3306)(type=master)-cm_volume_moves.volume-8164484079706107723.dump' into wfa_staging.cm_volume_moves_volume

Caused by: java.sql.SQLException: Incorrect integer value: 'N' for column 'id' at row 1