OnCommand Insight サーバからの OnCommand DataWarehouse コネクタ ETL プロセスが完了しません
に適用されます
- OnCommand Insight ( OCI ) 7.3.x
- OnCommand Insight DataWarehouse ( DWH ) 7.3.x
問題
OnCommand DataWarehouse コネクタの 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)