Whats new in CRM 2016

release-preview

Explore here to get this information

Upgrade MS CRM : MS CRM 2011 to MS CRM 2015

computer-upgrade

Few days back we upgraded (on premise) CRM 2011 to CRM 2015 (What’s new in MS CRM 2015), trying to summarize that upgrade. I am going to mention only the things I tried only, you may find some other alternatives for same as well. J

Continue reading “Upgrade MS CRM : MS CRM 2011 to MS CRM 2015”

Increase organization import time

Some times your MS CRM organization may take much more time than usual, but due to that your organization import get failed. In this you needs to increase your CRM import time, here are the step for it.

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
  3. Right-click MSCRM, point to New, and then click DWORD Value to create a new DWORD value.
  4. Rename the DWORD value to the following value: OLEDBTimeout
  5. Right-click the DWORD value, and then click Modify.
  6. In the Edit DWORD Value dialog box, type 86400 in the Value data box, click Decimal in the Base option, and then click OK.
  7. That’s it

Note: According to the requirement of the computer that is running SQL server and the number of customization files, the value can be larger than 86400. The value of 86400 is equivalent to 24 hours.

Plugin registration 2015 issues

During working with plugin registration 2015 I faced some issues. Here are those with resolution

Tool throws an error that ” Assembly file name (WorkspaceCRMPlugins.dll) is in invalid format. Only file name is allowed.” during creating a new step.

Resolution for this is, go to DB and look for ‘PluginAssemblyBase’, in this table just update ‘path’ column with only actual assembly / DLL name. It will work like charm Or simply work with 2011 registration tool, it wont throw any error.

You can not see ‘Register Plugin’ button if you have bit smaller screen, for this I don’t found any proper solution but there is workaround is click on log text area and hit tab button, then hit enter. Or Simply use 2011 Reg. tool

Assembly can not be loaded.

I need to provide full rights to ‘Network Service’ as well with ‘Everyone’

Thabiso Motloung - Microsoft Dynamics CRM

Issue:

When trying to register a custom workflow on disk I would get the below error message.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Assembly can not be loaded.

Detail: <OrganizationServiceFault xmlns=”http://schemas.microsoft.com/xrm/2011/Contracts” xmlns:i=”http://www.w3.org/2001/XMLSchema-instance”>

<ErrorCode>-2147200995</ErrorCode>

<ErrorDetails xmlns:a=”http://schemas.datacontract.org/2004/07/System.Collections.Generic” />

<Message>Assembly can not be loaded.</Message>

<Timestamp>2015-02-12T09:25:34.9332313Z</Timestamp>

<InnerFault>

<ErrorCode>-2147200995</ErrorCode>

<ErrorDetails xmlns:a=”http://schemas.datacontract.org/2004/07/System.Collections.Generic” />

<Message>Assembly can not be loaded.</Message>

<Timestamp>2015-02-12T09:25:34.9332313Z</Timestamp>

<InnerFault i:nil=”true” />

<TraceText i:nil=”true” />

</InnerFault>

<TraceText i:nil=”true” />

</OrganizationServiceFault>

Server stack trace:

at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

Resolution:

What finally worked for was to give everyone permission to the the dll.

GrantPermission

View original post

Rebuild all indexes on all tables in the SQL Server database

Awesome post..

Basit's SQL Server Tips

One of the key tasks of a DBA is to maintain the database indexes and make sure they are not fragmented. You can use a sys.dm_db_index_physical_stats in a script to rebuild or reorganize indexes based on fragmentation. However, sometimes we may need to rebuild all indexes on all tables in the database, especially if you have to change any index property such as fill factor, compression, etc.

For this task, I wrote a following script that accepts parameters to change the properties of the indexes, and dynamically generate and execute ALTER INDEX statements. This script is compatible with SQL Server 2005 and above versions.

Here is this script:

View original post

Database list not found during MS CRM organisation import

Error: “Import organization wizard cannot connect to the SQL Server or cannot find an organization on “DB instance” MS CRM 2011 / 2013 / 2015 Deployment Manager” or “SQL Server is not connected please make sure that sql server service is running” or similar.

But strange thing is SQL server is running fine with some database.

Resolution: An organization with the same name ‘_MSCRM’ ending is not allowed. You can keep at max one database with ‘_MSCRM’ ending.

That’s it.

Enfource MS Dynamics CRM Deployment manager to keep same GUID during import

Many time we need to import organization in current MS CRM server from some other MS CRM server. When we import any organization, a new GUID for that organization will be created, but what if I want to keep same GUID in new environment … is it even possible?

Yes, it is. Here are steps for that…

  1. Click Start, click Run, type ‘regedit’, and then click OK.
  2. Locate and then click the following registry sub key: — HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
  3. Right-click MSCRM, point to New, and then click DWORD Value.
  4. Name this DWORD value as ‘OptimizeOrgImport’
  5. Right-click ‘OptimizeOrgImport’, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. On the File menu, click Exit
  8. Restart the CRM web server before getting started with the Import process.
  9. That’s it.

Once this done every organization will have same GUID which is in older environment and important is, it wont allow to import same organization. To import same organization in same environment after implementing above registry entry either you have to delete the organization and reimport it with newer database or change ‘OptimizeOrgImport = 0’