Move SharePoint 2010/2013 Content DB to Another Drive on the Same SQL Server

When administering a SharePoint farm, you’re bound to have a situation come up where you’re low on diskspace for a site with increasing content. You may want to move a content database to another drive on your SQL server in order to gain some free space back. Fortunately, this isn’t too hard to accomplish using the following steps and should work in SharePoint 2010 or 2013:

1. Quiesce the Farm – This stops people from being able to make changes to your system while you are working on it. To quiesce SharePoint 2010, use stsadm: stsadm -o quiescefarm -maxduration n

2. Backup any database that you are moving

3. Turn off SharePoint Services to unlock the databases You can either stop the services through the Central Administration or you can do it in the Services Console. To stop the connections to the existing databases, stop the following services: Office SharePoint Search Service Windows SharePoint Services Administration Windows SharePoint Services Search Windows SharePoint Services Timer Windows SharePoint Services Tracing World Wide Web Publishing Service

4. After the services are stopped, detach the database(s) that you are looking to move.

5. After detaching the database(s), copy them to your new location.

6. Reattach your database(s)

7. Restart the services

8. Unquiesce the farm: To unquiesce SharePoint 2010, use stsadm: stsadm -o unquiescefarm

* Some of this content is sourced from Microsoft Technet

CRM 2015: ‘Query execution time of 10.6 seconds exceeded the threshold of 10 seconds’ in logs

As a CRM administrator, you may come across the following error in your CRM Event Logs: “Query execution time of XX seconds exceeded the threshold of 10 seconds”

This is said to merely be informational. If you’d like to see the setting in your CRM’s SQL database, run the following script against your CRM’s database:

SELECT IntColumn FROM MSCRM_CONFIG..ServerSettingsProperties WHERE ColumnName=’LongQueryThresholdInSeconds’

It should return the value you had seen in the warning. To lengthen the timeout to stop the error, you can run the following script against your database:

UPDATE MSCRM_CONFIG..ServerSettingsProperties SET IntColumn = ’20’ WHERE ColumnName=’LongQueryThresholdInSeconds’

This will double the timeout threshold to 20 seconds.

Dynamics CRM 2015 – Adding All Opportunity Notes Attachments to Workflow Emails

We had a need to send custom workflow emails that included all attachments from the Notes section of Opportunities in Dynamics CRM 2015. This is not an out of the box functionality. It requires the development of a plugin that must be registered in CRM to achieve the desired results. I’ll try to be thorough in my explanation, because I know it can be tough to put together the bits of information that you will find on this topic if you’re just starting out developing for CRM.  Continue reading “Dynamics CRM 2015 – Adding All Opportunity Notes Attachments to Workflow Emails”

Changing the URL and DNS of Microsoft CRM 2015

One of the scenarios that I ran in to with configuring Microsoft CRM 2015 is changing then DNS and URL of the site. When I installed and configured it, I didn’t have a final idea planned for a URL. Development started to figure out if I could jump versions from Dynamics 4 all the way to CRM 2105 by rebuilding the needed fields and workflows, export the data from the old system and import desired data back in to the new system. I found that the process worked well for skipping the other versions, but I was further along than I wanted to be to restart. If I could change the information, I could save hours of reproduction. There wasn’t a lot of 2015 information available on this topic, but the process was possible in versions 2011/2013. Using that information ended up working well. You can see an example here

Step 1:
– Update the DNS entry that points to the server IP address. This may need to be done by your Infrastructure team.

Step 2:
– Update your IIS bindings for the site to utilize the new URL

  • Open IIS Manager and select the existing Microsoft Dynamics CRM site
  • Click the Bindings link in the Action Panel on the right
  • Select the binding to modify and click on Edit
  • Modify the host name and port to reflect the new values
  • Close the IIS Manager

Step 3:
– Update the ServerURL registry entry with the new URL you want to use.

  • Open Regedit and browse the folders to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
  • Update the ServerURL value to your newly desired URL
  • Close the registry editor.

Step 4:
– Modify the settings for CRM from within the Microsoft Dynamics CRM Deployment Manager

  • Open Microsoft Dynamics CRM Deployment Manager
  • Right click on Microsoft Dynamics CRM at the top of the left pane and click Properties
  • Select the Web Address tab and modify the addresses shown to reflect your new URL
  • If you’re configuring for SSL, be sure to select HTTPS. Be sure that your certificate was selected and HTTPS is configured in Step 2.
  • Click OK to close the window and then close out of Deployment Manager.

Step 5:
– Restart the Microsoft Dynamics CRM Asynchronous Processing Service (or just restart the server). I had to restart the server, because I was generating a Generic Error on the homepage.

Step 6:
– You may require additional registry changes if they don’t exist. You may want to disable loopback on the server.

    • Open Regedit and browse the folders to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
    • Right-click Lsa, click on New, and then click DWORD Value.
    • Type DisableLoopbackCheck, and then press ENTER. Right-click DisableLoopbackCheck, and then click Modify. In the Value data box, type 1, and then click OK.
    • Close the registry editor and restart the server.

These steps should get CRM 2015 working on the new URL, using the new DNS name. If you run in to issues, try searching on the same issue in 2011/2013 versions and you can find more details on the steps required. A good many of the server solutions for 2011/2013 versions are also appropriate for 2015.

SharePoint 2010 Errors Saving a Page

Recently, I ran in to an issue where SharePoint would error out when trying to save a page edit. Even if you just went to edit mode and clicked to save and close, it would error out and provide a correlation ID without having made a change.

Using ULS Viewer, I took a look at the correlation ID to find that the error was, “The SPListItem provided is not compatible with a Publishing Page.”

This was a new error to me, so I started looking for more information. Googling it, I found several references and explanations on what needed to be done, but not many sources really explained the process of fixing it clearly.

To fix this issue, you need to disable and re-enable the Publishing service for SharePoint, using Powershell.

Open Powershell on the SharePoint server as an administrator. Type the following commands:
Disable-SPFeature –Identity Publishing –url http://Site_Name_Here

Wait for the process to complete successfully, then re-enable it:
Enable-SPFeature –Identity Publishing –url http://Site_Name_Here

Assuming the process completes successfully, you should be able to edit and check-in the page again without any problems. It is unclear to me what causes this issue, but at least it’s an easy fix.