Skip to main content
NetApp Stage KB

OnCommand Insight DWH ETL pre capacity job fails on Datamarts Preparation step

Views:
1
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
OM
Last Updated:

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.

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

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.
934fb5eb-1fdc-45cd-bedf-bacd24a3e53b