2012-05-23 08:31 AM
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?
Solved! SEE THE SOLUTION
2012-05-24 04:37 AM
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.
2012-06-15 02:09 AM
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".
2012-06-15 02:18 AM
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.
2012-07-10 11:54 PM
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.