The agent keeps dropping its GUID and receives the same one again.

Article:TECH205800  |  Created: 2013-05-01  |  Updated: 2013-05-03  |  Article URL http://www.symantec.com/docs/TECH205800
Article Type
Technical Solution


Issue



When the agent makes a request to update its configuration it suddenly drops its GUID and eventually gets the same GUID back a few minutes later; but its configuration never gets changed or updated. As a result it is not functioning or receiving new policies and programs etc.

 


Error



The underlying error being returned when GetClientPolicies.aspx is being hit is

The specified resource does not exist

 


Environment



Symantec Management Platform 7.1 SP2 MP1.1

 


Cause



 The root of the problem was that the following two SQL views were corrupted and had no way of returning any results when a requesting computer resource's GUID needs to be looked up.

vRM_Resource_Item_Partitioned
vRM_Resource_Partitioned
 

To test if this condition exists run the following SQL statements against the database.  If either query returns zero results then the cause is confirmed 

select COUNT(*)
from vRM_Resource_Item_Partitioned r
join vComputer vc on vc.Guid = r.Guid
 
 
select COUNT(*)
from vRM_Resource_Partitioned r
join vComputer vc on vc.Guid = r.Guid

 


Solution



Functioning copies of the views are attached to this article. Simply run the SQL in them against the Symantec_CMDB database (or whatever the database name is) via SQL Management Studio.

NOTE: If errors are generated when attempting to execute the SQL in the file(s) against the database it is likely because these "views" are made up of multiple UNION queries, and that one or more tables referenced in the series of UNION statements does not exist in the database.

If so then simply find the line where the table referenced in the error is found and clip it out along with the entire SELECT and UNION statement. 

 




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


Terms of use for this information are found in Legal Notices