Archive for the ‘Misc’ Category
Dynamics 365 Outlook Client Not Rendering Views After September 2018 Update
The 5th September 2018 Office 365 update has stopped the Dynamics 365 Outlook client from rendering views.
This is not resolved by the ‘EnableRoamingFolderHomepages’ registry key that fixed a similar issue after the October update.
To get it working again, you’ll need to roll back to the previous update, then turn off automatic updates until it is resolved:
See the edit at the bottom for a better workaround!
Rollback the update
To roll back to the previous update, run the below from a command prompt
Read the rest of this entry »
Outlook Client Repeated Login Prompts Post V9 Upgrade
After your Dynamics 365 organisation has finally been updated to the July 2017 October 2017 December 2017 February 2018 V9 version, you may find that your Outlook client (full version, not the lightweight app) no longer works.
Uninstalling and re-installing the version offered via the ‘Get Apps’ page within Dynamics 365 doesn’t help as you are repeatedly prompted for your login when trying to configure the organisation.
Viewing the trace log gave the error:
Metadata contains a reference that cannot be resolved: 'https://crm_url/XRMServices/2011/Organization.svc?wsdl&sdkversion=8.2
This is because the Outlook client is still using the old SDK (8.2) which is still using SSL rather than the TLS1.2 protocol for authentication required by V9.
The solution is to install update KB4054414 after installing the Outlook client.
Silverlight no longer works in Chrome 42
In Google’s continuing effort to annoy me, starting with Chrome version 42, the Silverlight plugin no longer works. This is due to Google no longer supporting NPAPI plugins (see here).
To get around it until September 2015, you can use the below fix to re-enable NPAPI.
1. Type the below into the Chrome address bar and press enter: –
chrome://flags/#enable-npapi
2. Click on ‘Enable’ under ‘Enable NPAPI’
3. Click on ‘Relaunch Now’ when it appears towards the bottom of the screen
You’ve now got until September to re-write your Silverlight controls in a compatible technology. Good luck!
Chrome 37 breaks CRM 2011 and 2013 functionality
Google has removed a number of APIs from Chrome 37 which is causing a lot of issues with CRM 2011 and CRM 2013. So far I’ve noticed: –
- You can no longer add options to Option Set fields via customisation
- Changes made to an email in a workflow are not saved when the save button is clicked
- The ‘Upload’ button on the SharePoint list component no longer works
- Anything using the ‘window.showModalDialog’ function no longer works as the API has been deprecated
- Can no longer save field properties such as ‘Visible by default’
- Export to Excel no longer works
In order to fix the problem until Microsoft issue a real fix, you can re-enable the deprecated features by following the below: – Read the rest of this entry »
Moved to WordPress
Unfortunately, Posterous is closing down, so I’ve transferred my blog to WordPress.
Some of the SQL and JavaScript formatting got lost during the transfer, so I’m currently in the process of checking it all over. If you find anything not working, leave a comment and I’ll get it fixed.
Thanks!
Microsoft Community Contributor Award
Well this was a nice way to end the week!
I’ve just received an email from Microsoft informing me that I have been recognised with a Microsoft Community Contributor Award. This is awarded to people who freely contribute their time to helping others in Microsoft online communities.
I’m honoured, thank you Microsoft!
Scribe Certified!
After using Scribe for most of my CRM integrations for the last 2 years, it was about time I took the certification exams.
Although I have been using the product for some time, the training material provided was invaluable and I learnt a lot that I would never have picked up in day to day use. It’s well worth reading/watching if you use or are planning on using Scribe.
I’m pleased to say that I passed both the Server and CRM adapter exams. Not a bad start to 2011!
CRM Timeline
Lauren Carlson over at Software Advice, has created a great interactive timeline showing the growth of CRM software over the last 3 decades. It’s very interesting to see how much has changed over the last 30 years and I can’t wait to see what happens in the next 30! Keep an eye on it, as it will be updated over time.
Internet Explorer 9 – First Impressions
I’ve just downloaded and installed the public beta of the next version of Internet Explorer, IE9 and wanted to share my first impressions.
Once installed, the first noticeable difference is how minimal the interface has become. The address bar and tabs section seem to take up roughly 66% less screen space, since the address bar, search box and tabs are now all located on the same row. As I usually have a lot of pages open, I didn’t think I’d like the repositioning of the tabs, but it really hasn’t caused me any problems.
The next thing I noticed is the speed. It really flies. Microsoft have added GPU acceleration to IE9, so a lot of image rendering is now performed by your graphics card rather than your CPU.
Another great new feature, is the ability to add web shortcuts to your taskbar. You just drag the favicon from the address bar to your taskbar to create a shortcut. This is great if you want quick access to applications such as your email and it really feels like you’re launching an app rather than a browser.
Checking SQL table sizes
I wanted a way to find which tables were using the most storage in my SQL databases. The stored procedure sp_spaceused will show this data for a single table, but I wanted to view every table at once. The below SQL query will run against any SQL 2005 database and show you it’s table sizes in descending order. As expected, the ActivityMimeAttachment table in my CRM database was pretty huge!
SELECT sys.schemas.[name] AS [Schema], sys.tables.name AS [Table], COALESCE([Row Count].[Count], 0) AS [Rows],COALESCE(8192 * [Data Pages].[Count],0) AS [Data Bytes], COALESCE(8192 * [Index Pages].[Count],0) AS [Index Bytes] FROM sys.tables INNER JOIN sys.schemas ON sys.schemas.schema_id = sys.tables.schema_id LEFT OUTER JOIN (SELECT object_id,SUM(rows) AS [Count] FROM sys.partitions WHERE index_id < 2 GROUP BY object_id) AS [Row Count] ON [Row Count].object_id = sys.tables.object_id LEFT OUTER JOIN (SELECT sys.indexes.object_id,SUM(CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END) AS [Count] FROM sys.indexes INNER JOIN sys.partitions AS p ON p.object_id = sys.indexes.object_id AND p.index_id = sys.indexes.index_id INNER JOIN sys.allocation_units AS a ON a.container_id = p.partition_id GROUP BY sys.indexes.object_id) AS [Data Pages] ON [Data Pages].object_id = sys.tables.object_id LEFT OUTER JOIN (SELECT sys.indexes.object_id,SUM(a.used_pages - CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END) AS [Count] FROM sys.indexes INNER JOIN sys.partitions AS p ON p.object_id = sys.indexes.object_id AND p.index_id = sys.indexes.index_id INNER JOIN sys.allocation_units AS a ON a.container_id = p.partition_id GROUP BY sys.indexes.object_id) AS [Index Pages] ON [Index Pages].object_id = sys.tables.object_id ORDER BY [Data Bytes] desc