topic Re: ETL Build Fails in Active IQ Unified Manager Discussions

ETL Build Fails

zola — Thu, 05 Jun 2025 06:26:29 GMT

My customer is testing out OnCommand Insight Report. Worked fine until a couple of days ago when the ETL failed to build Here is the shortened down error output:

"Cannot add or update a child row: a foreign key constraint fails (`dwh_ner_inventory`.`file_share`, CONSTRAINT `fk_file_share_qtreeId` FOREIGN KEY (`qtreeId`) REFERENCES `qtree` (`id`) ON DELETE CASCADE)"

Is there any sort of quick fix I can apply to get it back running? Any long term correction needed so it doesn't happen again?

ETL Build Fails

yuvaraju — Thu, 24 May 2012 11:37:05 GMT

The issue seems to be that the underlying qtree was deleted while the file share on the qtree still exists triggering this ETL failure. Please check the mail I have sent with the workaround and other details.

Re: ETL Build Fails

columbus_admin — Thu, 14 Jun 2012 17:29:24 GMT

Yuvaraju,

I have started to have the same issue, the exact same error message. Is there a "public" fix for this yet?

Thanks,

Scott

Re: ETL Build Fails

pascalduk — Fri, 15 Jun 2012 09:09:12 GMT

Had a similar issue and opened a case. Bug will be fixed in OCIR 1.1.

Workaround that worked for me is to remove the DFM server from OCIR and the add it again under "Configure -> Datafabric Manager Server".

Re: ETL Build Fails

araman — Fri, 15 Jun 2012 09:18:59 GMT

Hi,

The issue is getting fixed in our next release, as per current plan it should be released in September. Currently the team is also identifying other scenarios and testing to avoid similar issues. At this moment the workaround is to reconfigure the DFM server.

Thanks

Arun

Re: ETL Build Fails

columbus_admin — Fri, 15 Jun 2012 12:44:51 GMT

Thank you, that fixed it!

- Scott

Re: ETL Build Fails

yuvaraju — Tue, 10 Jul 2012 11:22:07 GMT

Hi,

Patch for OnCommand Report Build ETL fails issue is now available. Refer to the document in the link https://communities.netapp.com/docs/DOC-17498 for info on downloading and deploying the patch.

Thanks,

Yuvaraju.B

Re: ETL Build Fails

pascalduk — Wed, 11 Jul 2012 06:54:47 GMT

Thank you for posting the patch here.

The patch has fixed the issue for me. I had a failed ETL build last night, installed the patch, and ran the DFM poll and ETL build again successfully without removing and adding the DFM server again.