sql error tracking emails
-
Friday, March 15, 2013 1:37 PM
Having an issue in CRM 2011. When certain users are tracking certain emails (haven't been able to narrow down a pattern yet), we are getting a SQL error. Nothing in the error other than SQL erros if it continues contact Microsoft. Also, one user gets the same error that pops up even when he is not doing anything ion Outlook but just has it open.
Do I look for the error info in SQL or in CRM?
We are running 2011 UR 12.
- Edited by DHpub Friday, March 15, 2013 1:49 PM
All Replies
-
Saturday, March 16, 2013 1:19 PM
Enable tracing for more details
Server tracing
http://support.microsoft.com/kb/907490/en-usClient Tracing
http://social.technet.microsoft.com/wiki/contents/articles/14522.enable-tracing-in-the-crm-2011-outlook-client.aspx -
Saturday, March 16, 2013 4:47 PM
1. Apply Update Rollup 11 If its not already applied
http://support.microsoft.com/kb/2739504
2. Delete temporary CRM Outlook cache
a. Start> All Programs> Microsoft Dynamics CRM 2011> Diagnostics
b. Click on the Advanced Troubleshooting tab and then Click the Delete button
3. Delete the SQL CE database on the Client machine:
a. Close Outlook
b. Browse to C:\Users\<loggedinuser>\AppData\Roaming\Microsoft\MSCRM\Client
c. Delete the EmailCache.sdf and the OutlookSyncCache.sdf files
d. Browse to C:\Users\<loggedinuser>\AppData\Local\Microsoft\MSCRM\Client
e. Delete the CRMcache.sdf file and the GUIDFalse.sdf file <---the GUIDFalse.sdf file will be a long alphanumeric name
f. Relaunch Outlook and the files will get recreated.
