Move over CRM and AX! Dynamics 365 is here!


Microsoft Dynamics CRM has been rebranded as Dynamics 365 as of November 1.

We have been battling for years the Microsoft CRM and ERP products did not talk to each other out of the box, requiring integrations like Scribe, EOne or KingswaySoft. Other competitors provided seamless tools that often noted this as a weakness.

Microsoft has responded with Dynamics 365 or a 360 degree of customer across CRM and ERP. And they didn’t stop with that. Now, the Common Data Model will be integrated across all products and be exposed to PowerApps, PowerBI and other products. An Appstore, along with the ability to provide Micro Apps will be a great way for developers to extend Dynamics 365 and get direct audience with the users needing these apps.

Why is this important to me as a developer? Lot’s of opportunity to not only extend Dynamics 365, but also to use XRM as your development platform and get access to all these great feature sets.

 


CRM Database Log Growth Issue


A customer of ours had come to us facing a rather interesting issue. Every night around 1am their CRM database log file would grow to 31GB and cause the log drive to fill up. When users would log into CRM in the morning, they would receive SQL errors stating that their transactions could not be completed.   Given that this issue occurred on a regular schedule, we determined that the issue had to be attributed to some sort of automated job.

Figuring the first place to check would be the out-of-the-box CRM Maintenance Jobs, we downloaded the Job Editor from Codeplex

