Moving xLinks to a new server | saas-docs.aiscorp.com

KB ARTICLE

Overview

When too many xLink connections exist on a single server, or when a server is being decommissioned and replaced, xLink configurations can be moved to a new server rather than recreated from scratch.

Procedure

Open SQL Server Management Studio (SSMS).
Query the xLinkServerConfigurations table to obtain the list of xLink connection IDs matching the current server ID.
Identify the server ID of the new xLink server from the same table.
Compare the results to confirm that the xLinks being moved are associated with the correct source and destination servers.
Run the update query shown below within a transaction. Verify the results before committing.
Replace rollback tran with commit tran to apply the changes once confirmed.

begin tran

update xLinkAdapterConfigurations
set xLinkServerConfigurationID = '49817F54-F81A-4EA6-9556-04E08960F4BF'
where ID in
(
  Select xAC.ID from xLinkAdapterConfigurations xAC
  left join FactoryResourceBases FRB on FRB.ID = xAC.WorkstationID
  left join xLinkServerConfigurations xSC on xSC.ID = xAC.xLinkServerConfigurationID
  where xAC.ID = '3C9F8098-F862-4EAA-BBC3-4045AB3E2DC4'
)

-- Replace rollback with commit tran after verifying results --
rollback tran

Warning

Replace the GUID values in the query with the actual server and adapter configuration IDs from your environment. Running this query with incorrect IDs will reassign xLinks to the wrong server.

Note

The example GUIDs shown in the query are for illustration only. Always retrieve the correct IDs from the xLinkServerConfigurations table in your environment before executing.