Empty Software Product in samp_m2m_rule_product for Reclamation Rule

[Michyyy]

I noticed that some entries in the samp_m2m_rule_product table contain empty Software Product references related to Reclamation Rules. I believe this is the reason why some reclamation candidates have empty Software Model and Software Product values.

I would like to understand:

• What are the possible causes of empty Software Product values in samp_m2m_rule_product?
• Is this caused by deleted software models/products, incomplete content library data, or reclamation rule configuration issues?
• What is the recommended fix or best practice for this scenario?

I`m currently considering these options:

• Deactivate the affected Reclamation Rule
• Set Create reclamation candidate to false
• Remove the record with empty product references from samp_m2m_rule_product

Has anyone encountered this before? Which approach is recommended to avoid future issues while keeping reclamation working properly?

Any insights would be appreciated. Thanks!

[pr8172510]

Hi @Michyyy,

Reclamation candidates depend on valid mappings between reclamation rules, Software Models, and Software Products in the samp_m2m_rule_product table.

If the Software Product reference becomes empty, it is usually caused by:

• deleted/retired Software Products or Models
• normalization/content library changes
• orphaned mappings after updates

This can lead to reclamation candidates with empty Software Product and Software Model values.

 

•  Re-run normalization and Content Library updates first
•   Review the affected reclamation rule mappings 
• Remove orphaned records from samp_m2m_rule_product if the referenced product/model no longer exists
• Rebuild the reclamation rule mapping if required
  I would not recommend keeping empty mappings because they can continue generating incomplete reclamation candidates.

Deactivating the rule or disabling candidate creation should only be temporary workarounds, not the final fix.