Skip orphan Sbom::Occurrence records when executing CVS

Olivier Gonzalezrequested to merge
skip_orphan_sbom_occurrence_in_CVS into master

What does this MR do and why?

Skip orphan Sbom::Occurrence records when executing CVS

Continuous Vulnerability Scanning attemps to create vulnerabilities for every Sbom::Occurrence record that is affected. It appears that some of these records can be orphan and reference a project that no longer exists in the DB.

With Loose Foreign Key clean up being an async process, our process must account for potential delay and ensure to only consider valid records.

Changelog: fixed

References

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Olivier Gonzalez

Merge request reports