Description

When running the Dynamic Link Manager in CAST, a spike in the number of connections to the database may be encountered.

If many other connections are currently running, then the error "too many clients already" may be encountered during the Dynamic Link Manager portion of the analysis as shown in the error below:

2017-03-03 10:26:10,476 [1] ERROR DynamicLinks main - Loading failed: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.ProviderIncompatibleException: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. ---> System.Data.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> Npgsql.NpgsqlException: FATAL: 53300: sorry, too many clients already

Observed in CAST AIP
Release
Yes/No
8.2.3(error)
8.2.x, x<3(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS3(error)
CSS2 (tick) 
Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  1. Run Dynamic Link Manager with many connection profiles in CAST-MS
Impact of the Problem

The impact of the problem on the analysis or the dashboard is: Analysis crashes so no results can be seen on the dashboard

Action Plan

The Dynamic Link Manager is scanning the cast-ms.connectionProfiles.pmx.

For each connection profile, the DLM is checking if the Management database defined in the connection profile exists by running a query.

If the number of connection profile is exceeding the number of allowed connection, the issue occurs.

To fix the problem, proceed as follows:

  1. Reduce the number of connections to CAST-MS in the connection profile list. This can be done through the connection profile list editor: More on this can be seen in the documentation here: Launching the CAST Management Studio

    Alternatively
  1. it can be done by editing the file cast-ms.connectionProfiles.pmx that is in : %APPDATA%\CAST\CAST\<AIP Version>.
    1. Edit this file to reduce the number of connection profiles. Each line in this file between the lines below represents a connection profile. The "name" field in the connection profile line can assist you in determining which values can be deleted.

      <connectionProfiles>
      <each line in this section represents a connection profile>
      </connectionProfiles>
Notes/comments
Ticket # 8180
Related Pages