AIQUMデータソースの取得中にWFAで「キー「PRIMARY」のエントリを複製」エラーが発生しました
- Views:
- 9
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-workflow-automation-wfa
- Specialty:
- legacy
- Last Updated:
環境
- OnCommand Workflow Automation ( WFA ) 5.1.1
- Active IQ Unified Manager(AIQUM)9.8 P1
- ONTAP システムマネージャ( OSM )
- ONTAP 9
問題
- WFAに次のエラーメッセージが表示されます。Duplicate entry '156317' for key 'primary' of qtree
- このエラーは、
<install_directory>\Program Files\NetApp\WFA\jboss\standalone\log\wfa.log
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