The OnCommand DataWarehouse connector ETL process from the OnCommand Insight server does not complete

Applies to

• OnCommand Insight (OCI) 7.3.x
• OnCommand Insight DataWarehouse (DWH) 7.3.x

Issue

OnCommand DataWarehouse connector Extract Transfer Load (ETL) process from the OnCommand Insight server does not complete.
ETL Job status can reflect:

• ABORTED
• SKIPPED
• FAILED

Below are some examples of errors that may be found in the \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)