Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Resolve omics_processing has_output data_object referential integrity exceptions in study nmdc:sty-11-dcqce727 #1894

Closed
Tracked by #1794
mbthornton-lbl opened this issue Apr 3, 2024 · 3 comments · Fixed by #1899
Assignees

Comments

@mbthornton-lbl
Copy link
Contributor

mbthornton-lbl commented Apr 3, 2024

Resolution here is to find and delete these non-conforming OmicsProcessing documents.

Also resolves #1897

@mbthornton-lbl
Copy link
Contributor Author

mbthornton-lbl commented Apr 3, 2024

omics_processing_has_output_data_object_exceptions.json

82 Referential Integrity exceptions found from 2 studies:

  • 0 through 78 from "nmdc:sty-11-dcqce727"
  • 79 through 81 from "nmdc:sty-11-547rwq94"

@mbthornton-lbl
Copy link
Contributor Author

mbthornton-lbl commented Apr 3, 2024

-[x] @corilo review the `727 study ref integrity failures
-[x] @mbthornton-lbl implement a delete query
-[x] test on Napa instance

@mbthornton-lbl
Copy link
Contributor Author

Ran delete_omics_processing_has_output_ref_integrity_exceptions.js without error.
Afterwards, re-running data_qc/omics_processing_has_output_data_objects.js found 0 results

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
2 participants