"HDS Hitachi 操作中心 " 后， OnCommand DWH 容量作业失败 数据源已添加到 OCI

适用于

OnCommand 数据仓库（ DWH ） 7.3.X

OnCommand Insight (OCI) 7.3.x

问题

• DWH 容量作业失败，并在中显示以下错误 。 dwh.log
• 将数据源HDS Hitachi 操作中心 添加到 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'