Skip to main content
NetApp Knowledge Base

OnCommand Data Warehouse ETL fails and user is unable to access the ‘Connectors’ window due to DWH password encryption file mismatch

Views:
841
Visibility:
Public
Votes:
7
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

OnCommand Insight Data Warehouse (DWH) 7.3.x

Issue

  1. ETL fails:
    On clicking the FAILED link provided in the DWH Jobs tab, the following error is reported:
            Message :
    javax.ejb.EJBTransactionRolledbackException: Error encountered during decryption
       at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:158)
       at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:255)
       at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:332)
       at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)
       at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)Unable to access the list of Connectors within the Data Warehouse (DWH) user interface.
  2. The 'Connector' Window fails to load. Instead, the page displays the following error:
    Error Processing Request
    Context Path:/dwh
    Servlet Path:/faces
    Path Info:/connectors/list.xhtml
    Query String:null
    Stack Trace:
    javax.servlet.ServletException: Error encountered during encryption
         at javax.faces.webapp.FacesServlet.service(FacesServlet.java:671)
  3. Or the Connector Window will display:

Internal Error

Cause

  • This issue is caused due to a conflict between the ‘Password encryption keys’ that are in the DWH server, and what is currently being used by one or more of the OCI connectors.
  • Usually seen if the DWH DB has been restored before the vault

Solution

If this is seen after restoring the DWH database, then remove the connectors before the first post restore ETL runs to resolve the issue.

  1. As the connectors page is not initially accessible, restore the same DWH backup again.
  2. After the restore completes, click on Connectors.
  3. Click on each connector number and note down the Name and Host information.
  4. Remove the connector. This will not remove any historical data in the DWH database.
  5. If a red banner appears with the text Security Risk: Default Encryption Keys Detected, run the securityadmin tool as outlined in article Why does OnCommand Insight / OnCommand Data Warehouse display Banner: "Security Risk: Default Encryption Keys Detected"?
  6. Click New to re-create the connectors, and add in the Name and Host information noted in Step 3.

If restoring the database again is not possible, contact NetApp Technical Support for assistance.

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.