Archive for October, 2011

Update Rollup 5 for Microsoft Dynamics CRM 2011

October 26, 2011

The Microsoft Dynamics CRM Sustained Engineering (SE) team released Microsoft Dynamics CRM 2011 Update Rollup 5 on Tuesday, October 25, 2011.

The links below point to important information about Update Rollup 5:

Release Channel Schedule

The resources available at these links will be active according to the following Release Channel Schedule:

  • CRM Online Datacenter: October 18      to October 25, 2011
  • Microsoft Download Center: October  25, 2011
  • Microsoft Update: November 8, 2011

General Details about Update Rollup 5

  • Update Rollup 5 cannot be uninstalled.
  • Client packages installed manually by downloading the packages and running install will require administrative privileges.  If the client packages are installed via the Windows Update (Microsoft Update) system, they will not require administrative privileges.
  • For help with installation, please see the Installation Information section in KB2567454.

Dates for Future Update Rollups

Update Rollup 6 is to be delivered on its predefined schedule, 16 weeks after Update Rollup 4, which puts the delivery in January 2012.

Error occurs when you run the “Synchronize with CRM” function in the Microsoft Dynamics CRM 2011 client for Outlook

October 21, 2011

SYMPTOMS

Assume that you use the Microsoft Dynamics CRM 2011 client for Microsoft Office Outlook and that folder redirection is enabled on the client. When you try to track an item or run the Synchronize with CRM function in this situation, you receive an error message that resembles the following:

[2011-09-07 11:11:08.517] Process:OUTLOOK |Organization:00000000-0000-0000-0000-000000000000 |Thread: 24 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor
at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException)
at CrmException..ctor(String message, Exception innerException)
at CrmSqlCeConnection.<Open>b__2(SqlCeException ex)
at ExceptionFilter.TryFilter(Action body, Predicate`1 filter, Action`1 catchClause)
at IdMappingTable.MarkAllItemsNotVisited()
>Crm Exception: Message: SQL CE Database file is being used by a different process, ErrorCode: -2147220970, InnerException: There is a file sharing violation. A different process might be using the file. [ \\<server>\C$\<user>\Microsoft\MSCRM\Client\OutlookSyncCache.sdf ]. 

CAUSE

This problem occurs because of a limitation in Microsoft SQL Server 2000 Windows CE Edition 3.5 (SQL Server CE 3.5). 

RESOLUTION 

To run Microsoft Dynamics CRM 2011 when the Application Data folder is on a remote share, follow these steps:

  1. Install SQL Server CE 4.0. To do this, visit the following Microsoft website:

    In SQL Server CE 4.0, 64-bit clients do not have to install the 32-bit version.
    NoteThis step requires elevated permissions.

  2. Add the following XML code under the configuration element in the CrmClient{14B13B7A-CA08-40bd-AC60-8C45367E807C}.config file in the PFiles\MSCRM\Client folder:
    <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
    <assemblyIdentity name="System.Data.SqlServerCe"
    publicKeyToken="89845dcd8080cc91"
    culture="neutral" />
    <bindingRedirect oldVersion="3.5.1.0"
    newVersion="4.0.0.0"/>
    </dependentAssembly>
    </assemblyBinding>
    </runtime>

    NoteThis step requires elevated permissions.

  3. Delete all SDF files in the %localappdata% and %appdata% folders. For more information, see the “List of databases in CRM” section.

    Note
    SDF files that were created in SQL Server CE 3.5 are incompatible with SQL Server CE 4.0.

Warning

After you upgrade from SQL Server CE 3.5 to SQL Server CE 4.0, you may experience a decrease in performance the first time that you run Microsoft Dynamics CRM. This behavior occurs because Microsoft Dynamics CRM must re-create all caches. Some caches are affected by the size of the Inbox.

Verification steps

