Agent Table Gets Corrupted
Updated: 05 Dec 2008 | 2 comments
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.
blog entry Filed Under:
About Endpoint Management Community Blog
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog. Filter by:
Blog Tags
Configuring Altiris Client Management Suite Altiris Deployment Solution Symantec Management Platform (Notification Server) Wise Packaging Basics Altiris Server Management Suite Best Practice Compatibility Tip/How to Helpdesk Solution Altiris IT Asset Management Installing Workflow Solution Ghost Solution Suite Windows Reporting Performance Upgrade Features ServiceDesk 7.x Database Agents Dell Management Products
Comments
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.