Empty Software Product in samp_m2m_rule_product - Reclamation Rules

Michyyy
Tera Contributor

3 weeks ago

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:

  1. Deactivate the affected Reclamation Rule
  2. Set Create reclamation candidate to false
  3. 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!

0 Helpfuls
  • 651 Views
1 REPLY 1

BharatC
Mega Guru

3 weeks ago

Hello @Michyyy 

 

Try followings:


1) Identify all orphaned samp_m2m_rule_product records
2) Verify associated rules/products
3) Remove orphaned M2M records with empty product references
4) Re-run reclamation candidate generation
5) Validate candidates now populate model/product correctly
Then
i) Monitor whether orphaned records reappear
ii) If they do, raise an NS ticket because something upstream is recreating bad mappings

 

If the provided solution is useful/working, please Accept as Solution and hit the Helpful.

Thanks & Regards,
Bharat Chavan