KNOWN ISSUE: ItemVersionData table is growing very large very quickly.

Article:TECH46681  |  Created: 2009-11-10  |  Updated: 2014-03-13  |  Article URL http://www.symantec.com/docs/TECH46681
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



The table ItemVersionData is growing very fast and is taking up a lot of disk space.


Environment



SMP 7.0 SP2, SP3, SP4, & SMP 7.1 SP1+ with Inventory Solution, Software Delivery, and Workflow Solution.


Cause



There are actually a number of possible causes for this problem.  One way to determine what issue you may be seeing is to run the attached SQL script "spSVCGetTasksByType.sql".

"Detailed File Inventory"
This is the first documented cause of the problem, created when Workflow and Inventory were installed together.  An old "Detailed File Inventory" task along with the Workflow "TaskServer DB Fix Schedule" caused the issue.  This was corrected in SP1 for Inventory Solution.

"Download, Execute, Applicability, and Detection Check statuses"
This issue, documented in TECH168522, from Software Management solution, occurs when these checks update the table erroneously, and is exasperated when the check run over and over rapidly.  Most of these related issues were corrected in 7.1 MP1 but there is still one left for SP2.

"OnClientConfig"
This issue, documented in TECH143154, from Software Management solution, occurs when a restricted user saves a policy with no command line and then later adds one, causing an erroneous loop in code execution.  It is resolved in 7.0 MR4. 

 


Solution



If you are experiencing this issue, then you may want to contact Symantec Technical Support for assistance.

To help confirm whether you are experiencing this issue, run the attach SQL query ItemVersions-count-by-item, which can also give you a better sense of the nature of the symptoms.

To purge the excessive ItemVersions, first backup you Altiris database; and then run the attached SQL query: ItemVersions-purge-excessive-versions. This will identify several items with an excess of versions, and will purge several of the excess versions.

Notes:

  • this script may need to be run several times to remove all excess versions.
     
  • after removing excess versions, you may want to re-run the information query and compare the results to a previous run, to confirm that you are making progress.
     
  • after removing excess versions, you may want to shrink the database to reorganize the data still in the database, and to return unused disk space to the file system.
     

NOTE:  ItemVersions and ItemVersionData should not be truncated.  Doing so will severely damage the SMP installation.


Attachments

list items with lots (more than 10) versions
ItemVersions-count-by-item-4f.sql (2 kBytes)
Remove excess versions; back up Altiris database prior to running.
ItemVersions-purge-excessive-versions-2b.sql (2 kBytes)



Legacy ID



50055


Article URL http://www.symantec.com/docs/TECH46681


Terms of use for this information are found in Legal Notices