跳转到主内容

由于DWH密码加密文件不匹配、OnCommand 数据仓库ETL失败、用户无法访问‘Connectors '窗口

Views:
17
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

状态信息

适用场景

OnCommand Insight 数据仓库( DWH ) 7.3.x

问题描述

  1. ETL失败:
    单击DWH作业选项卡中提供的失败链接时、报告以下错误:
            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. 无法加载"Connector"窗口。而是显示以下错误:
    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. 或者、将显示Connector窗口:

Internal Error

发生原因

  • 之所以出现此问题描述 、是因为DWH服务器中的‘密码加密密钥'与一个或多个OCI连接器当前使用的密钥之间存在冲突。
  • 如果DWH数据库在 存储之前已还原、则通常会显示此信息。 

解决方案

如果在还原DWH数据库后出现这种情况、请在首次运行还原后ETL以解析问题描述 之前删除连接器。

  1. 由于最初无法访问连接器页面、因此请重新还原同一DWH备份。
  2. 还原完成后、单击 Connectors
  3. 单击每个连接器编号并记下 名称主机 信息。
  4. 卸下连接器。此操作不会删除DWH数据库中的任何历史数据。
  5. 如果显示带有文本的红色横幅 Security Risk: Default Encryption Keys Detected、请按照 文章 Why does OnCommand Insight / OnCommand Data Warehouse display banner:"security risk: 检测到默认加密密钥"?
  6. 单击 新建 重新创建连接器、然后添加 步骤3中记下的名称主机信息。

如果无法重新还原数据库、请联系NetApp技术支持以获得帮助。

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.
Scan to view the article on your device