DataServicesWindowsService.exe.config Configuration Reference

The file DataServicesWindowsService.exe.config gives server-side configuration settings for Data Services.

To configure this configuration file, do the procedure in this topic.

Prerequisites

Good to Know

How to Start

  1. Open (AgilePoint Data Services installation folder) C:\Program Files\AgilePoint\AgilePoint Data Services\DataServicesWindowsService.exe.config.

Procedure

  1. In the DataServicesWindowsService.exe.config file, add or change these keys as necessary for your environment.
    Field NameDefinition

    DbConnectionString

    Function:
    Specifies this connection string to connect to the database that contains the WF_DATA_TRACKING table. This table stores the output of the data tracking.
    Accepted Values:
    An appSettings key in the following format:

    <add key="DbConnectionString" value="[database connection string]" />

    Default Value:
    None
    Example:
    <add key="DbConnectionString" value="server=demo3;database=AP_Data_Svcs;trusted_Connection=yes" />

    TempDbConnectionString

    Function:
    Specifies the same value of the connection string that is configured for the Data Services AgileConnector.

    For more information, refer to DataService AgileConnector.

    This connection string to be used to connect to the database which contains WF_DATA_SERVICE_TEMPDB table that is completed by the AgileConnector with the before and after XML values.

    Accepted Values:
    An appSettings key in the following format:

    <add key="TempDbConnectionString" value="[Database connection string which is configured for Data Services AgileConnector]" />

    Default Value:
    None
    Example:
    <add key="TempDbConnectionString" value="server=demo3;database=AP_Data_Svcs;trusted_Connection=yes" />.

    ErrorDbConnectionString

    Function:
    Specifies the connection string to connect to the database that has the WF_DATA_SERVICE_ERRORDB table.

    If Data Services has any errors while processing the WF_DATA_SERVICE_TEMPDB, it moves the records into the WF_DATA_SERVICE_ERRORDB table. You can see the list of errors in ERROR_DESC column of this table to fix the error before moving the records back to the WF_DATA_SERVICE_TEMPDB for reprocessing.

    To move these records from WF_DATA_SERVICE_ERRORDB to WF_DATA_SERVICE_TEMPDB, use the utility, (AgilePoint Data Services installation folder) C:\Program Files\AgilePoint\AgilePoint Data Services\DataServicesErrorUtility.exe.

    Accepted Values:
    An appSettings key in the following format:

    <add key="ErrorDbConnectionString" value="[Database connection string]"/>

    Default Value:
    None
    Example:
    <add key="ErrorDbConnectionString" value="server=demo3;database=AP_Data_Svcs;trusted_Connection=yes"/>

    EnableDataPopulation

    Function:
    Lets you set the value to true to activate the data population.
    Accepted Values:
    • true - Turns on data population.
    • false - Turns off data population.
    Default Value:
    true

    EnableDataTracking

    Function:
    Lets you set the value to true to activate the data tracking.
    Accepted Values:
    • true - Turns on data tracking.
    • false - Turns off data tracking.
    Default Value:
    true

    TimerInterval

    Function:
    The timer interval, in seconds, used by Data Services to check for new entries in the database.
    Accepted Values:
    An integer, representing a number of seconds.
    Default Value:
    150

    FailureNotificationEmailID

    Function:
    Specifies an e-mail address to which to send a notification if an exception occurs in Data Services.

    This setting is optional. If you do not create this key, no e-mail notifications are sent for Data Services exceptions.

    Accepted Values:
    An appSettings key in the following format:

    <add key="FailureNotificationEmailID" value="[E-mail address]"/>

    Default Value:
    None
    Example:
    <add key="FailureNotificationEmailID" value="admin@mydomain.com"/>

    Max_Attempts_Before_Fail

    Function:
    Specifies the maximum number of times Data Services attempts to retry an operation if an exception occurs, such as AgilePoint Server failure, or SQL Server failure.

    This setting is optional. If you do not add this key, Data Services retries an operation 10 times by default.

    Accepted Values:
    An appSettings key in the following format:

    <add key="Max_Attempts_Before_Fail" value="[number of retry attempts]"/>

    Default Value:
    None
    Example:
    <add key="Max_Attempts_Before_Fail" value="20"/>
Note: If the following message appears, run the Client Utility Tool from the AgilePoint installation program: "Failed to add Service model information in [path]\web.config. Please use SVCClient Utility tool to update it before using." For more information, refer to Run the Windows Service Client Utility Tool.