Upgrade error: Active Directory Importer found 1 linked servers in RiskFabric database but found 0 linked servers defined on server

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

When upgrading an installation of Information Centric Analytics (ICA) with a database that has been migrated or copied from another server, the installer may return the following prerequisite error and fail to proceed:

Active Directory Importer Found 1 linked servers in RiskFabric database RiskFabric but only found 0 linked servers defined on Server hostname

Environment

Release : 6.5.x

Component : Active Directory Importer

Cause

When the ICA installer performs its prerequisite check against the linked server, it references the Active Directory (AD) linked server defined in the RiskFabric LinkedServers table and queries the deployed version of the importer in the Active Directory data warehouse. If the referenced AD linked server is invalid, the query will fail to return results.

Resolution

To resolve this issue:

1. Query the LinkedServers table in the RiskFabric database to identify the LinkedServerID of the AD linked server:
   

   USE RiskFabric
   SELECT LinkedServerID
   FROM LinkedServers
   WHERE LinkedServerName LIKE 'RISKFABRIC_AD_RISKFABRIC_%_ACTIVEDIRECTORYDW'
   ;

2. Modify the LinkedServerName to match the hostname of the server on which you are performing the upgrade:
   

   UPDATE LinkedServers
   SET LinkedServerName = 'RISKFABRIC_AD_RISKFABRIC_hostname_ACTIVEDIRECTORYDW'
   WHERE LinkedServerID = --ID from first query
   ;