Admin: How to…

Overview

The following section provides useful guidance on how to carry out a range of common operations tasks.

Change the Database Connection Timeout

The DatawarehouseTimeoutMinutes field, in the rpi_Clients table in the Pulse operational database, can be used to control the data warehouse connection timeout. It defaults to the value 0. The field must be changed through use of a SQL script - its update via Server Workbench is not supported.

Change the Database Connection Details

Pulse and Pulse_Logging operational database connection details are configured in the server .config files.

These are:

Interaction API: web.config

Resonance.NodeManagerService.exe.config

Resonance.ExecutionService.exe.config

In all cases, the connection strings will be listed as per the example:

XML

<connectionStrings>
  <add
    name="LoggingDatabase"
    connectionString="Server=localhost;Database=Pulse_Logging;Integrated Security=true"
    providerName="System.Data.SqlClient"
  />
  <add
    name="OperationalDatabase"
    connectionString="Server=localhost;Database=Pulse;Integrated Security=true"
    providerName=""
  />
</connectionStrings>

If you wish to take advantage of .NET’s automatic connection retries feature, please see the following article:

https://msdn.microsoft.com/en-

us/library/system.data.sqlclient.sqlconnectionstringbuilder.connectretrycount(v=vs.110).aspx

Window services will require a restart once a configuration file has been changed.