Ghost references of the old primary Management Server, while trying to re-register the DW
Hi all, I used the p_PromoteActiveWorkflowServer
stored procedure to promote a new MS server as the primary one. Before
performing promotion, I've de-registered the DW server.
Workflows now run on such promoted server, but if I try to register
the DW again, then the registration fails because of missing Data Access
Service availability. My environment is based on version 1807.
I've captured a network trace and I discovered that SCSM is still
looking for the old primary server in order to complete the
registration. In my opinion, some tracks remained on the SCSM DB, even
if I used the official MS stored procedure.
Is there a way to know which are the involved SQL tables that may host such wrong information?
I've tried to look at the tables mentioned here: https://blogs.technet.microsoft.com/mihai/fixing-service-manager-data-warehouse-registration-information/ but with no luck