Agent Table Gets Corrupted
Raman
December 5th, 2008
Have you ever heard that Altiris agent.dbo table gets corrupted and you are not able to deploy agents? Here is the query that will help you to delete corrupted items from table.
Below error faced in Console
To Resolve this, log into the database server for Altiris and go to Query and write the database name.
For example: Use altiris
Delete from Altiris.dbo.AgentPushdata
This query will delete the Corrupted contents from table and hence issue will be resolved.
Altiris Support has a nice KB article about this
Their KB article includes code to backup the data in case you want it back for reporting purposes or whatever.
https://kb.altiris.com/article.asp?article=18945&p=1
backing up and issue
Always backup your db before you make any changes to your db directly or major changes within the NS Console (such as repairing any solution).
I actually ran into this issue long ago and working with support used this fix above to correct it.
Nice article.
-d
-d
Would you like to reply?
Login or Register to post your comment.