The dependencies for SharePoint Data Base adapter has not been configured (4369679)

The dependencies for SharePoint Data Base adapter has not been configured

1. Dependencies for SharePoint DB adapter are not deployed

   • From Content Matrix release 9.7.0.2 onwards, when a user creates a connection or runs a job (from UI, PowerShell or remotely) with Database as source from client machine (i.e. environment which does not have SharePoint installed), then user will get following error:
     
     "The dependencies for SharePoint DB adapter has not been configured. Please refer to <link> for steps if you wish to configure them."
      

     

2. Incorrect version of dependencies for SharePoint DB adapter are deployed

   • If a user has already deployed dependencies for SP2010 Database in client machine and tries to connect DB server other than SP2010, then user will get following error: 

     "The dependencies for SharePoint {connecting SharePoint version} DB adapter has not been configured. Please refer to <link> for steps if you wish to configure them."
     
     Where {connecting SharePoint version} can be: 2007 or 2010 or 2013 or 2016 or 2019 or Server Subscription Edition

     

• These errors occurs if the SharePoint dependencies required for connecting to a SharePoint database are not deployed on the client machine, or deployed dependencies does not match with connecting SharePoint DB Server version.
• From Content Matrix 9.7.0.2 release onwards SharePoint dependencies required for connecting to a SharePoint database are not included in the Content Matrix installer due to copyright issue.
  As per this change, none of the SharePoint DB adapter versions will be deployed by default,while installing Content Matrix 9.7.0.2 or above version in the client machine.

It is required to use Metalogix.DBDeployment.exe utility in the environment to export required SharePoint dependencies zip package from SharePoint Farm Server and import the same zip package in the client machine in order to make a successful DB connection.

Utility Usage Guide:

This utility deploys the dependencies required for SharePoint 2007, 2010, 2013, 2016, 2019 or Subscription Edition databases connections.

This utility has multiple actions:

1. export action -> Create the SharePoint dependencies zip package from the SharePoint Farm Server machine.

2. import action ->. It will first remove any pre-existing SharePoint DB adapter dependencies from the client machine and after that It will deploy the SharePoint dependencies from zip package.

3. remove action -> removing the deployed DB adapter dependencies.
    

Metalogix.DBDeployment.exe <...options>



Options
     action = export | import | remove

     path   = Directory Path for export package | Zip path to import package

Examples:
     >> Metalogix.DBDeployment.exe export “C:\PathName”
     >> Metalogix.DBDeployment.exe import “C:\PathName\SP2013Package.zip”
     >> Metalogix.DBDeployment.exe remove
 

Steps to be executed to fix the issue in client machine

Let us take an example if the user wants to connect SharePoint 2019 DB server in client machine.

Prerequisites:

• 9.7.0.2 or above version of “Content Matrix Console – SharePoint Edition” must be installed on client machine.

Step 1: Export

1. Locate the utility from the install location. The default installation path is
   "C:\Program Files (x86)\Metalogix\Content Matrix Consoles\Metalogix.DBDeployment.exe"
2. Copy Metalogix.DBDeployment.exe utility from client machine to SharePoint Farm Server.

3. Run ‘Command Prompt’ as Administrator in SharePoint 2019 Farm server and change directory to "C:\DBAdapterUtility" where utility is present.
4. Run the command: Metalogix.DBDeployment.exe export "C:\DBAdapterUtility" SharePoint dependencies zip package will be created in "C:\DBAdapterUtility" location.

   

Step 2: Import

1. Copy the exported zip package from server machine and paste in client machine.
   i.e. Let’s copy SP2019Package.zip to "C:\ClientMachineDbPackage" in client machine where user wants to create SP2019 DB connection.
2. It is required to stop Content Matrix while the configuration if it is running in client machine
3. In client machine, run ‘Command Prompt’ as Administrator and change directory to Content Matrix install location.
   Use Metalogix.DBDeployment.exe utility from the and import the SharePoint DB dependencies in client machine.

- The user can have only one SharePoint Database adapter configuration at a time in the client machine. SP2007 or SP2010 or SP2013 or SP2016 or SP2019 or SP Subscription Edition are currently supported. - If a user wishes to change the configuration in the client machine from SP2013 DB to SP2016 DB or some other versions, they need to perform export/import steps again. It is required to stop Content Matrix Console while the configuration. - For distributed migration, this utility needs to be executed on all agents which are client machines