Partager via

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

  • Article

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

Comments

  • Anonymous
    July 24, 2015
    can you give an example how to use HousekeepingCleanupLogs and related settings.

  • Anonymous
    July 26, 2015
    @Omer - these settings should only ever be changed if you are experiencing overall system degradation and want troubleshoot what is going on.

  • Anonymous
    July 08, 2016
    What is the default for MaximumRetries?

    • Anonymous
      July 11, 2016
      7
      • Anonymous
        July 15, 2016
        Thanks.

  • Anonymous
    August 31, 2016
    Hi the hetz,I got log that said, "Text: Completed: 1000 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. 1000 record(s) were filtered. Total runtime was 1076.864551 seconds." The map is to sync Open Statement (retail) to Sales Order in CRM.But after I check in CRM, there's no Sales Order created. How can I trace this issue? Is there any log to know the content of those 1000 records.?Thanks,Siu Chon

    • Anonymous
      September 01, 2016
      The message - 1000 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. 1000 record(s) were filtered. Total runtime was 1076.864551 seconds - indicates that 1000 records were filtered, which means that they were NOT sent to CRM. You should check the filter on the map, because currently it is filtering all of your records.
      • Anonymous
        September 05, 2016
        So I should wait again? I thought it was completed. Because here is what I got: "“Text: Completed: 1000 record(s) have been written......"
      • Anonymous
        September 05, 2016
        Hi thehetz,I have waited for several hours, but the 1000 records haven't created in CRM. Is there a way to see the content of those 1000 records?Thanks
        • Anonymous
          September 06, 2016
          Did you change the filter on the map?
          • Anonymous
            September 26, 2016
            Yes, I set some filter for that map.

  • Anonymous
    December 15, 2016
    MaximumRetries is with 7, but the connector does not perform 7 attempts, any tips?

  • Anonymous
    November 23, 2017
    How to pass DateTime values in Connector