Ghost references of the old primary Management Server, while trying to re-register the DW

Alberto_Fumagalli

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

Adam_Dzyacky

As I recall...

If you head into the Data Warehouse tab in the Console, head into Data Source, then click on your operational management group, and then scroll down in the below pane. There is a section called "Data Warehouse CMDB Source" which should list your SCSM SQL server but may have the incorrect SDK server defined (e.g. your old one) post promotion.

I'm going through my notes, but I think the table exists in the ServiceManager DB (although that feels counter intuitive as i type it) and its in the neighborhood of the following SQL table - dbo.MT_Microsoft$SystemCenter$DataWarehouse

Alberto_Fumagalli

Adam_Dzyacky said:

As I recall...

If you head into the Data Warehouse tab in the Console, head into Data Source, then click on your operational management group, and then scroll down in the below pane. There is a section called "Data Warehouse CMDB Source" which should list your SCSM SQL server but may have the incorrect SDK server defined (e.g. your old one) post promotion.

I'm going through my notes, but I think the table exists in the ServiceManager DB (although that feels counter intuitive as i type it) and its in the neighborhood of the following SQL table - dbo.MT_Microsoft$SystemCenter$DataWarehouse

Hi

Unfortunately, there's no DW wunderbar available in the console, because I'm just no longer able to perform the registration due to of such strange old server tracks.

The previous table didn't return any record, as well as that one: MT_Microsoft$SystemCenter$DataWarehouse$CMDBSource

Adam_Dzyacky

I'm still guessing here/looking myself - 

Try a similarly named series of tables in the DWStagingAndConfig in the DW server.

Alberto_Fumagalli

I've just found a reference to the old server in this table: MT_Microsoft$SystemCenter$ResourceAccessLayer$SdkResourceStore, which is hosted on the OpDB.

I manually corrected the wrong server name (even if I don't know I need to fix in other tables...) and...After such change, the registration completed, but...The wunderbar didn't appear.
So, I've used the following utility and syntax in order to correctly write information in both databases:
SCSMRegisterDW.exe -u:MYSERVICEACCOUNT -sm:PRIMARYWFSERVER -dw:DWSERVER -a:add

Now the wunderbar is available and Get-SCDWSource cmdlet looks like to properly show the datasource

Adam_Dzyacky

That is most excellent to hear.

Alberto_Fumagalli

I'm still wondering why the official MS stored procedure is not aware of such information to be replaced, together with the one which is included in other tables included in the stored procedure T-SQL code..

Adam_Dzyacky

Agreed.

It feels like the documentation while specific in scope (i.e. Promote a Workflow server) should at least be aware of the downstream implication for the DW when this process is invoked.