跳转到主内容

OnCommand Insight 服务器上的 OnCommand DataAwarehouse Connector ETL 进程未完成

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

适用于

  • OnCommand Insight (OCI) 7.3.x
  • OnCommand Insight Data Awarehouse ( DWH ) 7.3.x

问题

OnCommand DataAwarehouse Connector 无法从 OnCommand Insight 服务器提取传输负载 (ETL) 过程。
ETL 作业状态可以反映:

  • ABORTED
  • SKIPPED
  • FAILED

abborted_DWH_JOB.png

 

以下是中可能出现的一些错误示例: \Sanscreen\wildfly\standalone\log\dwh.log

 

  • Caused by: org .m ariadb.jdbc.internal.common.QueryException: Cannot add or update a child row: a foreign key constraint fails (`dwh_inventory_staging`.`storage_node_to_port`, CONSTRAINT `fk_storage_node_to_port_portId` FOREIGN KEY (`portId`) REFERENCES `dwh_inventory`.`storage_port` (`id`) ON DELETE CASCADE)
  • SequenceProcessor (SequenceProcessor.java:123) -dwh_inventory_staging.storage_pool_to_disk: Loading to public table completed (using connector'CONNECTOR_NAME') - 399248 rows added or modified
  • InventoryRunnerBean (InventoryRunnerBean.java:200) - Failed to dump databases after inventory job failure: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to creat JDBC statement at com.netapp.sanscreen.dwh.util.SqlShell.createStatement(SqlShell.java:1339)

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device