跳转到主内容

NetApp_Insight_2020.png 

OCI - DWH 连接器问题 ETL 超时

Views:
8
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
om
Last Updated:

适用于

  • OnCommand Insight 7.3.8 ( OCI ) 
  • OnCommand Insight 数据仓库 7.3.8 ( DWH )
  • Linux 和 Windows 安装

问题

  • 连接到 OCI 服务器的 DWH 连接器出现故障。
  • 以下内容显示在 DWH 中连接器的页面中。

43606 Inventory: connector 'Connector_name', '18-Jun-2020 00:00' FAILED 18/06/20 05:01 18/06/20 11:28
43582 Inventory: connector 'Connector_name', '17-Jun-2020 00:00' FAILED 17/06/20 06:34 17/06/20 06:45
43570 Inventory: connector 'Connector_name', '16-Jun-2020 17:35' FAILED 16/06/20 17:35 16/06/20 23:49

  • 可以在 dwh.log 以下类似的中找到多个 erros :
    • 2020-06-23 11:19:15,690 ERROR [Thread-694 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:106) - InventoryJob{name='Inventory: connector 'Connector_Name', '23-Jun-2020 00:00'', id=43727, connectorId=9, targetTime=1592866800057, current=true} failed
      com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Failed running inventory job
      Caused by: com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Failed to execute SQL script com/netapp/sanscreen/dwh/inventory/processors/performance/performance_summary.load.sql
      Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: INSERT IGNORE INTO dwh_inventory_transient.volume_performance SELECT pt.id AS volumeId, cl.global_id AS storageId, i.sampleTime, i.readResponseTime, i.writeResponseTime, i.totalResponseTime, i.totalResponseTimeMax, i.readThroughput, i.writeThroughput, i.totalThroughput, i.totalThroughputMax, i.readIops, i.writeIops, i.totalIops, i.totalIopsMax, i.readCacheHitRatio, i.writeCacheHitRatio, i.totalCacheHitRatio, i.totalCacheHitRatioMax, i.writePending, i.readIoDensity, i.writeIoDensity, i.totalIoDensity, i.totalIoDensityMax, i.accessed FROM dwh_inventory_staging.tmp_volume_performance i JOIN dwh_inventory_staging.chassis_local cl ON cl.connector_id = 9 AND cl.local_id = i.storageId AND cl.type = 'storage' JOIN dwh_inventory.volume pt ON pt.storageId = cl.global_id AND pt.name = i.name
      Caused by: java.sql.SQLException: IJ031012: Unable to obtain lock in 60 seconds: org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@7be69125
    • 2020-06-12 11:09:19,253 ERROR [Thread-186 (ActiveMQ-client-global-threads)] SqlShell (SqlShell.java:943) - <OCI_host> Failed to close JDBC connection
      com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
    • 2020-06-18 11:28:08,505 ERROR [Thread-450 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:106) - InventoryJob{name='Inventory: connector 'Connector_Name', '18-Jun-2020 00:00'', id=43606, connectorId=9, targetTime=1592434800062, current=true} failed
      com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Failed running inventory job

 

 

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