WFA 数据源错误 "IJ031070 ：事务无法继续： status_rolledback"

适用场景

OnCommand Workflow Automation 5.1.X （ WFA ）

问题描述

WFA 数据源采集失败，低于错误，

2021-06-16 01:27:37,919 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-682 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=10, name='Datasource_Name', connectionDetails=ConnectionDetails{id=76, ip='ipaddress', port=443, userName='wfa', password='******', databaseName='null', timeoutInMinutes=120, lastUpdateTime=0}, dataProviderType=DataProviderType{id=21, productType='Clustered Data ONTAP - Datasource - cust', productVersion='', scheme='cm_storage_smsv_cust'}}, schemeId=Scheme{id=14, name='cm_storage_smsv_cust'}, dataSourceName='Datasource_Name', schemeName='cm_storage_smsv_cust'} failed: com.netapp.wfa.cache.execution.CacheException: Failed to generate warnings for duplicate rows in cache table cm_storage_smsv_cust.snapshot_cust

Caused by: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK