Microsoft KB Archive/941445

= How to change the amount of trace history kept by Microsoft Dynamics CRM 3.0 Mobile in the MobileSubscriptions database =

Article ID: 941445

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0
 * Microsoft CRM Mobile, when used with:
 * Microsoft Dynamics CRM 3.0

-



Source: Microsoft Support



RAPID PUBLISHING
RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.



Action
You may notice that the size of the _MSCRMMobileSubscriptions database grows continuously and that the three trace tables below contain a lot of records.

IntegrationTrace

IntegrationExtendedTrace

IntegrationTraceIndex



Result
This will cause your database to increase in size if the historical records are not cleaned up within a certain amount of time.



Cause
In a Microsoft Dynamics CRM Mobile implementation there are five databases created:

_MSCRMMobileContext

_MSCRMMobileDeployment

_MSCRMMobileMessaging

_MSCRMMobileMetabase

_MSCRMMobileSubscriptions

In the &quot;_MSCRMMobileSubscriptions&quot; database there are three tables that are used to store historic trace information related to synchronization with the Mobile clients, these tables are:

IntegrationTrace

IntegrationExtendedTrace

IntegrationTraceIndex

You may notice that the size of the _MSCRMMobileSubscriptions database grows continuously and that the three trace tables above contain a lot of records.



Resolution
There is a mechanism built-in to remove historic trace data after a specified number of minutes. This setting can be found in the MBSIntegrationService.exe.Config file which is typically located in the following folder:

\Program Files\Microsoft CRM\CRM Mobile\bin

Within this config file locate the following line:



The value specified here is the time in Minutes to keep the trace history. The default is 1440 = 24 hours.



MoreInformation
Note 1: Setting this config file value to 0 (zero) does not turn off tracing, it will turn off purging of the trace history so everything will be kept.

Note 2: This mechanism fails to work if the value in minutes specified in the config file is a multiple of 60, i.e. 60, 120, 180 ... 1440, etc. When setting the value of this parameter choose a value that is not a multiple of 60.

<div class="summary_section">

DISCLAIMER
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

Keywords: kbmbsmigrate kbnomt kbrapidpub KB941445

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.