To verify that you have applied the resolution correctly, follow these steps:

  1. Start Outlook after you perform all the steps from earlier in the “Resolution” section.
  2. Make sure that the Microsoft Dynamics CRM plug-in starts correctly.
  3. Start the Process Explorer tool.
    To download Process Explorer, visit the following Microsoft website:

  4. Find the Outlook.exeprocess, and then double-click it.
  5. Select the .NET Assemblies tab, and then expand AppDomain: SharedDomainif it is not expanded already.
  6. Find System.Data.SqlServerCe in the list. Make sure that the path contains the following version of SQL Server CE:
    C:\windows\assembly\GAC_MSIL\System.Data.SqlServerCe\4.0.

    Note
    If the path contains SQL Server CE 3.5.1.0, assembly redirection will not work.

List of databases in CRM

  • %LocalAppData%\Microsoft\MSCRM\Client
    • CrmCache.sdf

      Note
      This file contains non-metadata platform caches.
    • {Guid}[true|false].sdf

      Note
      This file contains MAPI store internal storage.

    Note There may be multiple files of this kind, for offline and online use.%AppData%\Microsoft\MSCRM\Client

    • EmailCache.sdf

      Note
      This file contains mappings between CRM and MAPI items.
    • OutlookSyncCache.sdf

      Note
      This file contains internal state for sync.

SharePoint 2010: From domain\username to User Full Name

October 9, 2011

An early issue was seeing “domain\username” at the top right of the user screen – for example, “sharepoint\brian” instead of the user’s real name – Brian Lara. I found some guidance on the web about fixing this with SharePoint 2007, but as things have shifted around in SharePoint 2010, it wasn’t directly applicable.

Here’s what I did with SharePoint 2010:

1. Opened Central Administration on SharePoint 2010, logged in as the Administrator.

2. Clicked into “Application Management,” then “Manage Service Applications.”

3. Scrolled down to “User Profile Service Application,” and clicked to open that.

4. Clicked “Manage User Profiles” under the main People heading.

5. Searched for the account I was looking for – “brian” – and made the changes so her correct first name, last name, and full name were showing.

6. Saved – and now I’m hoping for the best. With SharePoint 2007 it took up to 30 minutes to become available; we’ll see with SharePoint 2010.

Update Rollup 19 for Microsoft Dynamics CRM 4.0 (KB 2550097)

October 8, 2011

Microsoft has released Update Rollup 19 for Microsoft Dynamics CRM 4.0 Server, Microsoft Dynamics CRM for Microsoft Office Outlook, Microsoft Dynamics CRM Data Migration Manager, Microsoft Dynamics CRM 4.0 Language Packs, and Microsoft Dynamics CRM 4.0 E-mail Router.

For more information about this release, see Microsoft Knowledge Base article 2550097:

Update Rollup 19 is available for Microsoft Dynamics CRM 4.0

To maintain parity between the application components of Microsoft Dynamics CRM 4.0, this update rollup includes packages for Microsoft Dynamics CRM 4.0 Server, Microsoft Dynamics CRM for Outlook, Microsoft Dynamics CRM Data Migration Manager, Microsoft Dynamics CRM Language Packs, and Microsoft Dynamics CRM 4.0 E-mail Router.

Update Rollup 4 for Microsoft Dynamics CRM 2011

October 7, 2011

The Microsoft Dynamics CRM Sustained Engineering (SE) team released Microsoft Dynamics CRM 2011 Update Rollup 4 on Thursday, September 22, 2011.

The links below will take you to the necessary information about Update Rollup 4. If a link does not work, please refer to the Release Channel Schedule below to make sure it is past the release date listed.

Release Channel Schedule

  • CRM Online Datacenter: September 15 to September 22, 2011
  • Microsoft Download Center: September 22, 2011
  • Microsoft Update: September 27, 2011

General Details about Update Rollup 4

Client packages installed manually by downloading the packages and running install will require administrative privileges. If the client packages are installed via the Windows Update (Microsoft Update) system, they will not require administrative privileges.