(https://crmjobeditor.codeplex.com/ – Very useful tool that everyone should be using) and got to investigating.

Right off the bat, we saw our error on the Deletion Service:
Deletion Service encountered an internal error: System.Data.SqlClient.SqlException (0x80131904): Invalid object name ‘SubscriptionTrackingDeletedObject’

From here we moved to SQL and queried the SubscriptionTrackingDeletedObject table of our CRM database.

What we found was astounding – the table contained 137 MILLION records. Basically after seeing this we knew that the job had to just be timing out – we tested our theory by running the job manually and immediately saw the log file grow to the expected 31GB.

It was decided to clean this table up manually via truncating it. Before you say “Oh no! Don’t delete records via SQL directly!” let’s explain what this table actually is.

When records are deleted from CRM, there are also records that get inserted into this SubscriptionTrackingDeletedObject table. This table gives the Deletion Service Job ObjectIDs that have been removed so that further cleanup can be performed asynchronously. So essentially, it is just a table of deleted records which gives the Deletion Service knowledge to clean up some other areas of CRM (e.g. POA records, duplicate detection records, etc…) if necessary. Once cleaned up, the records from the table are removed. We understood this and decided the need to clean this table outweighed having the other areas of CRM cleaned up (as you will learn later, this wasn’t a concern for us because of how the records got in there).

Please note we cannot condone the practice of editing SQL manually without full knowledge of the possible repercussions. Always consult with Microsoft support if in doubt and remember what works in one scenario, may not work in all.

After the table was truncated, CRM was tested and the deletion service job was run manually – this time not failing with the error above and the log did not grow to 31GB. Before calling this case closed, we still needed to understand what caused this problem in the first place. What could have possibly created so many records in such a short period of time? Luckily, we had the right people involved on the customer’s end and were able to determine that there had been a malfunctioning Scribe job that was running for a while unnoticed. It was a job that was bulk creating and deleting 50,000 records at a time within CRM but the job had since been fixed. Case closed.


Join me at CRMUG Summit in Reno NV October 13-16


Join me at the CRMUG Summit In Reno NV. This is the premier Dynamics CRM Event of the year. Don’t miss out, not too late to register below.

renosummit

 

More details..

http://www.crmugsummit.com/home

Here’s my preliminary schedule. Please refer to the website!

Monday, October 12

8:00pm-10:00pm @ Peppermill – Terrace Lounge Chapter Leader Bash

Tuesday, October 13

2:00pm-4:30pm @ Atlantis: Paradise D & E Volunteer Immersion at CRMUG Summit
5:00pm-8:00pm @ Hall 2 Welcoming Expo Reception

Wednesday, October 14

7:00am-8:00am @ Hall 1 Breakfast – Jump Into a Great Day
9:15am-9:45am @ Ballroom Lobby Networking Break
9:45am-10:45am @ D2 Getting Ready to Pull the CRM Trigger
11:15am-12:25pm @ C4 CRMUG Opening General Session – Microsoft Keynote
1:30pm-2:30pm @ D4 The CRM Superhero’s Tips, Tricks, and Toolbox
1:30pm-2:30pm @ D2 Scouting & Preparing as CRM GameDay Draws Near
2:30pm-3:00pm @ Ballroom Lobby Networking Break
4:00pm-4:30pm @ Ballroom Lobby Networking Break
4:30pm-6:00pm @ D2 ADFS & Upgrading with a Mobile State of Mind
6:00pm-8:00pm @ Hall 2 Expo Reception

Tribridge Customer Party – Invitation Only 7pm on..

Please contact me if your a customer or prospect and did not receive an invitation.

Thursday, October 15

7:00am-8:00am @ Hall 1 Breakfast – Jump Into a Great Day
8:00am-9:00am @ D2 Getting that CRM Upgrade to Purr Like a Kitten
9:00am-9:30am @ Ballroom Lobby Networking Break
10:30am-11:00am @ Ballroom Lobby Networking Break
11:00am-12:00pm @ C4 CRMUG General Community Session
12:00pm-2:00pm @ Halls 1 & 2 Networking Lunch and Expo
2:00pm-3:00pm @ D7 Going OnPremise to CRM Online
2:00pm-3:00pm @ C1 Take It to the Next Level with End User Experience Upgrades in CRM 2015
3:00pm-3:15pm @ Ballroom Lobby Networking Break
3:15pm-4:15pm @ D4 Ask the MVPs: Admin-Foundation Edition
3:15pm-4:15pm @ D7 Ask the Experts – User Adoption Edition: Enterprise CRM Strategies and Pitfalls to Avoid
4:15pm-4:45pm @ Ballroom Lobby Networking Break
4:45pm-5:45pm @ D2 Dissecting Multifaceted CRM Upgrades

Friday, October 16 – CANCLLED

8:00am-9:15am @ D2 Deployment Method of Choice  CANCELLED

 

 


Join me and my CRM MVPs at The MVP Virtual Conference (MVP V-Conf)


VCon_Hero
The MVP Virtual Conference (MVP V-Conf) is a new, virtual, 2-day event that showcases how the best and brightest independent technology experts are using Microsoft technologies today. Tune in and see what the community of power users are saying about the mobile-first, cloud-first world of possibility with Microsoft re-imagined.
These sessions will be presented by Americas’ Region Microsoft Most Valuable Professionals (MVPs), who are exceptional community leaders who are passionate about sharing their real-world knowledge of Microsoft products with their IT Pro, developer and consumer communities around the world.
The theme of this first conference is “The Power of Community” where we will showcase how the community can help one another learn, thrive and grow, and demonstrate how Microsoft’s MVPs shape these technical communities. 
  
The MVP V-Conf Keynote address will be delivered by Steven Guggenheimer, Corporate Vice President of the Developer eXperience (DX) group at Microsoft Corp.
More details..

 

http://mvp.microsoft.com/en-us/virtualconference.aspx


Microsoft Announces Release of CRM 2015 Spring Wave


This is going to be a great release. Online only for now, provides updates to navigation giving a 3rd layer of breadcrumbs similar to Microsoft Dynamics Marketing. New email folder based routing, faster form loads just to name a few. Here’s all the details.. Enjoy!

http://www.microsoft.com/en-us/dynamics/crm-customer-center/get-ready-for-the-next-release.aspx

Note: We expect OnPremise and Private cloud users to get this release in Fall 2015 (December).


CRM 2015 has been released.


The Microsoft CRM team has been hard at work. They have just announced the availability of CRM 2015 for both CRM Online and CRM OnPremise. Don’t worry, this is not the same major upgrade from CRM 2011 to CRM 2013, but rather more like a CRM 2013 SP2/3 release.

As of I have stated before, CRM platform has hit a nice maturity level, in where the interface and back office are very stable, scalable, etc., a lot like ERP system updates. Now, we will see even more new features and innovation for CRM, built on the same common platform. Here’s some great links!

What’s new in CRM 2015:

http://www.microsoft.com/en-us/dynamics/crm-customer-center/what-s-new.aspx

 Mobile Tablet Productivity Enhancements

https://www.youtube.com/watch?v=AsCVyFqGsZA

 

CRM Customer Center:

http://www.microsoft.com/en-us/dynamics/crm-customer-center/default.aspx

 

CRM Online Upgrade Video

https://www.youtube.com/watch?v=7f3KTlFaQ64

 

Videos and EBooks:

http://www.microsoft.com/en-us/dynamics/crm-customer-center/videos-ebooks.aspx

 

Hierarchical Security Modeling in Microsoft Dynamics CRM 2015

https://www.youtube.com/watch?v=kx5So32DrCo

 

Mobile Tablet Productivity Enhancements

https://www.youtube.com/watch?v=AsCVyFqGsZA

 


Deploying and administering Microsoft Dynamics CRM Online and Microsoft Dynamics CRM 2015


This deployment and administration documentation, known as the Implementation Guide or IG in previous versions of Microsoft Dynamics CRM, is a set of comprehensive deployment and administration topics that can help you plan, deploy, configure, customize, and maintain Microsoft Dynamics CRM 2015 (on-premises) or Microsoft Dynamics CRM Online.

http://technet.microsoft.com/en-US/library/hh699811(v=crm.7).aspx