web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Trouble tracking email...
Microsoft Dynamics CRM (Archived)

Trouble tracking emails using Outlook client

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have installed CRM 2015 outlook client on a client's machine and they are connecting to a new online instance (with crm v4 data migrated).  Whenever I try to track an email and sync to CRM, it errors saying "Trouble communicating with the CRM server".  There are no connectivity problems.

 

If I look in the CRM web client and refresh the "activities" for the contact against which I am tracking the email while the sync is taking place, the Email appears for about a second and then disappears.

*update* - I have retrieved a trace, and am getting the below error.

The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.

I have uninstalled the SQL CE, uninstalled CRM outlook client and re-installed, which is a solution some people have suggested, but this has not worked.

Any ideas?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Have you tried to follow the KB support.microsoft.com/.../2616319

  • Community Member Profile Picture
    Community Member on at

    Yes - I have taken all steps in this KB, but I am still getting the same error, and the following message in trace files.

    System.Data.SqlServerCe.SqlCeInvalidDatabaseFormatException (0x80004005): The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade()

    I am wasting days on this - any help appreciated.

  • Community Member Profile Picture
    Community Member on at

    Looking in process explorer as described in the doc, the System.Data.SqlServerCe assembly is coming from c:\Windows\assembly\NativeImages_v4.0.30319_32\System.Data rather than the path described in the kb - is this the problem?

  • Suggested answer
    Aldo Macedo Profile Picture
    Aldo Macedo on at

    Hello Glaidler,


    >CrmSqlCeConnection::ExecuteInNewConnection() Unexpected Exception: System.Data.SqlServerCe.SqlCeInvalidDatabaseFormatException (0x80004005): The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.
    This indicated to me that there was likely to be an old SQL CE file (.sdf) lying around under the user’s AppData folders.


    You could try to do the following process hoping this can solve your incident:

    1. Close Outlook

    2. Delete temp files with Diagnostics tool

    3. Clear cache in your machine using http://www.piriform.com/ccleaner

    4. Go to C:\Users\User\AppData\Roaming\Microsoft\MSCRM\Client and C:\Users\User\AppData\Local\Microsoft\MSCRM\Client to delete all SDF files.

      5. Then open again CRM Outlook and wait for synchronization.

      6. Do testing and verify if there are no conflicts to track elements in Outlook

     

    If you see in sync jobs that there are problems to sync appointments run the next process (it is also recommended to run the process even if there are no problem with items sync):

    1. Identify affected users
    2. Download Calendar Checking Tool in same version as office 32 or 64 bits     http://www.microsoft.com/en-us/download/details.aspx?id=28786
    3. Unzip tool
    4. Run calcheck application
    5. Open CalCheckErr Excel file
    6. Identify if there are corrupt items (empty file means no corrupt items)
    7. Delete corrupt items in Outlook Calendar or CRM Calendar (Appointments or recurring Appointments)
    8. Delete CalCheckErr Excel File
    9. Run CalCheck application
    10. Verify if file is empty, if not run process until file is clean

    Removing corrupt elements will improve performance  and connectivity in Outlook and CRM.

    To detect in a better way corrupt elements in Outlook Calendar

    a.    Open Microsoft Outlook and click on the Calendar folder.

    b.    Go to the View menu and select Arrange By -> Current View -> Active Appointments to see a list of all of the active appointments for the current user.

    c.     Scroll through the list until you locate the damaged appointment. It should be easy to because it will be the same appointment for which Microsoft Outlook routinely displays reminders. If for some reason you don't know the name of the damaged appointment, you can try opening appointments -- damaged appointments usually won't open.

    d.    Once you have located the corrupt appointment, delete it.


    Best regards,

  • Community Member Profile Picture
    Community Member on at

    Hi, I have tried all the above, and the same exception is appearing in the traces.  What else can I look at?

  • Community Member Profile Picture
    Community Member on at

    Have you found a solution for this issue? I'm trying to support a user with this exact issue, except with the CRM 2013 SP1 RU1 client, and have tried all suggested steps with no solution. Most posts online have resolved by rebuilding the users workstation but that is not a great option if not absolutely necessary. 

  • Community Member Profile Picture
    Community Member on at

    Hello Glaidler,

    Please perform the below steps. This should resolve the issue.

    Close Outlook.

    Replace Program Files\Microsoft Dynamics CRM 2015\Client\bin\System.Data.SqlServerCe.dll with the version found in C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop. Note: Do not be alarmed if the System.Data.SqlServerCe.dll does not currently exist in the Dynamics\Client\bin\ directory.

    Delete SDF files that were created in SQL CE 3.5 are incompatible with SQL CE 4.0. Therefore, you must delete all SDF files in %localappdata% and %appdata% .

    Restart Outlook.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans