跳转到主内容

NetApp wins prestigious Coveo Relevance Pinnacle Award. Learn more!

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

Views:
8
Visibility:
Public
Votes:
0
Category:
oncommand-insight
Specialty:
oci
Last Updated:

适用于

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'

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device