search cancel

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


Article ID: 198505


Updated On:


Information Centric Analytics Data Loss Prevention Core Package


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


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.


Release :

Component : AD Importer Utility


To update the ICA Active Directory Importer utility from version to version, 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 :
    1. Open the file archive
    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...


spUpdateStg_AD_1598972947934.sql get_app