OnCommand Data Warehouse ETL fails and user is unable to access the ‘Connectors’ window due to DWH password encryption file mismatch
- Views:
- 908
- Visibility:
- Public
- Votes:
- 7
- Category:
- oncommand-insight-data-warehouse
- Specialty:
- oci
- Last Updated:
Applies to
OnCommand Insight Data Warehouse (DWH) 7.3.x
Issue
- 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. - 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) - 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.
- As the connectors page is not initially accessible, restore the same DWH backup again.
- After the restore completes, click on Connectors.
- Click on each connector number and note down the Name and Host information.
- Remove the connector. This will not remove any historical data in the DWH database.
- 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"? - 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.