Connector for Microsoft Dynamics configuration settings that can be used to control some of the default behaviors for logging and retries

There are some configuration settings that can be added or changed in the ConnectorServiceHost.exe.config to update default behavior with respect to retries and log cleanup; they are as follows: 

Config Setting

Behavior

Remarks 

HousekeepingCleanupLogs

True: The Housekeeping task should run CleanupLog.proc.sql and CleanupRetryTask.proc.sql

False: The Housekeeping task will run only run CleanupTaskDeletionTracking.proc.sql (not recommended)

Caution: Log entries and expired Retries can degrade overall system performance if this setting is False

HousekeepingStartTime

The time of day the housekeeping task should run, default is DateTime.UtcNow() or service start time

It may make sense to set this to a time of day that has less load, such as a time after normal business hours

Connector uses the DateTime.TryParse() method to parse this setting, see this article for the proper string format.

msdn.microsoft.com/en-us/library/ch92fbc1(v=vs.110).aspx

If the setting can't be parsed then the default of DateTime.UtcNow() is used for this setting

HousekeepingRunImmediately

True: Housekeeping should run immediately upon service start (Default)

False: Housekeeping task should wait until next scheduled run time after service start

 

HousekeepingExpireDayOffset

First usage: Number of days to keep retries that have completed successfully (Default = 3 days)

Second usage: Number * 2 = days to keep retries that were stopped by the user or ran out of retry attempts (Default = 3 *2 = 6)

Making this value smaller gives you less time to restart failed records; making it larger will give you more time to see the log.

Be aware that Making this number too large can affect performance as retries that have run out of attempts over time can degrade overall system performance

 Task Scheduling configuration settings:

ConcurrentRetryTaskLimit

Number of concurrent Retries the system will queue

Also number of connections to Microsoft Dynamics CRM that could potentially be created at any given time

MaximumRetries

Maximum attempts a given retry will make before stopping and waiting for the user interaction to resolve the issue

 

RetryInterval

Number of seconds from initial attempt to first and second retry attempts, Default = 5

RetryInterval ^ CurrentRetryAttempt

5 to 5^MaximumRetries