Upgrading the Active Directory (AD) Importer Utility from version 1.5.4.0 to 1.6.0.4 as part of an upgrade to ICA 6.5.4

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

If in use, the Active Directory (AD) Importer utility must be upgraded to version 1.6.0.4 prior to upgrading ICA to version 6.5.4. If upgrading from AD Importer version 1.5.4.0 or earlier, changes must first be made to the stored procedure spUpdateStg_AD.

Cause

The AD field distinguishedName is a concatenated field that may exceed the string length definition for its corresponding column in the AD Importer staging tables. Because this field is no longer used in ICA, running the script provided with this article alters the staging stored procedure to ignore this field.

Environment

Release : 6.5.2.2

Component : AD Importer Utility

Resolution

To update the ICA Active Directory Importer utility from version 1.5.4.0 to version 1.6.0.4, do the following:

1. Open SQL Server Management Studio (SSMS).
2. In the Connect to Server window, from the Server type dropdown, select Database Engine.
3. Enter the server name and credentials for the server hosting the Risk Fabric database and click Connect.
4. From the File menu, select Open > File...
5. Locate and open the file spUpdateStg_AD.sql (attached to this article)
   
6. Confirm the Risk Fabric database is selected in the dropdown menu to the left of the Execute button on the SQL Editor toolbar (note that the database name may differ in your environment).
7. Click on the Execute button on the SQL Editor toolbar.
8. Follow the remaining steps to upgrade provided in the file readme.txt bundled in the file archive ActiveDirectoryImporter_1.6.0.4.zip :
1. Open the file archive ActiveDirectoryImporter_1.6.0.4.zip
2. Copy the contents of the archive to the current location of the AD Importer and overwrite the existing files, with the following exceptions: ADConnectorSetup.exe.config and ImportADUsersAndComputers.exe.config
3. In SSMS, run the SQL Server Agent job Bay Dynamics AD Connector Job by right-clicking on the job and selecting Start Job at Step...