Oncommand Workflow Automation datasource error "IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK"
- Views:
- 521
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-workflow-automation-wfa
- Specialty:
- legacy
- Last Updated:
Applies to
Oncommand Workflow Automation 5.1.X (WFA)
Issue
WFA Data source acquisition fails below error,
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