Skip to main content
NetApp Knowledge Base

OnCommand Insight DataWareHouse 'Performance Job' fails due to corrupted database table

Views:
52
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

  • OnCommand Insight DataWareHouse 7.3.5 (DWH)
  • OnCommand Insight 7.3.5 (OCI)

Issue

  • The 'Performance job', part of the ETL, fails and errors similar to the following are reported on the dwh.log:

2020-07-04 09:08:12,584 INFO [Thread-20 (ActiveMQ-client-global-threads)] MaintenanceRunnerBean (MaintenanceRunnerBean.java:243) - dwh_performance.internal_volume_hourly_performance_fact check Error Got error 122 from storage engine
2020-07-04 09:08:12,585 INFO [Thread-20 (ActiveMQ-client-global-threads)] MaintenanceRunnerBean (MaintenanceRunnerBean.java:243) - dwh_performance.internal_volume_hourly_performance_fact check error Corrupt
2020-07-04 09:08:12,587 INFO [Thread-20 (ActiveMQ-client-global-threads)] MaintenanceRunnerBean (MaintenanceRunnerBean.java:243) - dwh_performance.internal_volume_hourly_performance_fact analyze Error Got error 122 from storage engine

  • Other routines like the 'Maintenance Job' also fail with the same error 
  • Inability to perform any queries against the database table is shown on the error

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support