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 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?
- Should we raise an NS ticket for this issue?
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!
