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 mis-match

Views:
366
Visibility:
Public
Votes:
0
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)

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.

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.

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