ItemVersionData Table growing very large with Download, Execute, Applicability, and Detection Check statuses from Software Management
This is a known issue.
The detection checks (and other steps) were designed to send updates to the server so administrators would know what was going on with SWD policies on client. However, they were also adding entries to ItemVersionData erroneously. Unfortunately, if one of these were to fail, events would be sent over and over to the server, creating essentially a fire-storm of updates to this table. Add this to failing on several clients and the table growth would be tremendous.
There are multiple issues related to this, most of which were addressed in 7.1 MP1. There is still an outstanding Detection check issue slated for 7.1 SP2.
To purge/clean the tables, please refer to TECH46681.
Software Management 7.0 SP2 MR1
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.