After replacing the UAT DB with the PROD DB search server address is incorrect. It is pointing to the prod search server. How to change the Search Server specification to point to a new server.
Release : 17.3
Component : xFlow and Search Server Component
DELETE FROM [al_cdb_componentinstallstate] where packageid LIKE '%search%' AND machinename = 'name of the old search server'
Please make sure on the new Search Server that it is a brand new server without any Search Server or Service Management components previously installed. If Search Server is already installed, you will need to uninstall Search Server entirely, then install a new instance with the above instructions.
It is not possible to skip this step as Search Server needs to be freshly installed brand new with new indexes established.