Jukka Niiranen

Tag: Office 2013

  • Windows 8, Outlook 2013 and Dynamics CRM – part 2

    Back in August I wrote about my initial experiences of using a Windows 8 PC with Office 2013 to connect the Outlook client to Microsoft Dynamics CRM. During that time we only had the preview versions of both the OS and Office, so some quirks were naturally to be expected. Now that Windows 8 is generally available and also the RTM bits of Office 2013 can be downloaded from MSDN (with commercial launch expected by end of January), it’s a good moment to revisit the topic. Upon my latest test I came across a few configuration gotchas that I though might be useful to share for anyone who’s struggling with the same issues.

    Connecting to CRM Online with WLID

    Our official work setup is still on Windows 7 / Office 2010 level, but being the kind of eager early adopter that I am, my home PC’s have moved to the brave new world of Windows 8 some time ago already. I installed Office Professional Plus 2013 on a Windows 8 64-bit laptop that’s not joined to a domain, so my login credentials to Windows are linked to my Microsoft Account (previously known as Windows Live ID). In my first tests in August this was a blocker for using a CRM Online organization where the user’s WLID / Microsoft Account was different in CRM and on the local machine.

    Update Rollup 11 removed the need to manually enable Windows Identity Foundation (WIF) on Windows 8, but out of old habits I checked that it was available before configuring CRM. Launching the CRM client Configuration Wizard and selecting CRM Online on the Server URL field of the Configure Organizations prompt gave a familiar error: “Cannot connect to Microsoft Dynamics CRM server because we cannot authenticate your credentials.” Just like before, it appears that the Configuration Wizard automatically attempts to use the Microsoft Account of the local user for logging in to CRM Online. Logging out of the account in Internet Explorer and then logging in to CRM Online in the browser didn’t seem to resolve the issue with the Outlook client connectivity, as a further error message was presented later in the Initializing the Organization phase:

    There is a problem communicating with the Microsoft Dynamics CRM server. The server might be unavailable. Try again later. If the problem persists, contact your system administrator.
    [Expanded Information]
    Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8082. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.

    The KB article referenced in the error message discusses the following issue: “You receive an error message when you run a SQL Server Compact 3.5-based application after you install the 32-bit version of SQL Server Compact Edition 3.5 Service Pack 2 on an x64 computer.” However, downloading and installing the x64 version of Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop didn’t resolve the CRM configuration error, so I opened a support ticket with Microsoft. They instructed me that I also needed to install the Cumulative Update 2 for SQL Server Compact 3.5 Service Pack 2, which is a hotfix that you need to request a download link to be sent to you by email. After my SQL CE 3.5 had been updated to build 3.5.8082.00, I was finally able to connect my Outlook 2013 with our CRM Online demo organization.

    Connecting to CRM on-premise with IFD

    During the previous test with CRM Online I had also tried to connect the Outlook 2013 CRM client  to our production on-premise CRM server that is IFD configured. I kept receiving the following error: “Cannot connect to Microsoft Dynamics CRM server because we cannot authenticate your credentials. Check your connection or contact your administrator for more help.” Looking at the error details there was a message claiming “no credentials are available in the security package.” (more…)

  • Future stars: Dynamics CRM roadmap news from Las Vegas

    We didn’t yet get a new Statement of Direction or Release Preview Guide for the future releases of Microsoft Dynamics CRM from today’s eXtreme CRM 2012 Las Vegas keynote by Craig Dewar, titled “Microsoft Dynamics CRM – Now and In the Future”. That is scheduled to happen next week, but who wants to wait around for the information that has been shared to the privileged few who attended the eXtreme CRM session?

    Lucky for us who weren’t able to go to Vegas, the best new bits revealed at the session were tweeted out by outstanding #MSDYNCRM community contributors like Neil Benson, Shawn Tabor, Brad Koontz, Bob Hatcher and Eric W Cahoon. Here’s a “best of #eXtremeCRM tweets” collection that tries to summarize what was presented in Dewar’s session.

    Q4 2012: Polaris

    Let’s start with the updates coming in the very near future. The next release is codenamed “Polaris” will be out in Q4 2012, so this is the “Fall 2012” release we saw on an earlier roadmap slide. More specifically, the new functionality will be delivered as a part of Update Rollup 12 during December 2012 for both on-premise and for CRM Online customers.

    Polaris will contain upgrades to the browser UI as seen in the WPC 2012 session in July. It will include the Process Driven Refresh UI and deliver a more “flat” user experience to better match the look & feel of Office 2013. Also, the cross-browser support originally scheduled for Q2 2012 Service Update will now be delivered in December with UR12 and this part will affect also on-premise and hosted CRM environments. The previously delayed custom workflow activity support for CRM Online will be delivered within the same UR12 update schedule.

    New announcements made at the eXtreme CRM keynote for Q4 2012 include click-to-call integration with Lync and Skype (both of which are Microsoft products these days, in case you forgot). CRM Online customers will get a simple Bing Maps integration with maps embedded on the customer forms. Presumably the CRM Online subscription will in the future include a license to use Bing Maps on an internal application whereas customers who’ve bought perpetual server and client licenses from Microsoft need to acquire a separate license to use the mapping functionality through the API (remember: it’s not a free service, like the Bing Maps or Google Maps website).

    Q2 2013: Orion

    The release after Polaris carries the codename “Orion” and is scheduled for Q2 2013. What’s special about this release is that it will be CRM Online only. Whether on-premises and hosted CRM clients will be completely left without updates in Q2 remains to be seen, but the new release cadence suggest only a single major update for on-premises customers per year. The Update Rollup release schedule with an 8 week cycle should still remain unchanged, though, so it’s likely to be a bit of a mixed bag of what’s really “Online only” in terms of new or changed functionality. Update: it’s actually the Q4 2012 Polaris that will be Online only, see the comments at the end from Craig Dewar.

    As I’ve already speculated for a long time, the new Agaves in Office 2013 apps will be used as the means to deliver Dynamics CRM support for Outlook Web Access, both in OWA and MOWA (mobile app). This will finally enable tracking content from your inbox into CRM without having to live with the Outlook desktop client legacy. Also the synchronizing of items from Exchange will be possible on the server side with the Orion release in Q2 2013.

    Yammer integration, which presumably goes much deeper than the current integration solution built by Yammer before being acquired by Microsoft, is scheduled for Q2 2013. Other than this, concreted evidence of bringing social channels into Dynamics CRM was not leaked from Vegas, so we’ll need to wait a bit longer to see how Microsoft intends to deliver on the social story they’ve been promoting for CRM since this time last year. Back when we were still talking about Polaris as the R9 release this was supposed to connect Dynamics CRM with the external communities in a big way, but no major announcements have so far been made on this front.

    Ok, I did spot one physical evidence of social CRM from the Extreme CRM announcements, in the form of a new Social CRM solution built by Sonoma Partners. It’s baked into the updated version of CRM Demo Builder, which now allows you to provision CRM + SharePoint on the same, shared Office 365 platform, thus achieving single sign-on. Whether this particular Social CRM app will be made available to all CRM customers is something I’m not yet sure, but it looks like quite a solid little app for bringing Twitter feeds into CRM by using the same look & feel as the previous Activity Feeds solution. You can promote tweets into new/existing leads, contacts, accounts, cases or opportunities, after which you see the original tweet in CRM as an Activity Feed post. Nothing revolutionary in itself, but a welcome feature, if something like this is actually on Microsoft’s roadmap.

    That’s all of the news I picked up so far from the event by following the social networks. Did I miss any interesting tweet from #eXtremeCRM or an important piece of news? Leave a comment & let’s assemble the pieces of the Dynamics CRM roadmap together!

    Update 2012-09-04: I received clarification on the release roadmap from Craig Dewar himself, here’s the update:

    • “Polaris due Q4 2012 is online only with one exception. There is one capability in Polaris namely cross browser that is of such high interest we will release that capability on premise also.”
    • “Orion due Q2 2013 is online and on premise. It will include all Polaris functionality in addition to many new capabilities.”

    Based on my interpretation of the above, CRM Online customers will get the Polaris functionality first, while on premise and hosted CRM customers receive these updates 6 months later when Orion comes out.

  • To update or not to Update Rollup? That is the question

    Some time ago I wrote a parody about Dynamics CRM blogs that mainly seem to post news about the latest Update Rollups being released. Now I find myself writing an Update Rollup blog post myself. Is that a sign that I’ve run out of topics and slipped into the autopilot blogging mode? I hope not, but after reading quite a lot about the latest Update Rollup 10 for Dynamics CRM 2011 I decided to contribute a bit into the discussion.

    It’s always great to receive improvements to the software you spend all your days working with, isn’t it? Compared to a product like Java which Oracle promises to patch only four times a year, even if it’s about critical security updates (did you remember to uninstall your Java 7 yet?), Microsoft is doing quite an OK job with their update process and we see a steady stream of releases to make Dynamics CRM better one bit at a time. Even though Update Rollup 9 was cancelled after the beta program, MS is now back on track with their release schedule in the form of UR10 that came out two weeks ago.

    We have once again a great in-depth article from Dynamics CRM in the Field about all things Update Rollup 10. It tells all the details of the story from Microsoft’s perspective, but let’s evaluate the ups & downs of this latest release from the Dynamics CRM community perspective to get a complete picture, shall we? OK, here goes:

    The Ups

    There was quite a number of fixes promised for the CRM Outlook client in Update Rollup 10 that would potentially solve some of the stability issues many users have encountered when trying to use the CRM Outlook client for actual work in their environment. It’s now 2 years since the first beta of the completely rewritten Dynamics CRM Outlook client came out and many of us are certainly hoping that it would have reached a mature enough level where you don’t have to be afraid of if causing a flood of tickets to your helpdesk. Yes, some users may be quite happy with it as it is, but you’d be foolish not to prepare for potential issues when planning a large scale deployment of the Outlook client. Reaching that good ol’ Service Pack 2 type of confidence level would be just great.

    Another promising deliverable from UR10 is the improvements to query performance on large data sets. A new version of the performance optimization whitepaper has been released alongside the update, which describes the new options made available to tune the Quick Find performance. If you read the results of these tests by Chris Cognetta where the query time was decreased by over 80% in an environment with 1.5 million rows, it’s obvious this is an update worth paying attention to if you have or expect to have some “big data” in your CRM system.

    Finally, as many MSDN subscribers are now eagerly updating their PC’s to run Windows 8, Internet Explorer and even the Office 2013 Preview, the added support for all of these in CRM 2011 Update Rollup 10 is reason enough to grab the very latest CRM bits. Just don’t forget that UR10 alone is not enough, there’s some things you should know about Windows 8 RTM & CRM 2011.

    The Downs

    So, we now have a Quick Find that is working faster, which means it must be doing something differently, right? It is, and unfortunately in some cases this will result in a Generic SQL Error message being shown to the user. It appears that the new update is not quite comfortable dealing with a set of Quick Find columns that contains address fields. As some of you may remember, the address 1 & address 2 fields on the account & contact forms are actually not stored in the same database table as the rest of the default fields, rather they reside in the CustomerAddressBase table. The UR10 version of Quick Find may therefore not work properly if you try to search for records based on address fields like city or zip code. Yes, Microsoft says using these as search fields is against best practices, but the users will very often want to narrow down the customer data based on geographic variables, so taking it away from them can only act as a workaround until we have a new hotfix from MS.

    CRM developers might not be too concerned with performing actual queries on live customer data, but they will certainly be annoyed when encountering the following prompt after editing a JavaScript web resource: You have exceeded the maximum number of 200 characters in this field; it will be truncated. Doh! Making small changes to script files just became very tedious until Update Rollup 11 rolls along in 2 months time. Again, there’s a workaround to it (don’t use the editor, instead upload the file or use some helpful web resource tool from CodePlex), but it doesn’t really make anyone want to rush UR10 onto all their servers.

    Then we have stories of people applying UR10 and finding they can’t access any of their CRM organizations, due to an unhandled exception: Method not found: ‘Void Microsoft.Xrm.Sdk.Query.FilterExpression.set_IsQuickFindFilter(Boolean)’. Uninstalling UR10 appears to be the only known cure for this show stopper, which obviously is related to the aforementioned Quick Find changes on some level.

    Alternatively, if you’ve updated your CRM server from 4.0 to 2011, you may experience errors when trying to import a solution file: The element ‘savedquery’ has incomplete content. List of possible elements expected: ‘LocalizedNames’. Manually editing the XML to remove a view prior to importing the file is the available workaround, but again it can make the life of a system customizer quite difficult until there’s a fix available.

    OMG, what should we do with these UR’s?!

    The short answer is: always test first, then evaluate the ups & downs for your particular case. If you are struggling with the Outlook client, face performance issues with your huge CRM database or simply want to run CRM 2011 on Windows 8, going for Update Rollup 10 may be perfectly sensible for you. For someone who doesn’t have a compelling need to update, you may well decide to wait a bit longer and no one should blame you for it.

    That’s pretty much how it is with any Update Rollup. In reality there’s never going to be the perfect time to update. Knowing ahead what hotfixes will deliver the biggest gains for you or potentially break your CRM deployment would be a great skill to have. Instead of dreaming about it, here’s a few guiding principles I would recommend you to follow:

    • Always test the updates in your own test environment before planning live deployment. A virtual machine with your solutions & data is a good compromise, identical hardware is for people with enterprise level budgets (and problems).
    • Never be the first to update, always wait a couple of weeks from the release and read the CRM forums for experiences from others. Trust the wisdom of the crowds.
    • Coordinate the server and client update schedules to limit possible issues and maximize the benefits from the updates. While mixed environments tend to be supported, why risk it?
    • Do update your CRM. Staying too far behind in this “cloud first” era can soon turn out to be an expensive strategy, so reserve adequate time and resources for keeping your CRM up to date – on a regular schedule.

    Do you have any words of advise for people who are struggling with the “should I update to Update Rollup X” question? What’s your survival strategy?

    Edit 2012-09-09: Based on the discussions on the Dynamics CRM Forum, I’ve created a new wiki page for Microsoft Dynamics CRM 2011 Update Rollup 10 on the CRM Wiki on Technet. The purpose is to provide a single place where the Dynamics CRM community members could share their information on potential issues and known problems that they encounter when applying the latest Update Rollups, as well as naturally links to any solutions or workarounds that can help others who are struggling with the same problem. I’ve initially added links to 10 suspected issues with UR10, but you are very welcome to contribute by adding new links or additional information to the wiki page. In an ideal world, we could have similar pages for each new rollup that gets released and be able to more easily identify both the benefits and the dangers or applying the updates into our CRM environments. Let’s see if the wiki can serve us as a platform for such information sharing.