「 HDS Hitachi OPS Center 」のあとに OnCommand DWH の容量ジョブが失敗する データソースが OCI に追加されました

に適用されます

OnCommand Data Warehouse （ DWH ） 7.3.x

OnCommand Insight （ OCI ） 7.3.x

問題

• DWH の容量ジョブが失敗して、で次のエラーが表示されます 。 dwh.log
• この問題は、データソース HDS Hitachi OPS Center を OCI に追加したあとに発生します

<date> ERROR [Thread-657 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:106) - Job{name='Capacity', id=1312215} failed

....

Caused by: com.netapp.sanscreen.dwh.capacity.CapacityException: Failed running 'com/netapp/sanscreen/dwh/capacity/diskgroup/add_to_disk_group_capacity_fact.sql': Populate disk_group_capacity_fact table using dwh_capacity_staging.disk_group_fact_staging table

...

Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: INSERT INTO dwh_capacity.disk_group_capacity_fact SELECT NULL AS tk, d.tk AS dateTk, dgf.storageTk AS storageTk, dgf.storagePoolTk AS storagePoolTk, dgf.diskGroupTk AS diskGroupTk, dgf.capacityMB AS capacityMB, dgf.usedCapacityMB AS usedCapacityMB, dgf.physicalDiskCapacityMB AS physicalDiskCapacityMB FROM dwh_capacity_staging.disk_group_fact_staging dgf JOIN dwh_dimensions.date_dimension d ON d.latest = 1

...

at com.netapp.sanscreen.dwh.capacity.generate.CapacityGenerator.executeSqlScript(CapacityGenerator.java:61) ~[capacity.jar:?]
 at com.netapp.sanscreen.dwh.capacity.generate.CapacityGenerator.executeSqlScript(CapacityGenerator.java:50) ~[capacity.jar:?]
 at com.netapp.sanscreen.dwh.capacity.generate.GenericCapacityGenerator.populateCapacityDatamarts(GenericCapacityGenerator.java:108) ~[capacity.jar:?]

...

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '3028-0-0-0' for key 'uk_disk_group_capacity_fact_natural_key'