When Running SAM reconciliation either for all publishers or just Microsoft, the reconciliation is getting hung up on the Microsoft suites and taking hours to process. All other items finish in seconds.
Technical Details:
- SAMPSuiteEngine uses DMToSM to cache the software models for a discovery model. However, getCollateralSuiteParents corrupts the cache by updating the array returned from _getSoftwareModelsFromDiscModel
- Also, when looping over cmdb_m2m_suite_model, SampAggregate should be used instead of SampRecord when getting the parent suite models
Cause:
- The root issue is with the suite engine cache (DMToSM) being corrupted resulting in thousands of extra queries being executed. More granular is that hundreds of extra queries are executed for each install resulting in the suite engine taking ~5 seconds to process each install. So 5 sec * 7000 installs ~ 10 hours.
Troubleshooting:
- Check the sys_trigger table and could not find "SAM - Software License Reconciliation" job executing on the worker thread
- Kill the Job for a quick resolution
