Too Many Database Connections: Too many connections

Scenario

An error occurred while DTS was migrating full data based on a task that contains full data migration or synchronization. The following error message appears: Too many connections.

Keywords

Too many connections

Possible Causes

The maximum number of connections to the source or destination database has been exceeded.

Solutions

1. Pause the task.

2. Run the following command to increase the maximum number of connections to the source or destination database, and then restart the task. We recommend that you change the maximum value to a value greater than 300.

   content_copy

   set global max_connections=xxx;

3. If this error persists, contact DTS technical support for troubleshooting.