Category Archives for "Administration"

1 Random SSRS Troubleshooting Notes

Notes to myself on troubleshooting issues with SSRS. Error: Report render failure. Error: An error has occurred during report processing. (rsProcessingAborted) This is probably a security issue.   Useful article: Microsoft Dynamics CRM 2011: Reports created by report wizard may fail when executing   List SPNs associated with a server: setspn –L <servername>   SQL […]

Continue reading

1 The Email Router and Microsoft.Crm.Tools.EmailAgent.SystemState.xml file

Occasionally, and for reasons that are unclear, the CRM Email Router file  Microsoft.Crm.Tools.EmailAgent.SystemState.xml gets corrupted which causes the Email Router service to stop (and your email along with it). If you find your Email Router is not running and a restart does not work-it immediately starts and stops, check the Windows Application event log to […]

Continue reading

How much space are my Attachments using, part deux

In the first article we discussed using SQL to determine the size of the Attachments in the database. My friend Aron Fischman shared with me similar queries using FetchXml:   <!–Email Attachment File Size Analysis–> <fetch distinct=’false’ mapping=’logical’ aggregate=’true’> <entity name=’activitymimeattachment’> <attribute name=’activitymimeattachmentid’ alias=’EmailAttachmentCount’ aggregate=’count’/> <attribute name=’filesize’ alias=’FileSizeSum’ aggregate=’sum’/> <attribute name=’filesize’ alias=’FileSizeAvg’ aggregate=’avg’/> <attribute name=’filesize’ […]

Continue reading

CRM 2013: Modifying Administration Navigation

While we’ve already discussed using the Quick View Menu to help with Dynamics CRM 2013 navigation, I thought I’d take the opportunity to show a technique to assist Dynamics CRM System Administrators. First of all, I would like you to download the CRM SiteMap Editor from Simpler Software: http://crmsolutionmanager.com/Download.aspx It’s free and is very helpful […]

Continue reading

Explorer! v3.3 for Dynamics CRM Released

Version 3.3 of Explorer! for Dynamics CRM has been released. This release fixes several bugs when extracting information from Dynamics CRM 4.0 and adds a new Bulk Analysis feature scans all entities and produces an Excel report showing the usage of all custom fields. Visit the Explorer! product page for more information and to download […]

Continue reading