OnCommand Insight DataWareHouse 'Performance Job' fails due to corrupted database table
- Views:
- 259
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-insight-data-warehouse
- Specialty:
- oci
- Last Updated:
Applies to
- OnCommand Insight DataWareHouse 7.3.5+ (DWH)
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