OCI DWH ETL failing at extractor stage for Storage Grid with data validation failed
Applies to
- OnCommand Insight 7.3.x (OCI)
- OnCommand Insight Data Warehouse 7.3.x (DWH)
- Storage Grid (SG)
Issue
- DWH ETL fails at extractor stage
- DWH log:
at org.apache.activemq.artemis.ra.inflow.ActiveMQMessageHandler.onMessage(ActiveMQMessageHandler.java:321) ~[?:?]
at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1030) ~[?:?]
at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:49) ~[?:?]
at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1153) ~[?:?]
at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42) ~[?:?]
at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31) ~[?:?]
at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:65) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_311]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_311]
at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118) [artemis-commons-2.16.0.jar!/:2.16.0]
Caused by: com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Data validation failed with error: Internal volume with identifier "<bucket_name>" appears more than once with different ids. It can happen if two data sources are reporting on the same storage. See bug 23928.
at com.netapp.sanscreen.dwh.inventory.processors.post.PostExtractDataValidationProcessor.executeSqlScripts(PostExtractDataValidationProcessor.java:61) ~[inventory.jar:?]
....