Monday, November 29, 2010

MSCRM System Jobs Continuously in Waiting State

If you ever come across the issue of your system jobs always being in a waiting state, you may want to verify some values in the MSCRM_CONFIG.dbo.DeploymentProperties table. To verify the data you will need to run the following query against SQL.

Select
NVarCharColumn
from DeploymentProperties
where ColumnName IN ('ADSdkRootDomain', 'ADWebApplicationRootDomain', 'AsyncSdkRootDomain');

This query should return three rows each containing data looking something like crmserver:5555.  Where crmserver is the name of the server where you have deployed CRM and 5555 is the port the CRM website is configured to use.  If the data returned is null or incorrect you can run the following query to update it

Update DeploymentProperties
Set NVarCharColumn = 'crmserver:5555'
Where ColumnName IN ('ADSdkRootDomain', 'ADWebApplicationRootDomain', 'AsyncSdkRootDomain')

Friday, November 5, 2010

CRM SQL Table Information

Came across a great article on the CustomerEffective blog today about getting information on CRM SQL table sizes.  The provided query will tell you the number of records in each table and the size of each table.  You can find the article at http://blog.customereffective.com/blog/2010/10/crm-sql-table-information.html