Filtering orphaned Occurrence records from export

Ryan Wellsrequested to merge
578065/filter-orphaned-sbom-records into master

What does this MR do and why?

Contributes to: #578065

In !214380 (merged) we patched the serialization logic to patch the bug with nils causing the location field to error out. This MR delivers a better change where we filter out the bad records before attempting to serialize.

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.

Merge request reports