Active Directory Importer version warning on upgrade to 6.6

Products

• Information Centric Analytics

Issue/Introduction

When attempting to upgrade Information Centric Analytics (ICA) to version 6.6.0.0 or later, the Symantec ICA Installation Wizard displays the following warning on the Integration Warnings page:

Active Directory Importer: Deployed version 1.5.6.0 is less than recommended version 1.6.0.4

The following message is displayed if you attempt to proceed without first resolving this warning:

All specified importer and integration packs must be upgraded before continuing

Environment

Version : 6.x

Component : Demo Data

Cause

The ICA installer queries the dbo.LinkedServers table in the RiskFabric database to identify the Active Directory (AD) linked server for the existing AD integration. It then executes an OPENQUERY call against the BayDynamics_ADConnector_System table on that linked server to check the installed AD Importer version. However, when ICA is configured to use DemoData, no such table exists; instead, DemoDataDW.dbo.BayDynamics_ADConnector_System is a view object that returns a hardcoded value. In this case, that value is '1.5.6.0'.

Resolution

To resolve this issue by updating the hardcoded AD connector version in DemoData, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the DemoDataDW database
3. Click the New Query button in the SQL Standard toolbar, or select File > New > Query with Current Connection
4. Copy the following statement:

   USE DemoDataDW;
   GO
   ALTER VIEW [dbo].[BayDynamics_ADConnector_System]
   AS
    SELECT '1.6.3.0' Version
   GO

5. Paste the statement in the new query editor window in SSMS
6. Execute the statement by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu
7. In the Symantec ICA Installation Wizard on the Integration Warnings page, click the Recheck button
8. Click the Next button to proceed to the License Activation page