OnCommand Insight DWH ETL pre capacity job fails on Datamarts Preparation step
Applies to
- OnCommand Insight Data Warehouse 7.3.13 (OCI DWH)
- Microsoft Windows Server 2012 R2 Standard
- Extract, Transform, Load (ETL)
Issue
dwh.log
(here truncated) shows the error as below for failed Datamarts Preparation step:
2022-02-16 01:10:47,095 ERROR [Thread-14 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:135) - Job{name='Datamarts Preparation', id=42757} failed
com.netapp.sanscreen.dwh.capacity.CapacityException: Failed running pre capacity job
<...>
at com.netapp.sanscreen.dwh.dmstaging.generate.DMStagingRunnerBean.dumpStagingAreaAndRethrow(DMStagingRunnerBean.java:93)
at com.netapp.sanscreen.dwh.dmstaging.generate.DMStagingRunnerBean.run(DMStagingRunnerBean.java:80)
<...>
Caused by: com.netapp.sanscreen.dwh.capacity.CapacityException: Failed to clean capacity staging area
<...>
Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: DROP DATABASE IF EXISTS dwh_cloud_cost_staging
<...>
Caused by: java.sql.SQLException: Schema 'dwh_cloud_cost_staging' does not exist, but schema directory '.\dwh_cloud_cost_staging\' was found. This must be resolved manually (e.g. by moving the schema directory to another location).
- NOTE: Schema name can be other "xxx_staging" but the root cause/solution will be same if the log output is as above.