For help with installation, please see the Installation Information section in KB2556167.

 

Dates for Future Update Rollups

While the CRM team strives to deliver Update Rollups every 8 weeks, there are some scheduling changes that affect Update Rollup 5 and Update Rollup 6. The dates below are for informational purposes and may change. Changes will not be made to this blog post but included in the Update Rollup 5 blog entry.

Update Rollup 5 will be delivered earlier than the 8-week cycle and is scheduled to release at the end of October 2011.

Update Rollup 6 will be delivered on its predefined schedule, 16 weeks after Update Rollup 4, which puts the delivery in January 2012.

HJ-Split – Freeware multi-platform file splitters

October 6, 2011

HJSplit is a popular freeware program to split and recombine files. The program is available on Windows, Linux and a variety of other platforms.

Why should one want to split and recombine files? For instance, think of a file of 50 Mb, and try to send it to a friend, post it in a newsgroup or upload it to a Website or FTP server. It is usually easier to send/receive, upload/download smaller parts than handle the entire file in one go.

HJSplit can also be useful for backups. A file of e.g. 10 gigabytes in size can be split into smaller parts which then can be burned to CD’s, DVDs, copied to USB sticks or uploaded to an online backup service.

HJSplit for Windows and Linux support file sizes of over 100 Gigabytes, MD5 checksums, file-compare, “run without install” and both editions are fully portable.

http://www.hjsplit.org/

Gantt Lite and Gantt Pro

October 5, 2011

“Gantt Lite” and “Gantt Pro” are iPhone and iPad App’s that allows Project Managers and Planners to carry Microsoft Project file on their iOS devices. This app provides an interactive way to work on Gantt Chart and also provides a holistic view of the Gantt Chart in the MS Project Plan.

This app has been tested with sample plans from varied industry and geography to ensure the tool works with all kinds of MS Project plans. The App works with MS Project 2010, 2007 and 2003 versions. Please view user documentation and videos for more information on using the App.
 
Salient Features

import plans from Dropbox,email Inbox and iTunes
A Bird’s-eye view of Gantt to provide easy navigation and present a holistic user experience
Calendar View
Critical Path View
Interactive Gantt – Pinch to zoom on the Gantt to change time scales.
import Plans from your Project Server directly using gAppServer plugin
Ability to view MS Project 2010, 2007 and 2003 files
 
Support

Gantt Lite / Pro App Development Team is committed to providing Project Managers with an effective tool. Kindly report any issues at ganttsupport@i2econsulting.com to enable developers fix the issue and provide a defect free tool.

http://www.i2econsulting.com/ganttlite/ganttlite.html

Creating Dashboards for Microsoft Project Server 2010

October 4, 2011

The purpose of this document is to provide sufficient detail to fully design and implement Business Intelligence dashboards that support an Enterprise Project Management (EPM) Solution, which consists primarily of Microsoft SharePoint Server 2010 and Microsoft Project Server 2010. This document also includes detailed steps on how to replicate reports and dashboards that are included in the Project Server 2010 demonstration and evaluation pack that is available on the Microsoft Download Center. The purpose is to help you easily create reports and dashboards for your environment with similar characteristics. For related information, see the Business Intelligence Resource Center for Project Server 2010.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26557

Microsoft Project Server 2010 Reporting with Excel Services

October 3, 2011

The purpose of this document is to provide enough detail to be able to create and deploy reports that support the deployment of a Microsoft Enterprise Project Management (EPM) Solution. Microsoft EPM Solution relies on Microsoft SharePoint Server 2010, Microsoft SQL Server 2008 or 2008 R2, Microsoft Project Server 2010, and Microsoft Project Professional 2010. Although each individual component of the solution is well documented on TechNet and MSDN (for Business Intelligence), little documentation exists, as of today, that describes a step-by-step approach to building reports specific to Project Server 2010 data with Excel and Excel Services. For related information, see the Business Intelligence Resource Center for Project Server 2010.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26556