Package sources request is backing off after removing the SMP Server as a child SMP server

Products

• IT Management Suite

Issue/Introduction

You have recently broken your hierarchy (meaning, removing a child SMP Server from the hierarchy in this case).  However, after that, Package Servers are unable to download any new packages as they believe that the SMP Server is too busy to fulfil their request.

Server is busy. Package sources request is backing off

Environment

ITMS 8.x

Cause

Due to a previous hierarchical structure being broken, the database maintained references to the child SMP server which was decommissioned. Unfortunately, the CMDB had associated various packages with this decommissioned server. As a result when the Package Servers had downloaded the Package XML  they were attempting to download the packages from the decommissioned server. Since they were not getting a response they were incorrectly reporting that the Server was busy.

Resolution

NOTE: Before implementing the following steps please take a full backup of the Database

Step 1:

The first step in resolving this issue is to determine the GUID of the correct SMP Server. You can identify this by executing the following SQL Query:

SELECT GUID

FROM vThisNS

Make a note of the GUID, which is returned.

 

Step 2:

The next step is to identify the correct OriginNSSourceNSID (This is used to identify which package is associated to which SMP Server) of the SMP Server, whose GUID we located in Step 1. Execute the following SQL Query to return a list of OriginNSSourceNSIDs in your environment:

SELECT ID, OriginNSGUID, SourceNSGuid

FROM OriginNSSourceNS

WHERE OriginNSGUID = SourceNSGUID

 

Verify that the result return matches the GUID returned in Step 1. You want to make sure that you note down the ID, which is returned.

 

Step 3:

The final step is to execute the following SQL Query, which will go through the CMDB and update the package association to the correct SMP Server:

 

UPDATE ItemNSSource

SET OriginNSSourceNSId = 'Change this to the ID of the SMP Server returned in Step 2'

WHERE ItemGuid in (

SELECT 

SP.PackageID

FROM SWDPACKAGE SP

INNER JOIN ItemNSSource NSS on NSS.ItemGuid = SP.PackageID

INNER JOIN SWDOriginator NSO on NSO.OriginatorID = SP._OriginatorID

)