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

适用于

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

问题

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

• ABORTED
• SKIPPED
• FAILED

以下是中可能出现的一些错误示例： \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)