跳转到主内容
If you missed the pre-registration for NetApp MS Azure AD B2C Go Live, when you log in, the new login prompt will offer the option to register. Please note that access to your NetApp data may take up to 1 hour. Need assistance? Complete this form and select “Registration Issue” as the Feedback Category. 

WFA AIQUM 数据源采集,出现错误 " 复制密钥 " 主 " 的条目

Views:
1
Visibility:
Public
Votes:
0
Category:
oncommand-workflow-automation-wfa
Specialty:
om
Last Updated:

适用场景

OnCommand Workflow Automation ( WFA ) 5.1.1
 
Active IQ Unified Manager ( AIQUM ) 9.8 P1

问题描述

我们在 WFA 中收到以下错误消息,消息显示:对 qtree 的密钥 " 主 " 重复条目 "156317"
 
021-09-28 06:33:53,219 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-2326 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=26, name='ActiveIQUM9.8', connectionDetails=ConnectionDetails{id=69, ip='AIQUM_IP', port=3306, userName='wfa', password='******', databaseName='', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=19, productType='Active IQ Unified Manager', productVersion='9.7,9.8', scheme='cm_storage'}}, schemeId=Scheme{id=3, name='cm_storage'}, dataSourceName='ActiveIQUM9.8', schemeName='cm_storage'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException:Failed to load from 'C:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\address=(host=AIQUM_Ip)(port=3306)(type=master)-cm_storage.qtree-6935224624235622313.dump' into wfa_staging.cm_storage_qtree
at org.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:246)
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=15935) Duplicate entry '156317' for key 'PRIMARY'
Caused by: java.sql.SQLException: Duplicate entry '156317' for key 'PRIMARY'
Query is: LOAD DATA INFILE 'C:/Program Files/NetApp/WFA/jboss/standalone/tmp/wfa/address=(host)(port=3306)(type=master)-cm_storage.qtree-6935224624235622313.dump' INTO TABLE wfa_staging.cm_storage_qtree
 
 
CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support