SMP Agents fail to get new client policy after upgrading to SMP 7.1 SP2

book

Article ID: 157257

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

SMP Agents fail to get new client policy after upgrading to SMP 7.1 SP2.  Log error "The maximum number of client policy requests has been reached (-2147213300)"

<event date='Mar 13 12:54:34' severity='2' hostName='PMACPWSEPM01' source='ConfigServer' module='AeXNSAgent.exe' process='AeXNSAgent.exe' pid='1116' thread='1200' tickCount='-2016861578' >
  <![CDATA[RequestPolicies failed: Unexpected response from URL http://<server FQDN>/Altiris/NS/Agent/GetClientPolicies.aspx: The maximum number of client policy requests has been reached (-2147213300)]]>
</event>


Source: Altiris.NS.StandardItems.Product.ProductInstallation.InstallProduct
Description: Failed to install product. [Violation of PRIMARY KEY constraint 'PK_UserSettings'. Cannot insert duplicate key in object 'dbo.UserSettings'.
The statement has been terminated.]
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMPversion=7.1.6851.0language=enmodule=QyoQ9c8bOnJ8qem7mptZWB1nqD4GhBVytgNgknaUJEfMA32PQcdPHBEDp5dw52tDerror=-435849625build=**CEDUrlEnd**


( Exception Details: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_UserSettings'. Cannot insert duplicate key in object 'dbo.UserSettings'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Security_DataAccessLayerSecurityDataAccessLayer.spUpdateSecurityTrusteeGuids(String oldTrusteeGuidsList, String newTrusteeGuidsList, Boolean deleteOldSecurityTrustees)
   at Altiris.NS.Security.AccountManagementUpgradeHelper.UpdateSecurityTrusteeGuids(IEnumerable`1 rolesCollection, IEnumerable`1 trusteesCollection)
   at Altiris.NS.Security.AccountManagementUpgradeHelper.UpgradeRolesAndTrustees(Boolean importAccountManagmentResourcesFromWindows)
   at Altiris.NS.StandardItems.Product.CoreSolutionUpgrade.OnInstallProduct_AccountManagement(XmlNode installationNode)
   at Altiris.NS.StandardItems.Product.ProductInstallation.OnInstallProduct(XmlNode installationNode)
   at Altiris.NS.StandardItems.Product.CoreSolutionUpgrade.OnInstallProduct(XmlNode installationNode)
   at Altiris.NS.StandardItems.Product.ProductInstallation.InstallProduct() )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.NS.StandardItems.Product.ProductInstallation.InstallProduct()
   at Altiris.NS.StandardItems.Product.CoreSolutionUpgrade.InstallProduct()
   at Altiris.NS.Installation.ProductConfigurationWorker.ConfigureProductInternal(String configFile, Boolean ownsProgressContext, SerializationMode serializationMode)
   at Altiris.NS.Installation.ProductConfigurationWorker.ConfigureProductBatch()
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
)
( Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )

Cause

Incomplete SP2 install, failing on record insert UserSettings table with primary key failing.

Resolution

If and only if Hierarchy is not set up do the following:

1. Truncate UserSettings.
2. Take a backup of the Symantec_CMDB database.
3. Also check if there are any customized policies/tasks/jobs, to take a backup of them as well.
4. Then, run the following command
aexconfig.exe /configure "C:\Program Files\Altiris\Notification Server\Config\ns_update.config"
5. Open SIM (Symantec Installation Manager) and press Ctrl+Shift+P to check whether there are any partially installed solutions.

Note: Hierarchy safe steps coming in the future.


Applies To

SMP 7.1 SP2