メインコンテンツまでスキップ

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

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

に適用されます

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'

 

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