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 (OCI DWH)
- Storage Grid (SG)
Issue
- OCI 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(PostExtractDataValidationPro cessor.java:61) ~[inventory.jar:?]
....