MSCRM 2015 – Could not find file ‘C:\Program Files\Microsoft Dynamics CRM\LangPacks\xxxx\sql\7\StoredProcedures\MSCRM\fn_RollupByAccount.sql

MSCRM 2015 is just release in the previous last week. Maybe you come to the problem regarding the following error message:

System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.IO.FileNotFoundException: Could not find file ‘C:\Program Files\Microsoft Dynamics CRM\LangPacks\xxxx\sql\7\StoredProcedures\MSCRM\fn_RollupByAccount.sql

xxxx represents the MSCRM language code as 1031 for German. Here come the solution to proceed the organization upgrade from 2013 to 2015:

The following 3 files are missing for the upgrade to be completed:

fn_RollupByAccount.sql

fn_RollupByContact.sql

fn_RollupByOpportunity.sql

The 3 files are actually allready in the filestructure, they are just named in a wrong way.

p_RollupByAccount.sql

p_RollupByContact.sql

p_RollupByOpportunity.sql

Please copy those 3 files and rename them. After all the upgrade will proceed as expected. Please note, this is an unsupported workaround. We hope of course, that Microsoft will deliver an appropiated fix for this issue.

This blog is based on http://tipsntricksfordyncrm.blogspot.ch/ .  Thanks for sharing the solution.

Dynamics CRM 2015 – All resources together on one view

Please see the following list with all relevant download resources regarding the new release of Microsoft Dynamics CRM 2015:

Server 2015 – http://www.microsoft.com/en-us/download/details.aspx?id=45012

CRM 2015 SDK – http://www.microsoft.com/en-us/download/details.aspx?id=44567

Email Router – http://www.microsoft.com/en-us/download/details.aspx?id=45017

SharePoint List Part for CRM 2015 – http://www.microsoft.com/en-us/download/details.aspx?id=45018

Microsoft Dynamics CRM 2015 Report Authoring Extension – http://www.microsoft.com/en-us/download/details.aspx?id=45013

CRM 2015 Language packs – http://www.microsoft.com/en-us/download/details.aspx?id=45014

Outlook Client – http://www.microsoft.com/en-us/download/details.aspx?id=45015

CRM 2015 is now available for downlaod

Yes, CRM 2015 is now available for downlaod. See download under http://www.microsoft.com/en-us/download/details.aspx?id=45012. This is a big surprise because normally, the online environment comes out before the on premise one. Outlook (http://www.microsoft.com/en-us/download/details.aspx?id=45015), SharePoint List component and Email router is available as well. What’s currently not available are the released Version of Dynamics CRM 2015 SDK, only a pre-released Version.

Integration that Outperforms: SharePoint Integration for Logistics and SCM

See the statement of Magici software to integrate Microsoft SharePoint to the most imported LOB application within the whole organization:

Enterprises that use SharePoint as a content and portal platform often find a need to integrate it with their logistics and supply chain management systems (SCM). Learn how-to overcome integration challenges, automate business processes across diverse systems and benefit from highly scalable integration architecture.

See more in YouTube:

Use a specific system view on search field to filter user results

We have covered into the problem, that CRM 2013 is not using the correct system view to filter appropriate results behind a search field. After investing with Microsoft support, we have identified the following solution:

Create a new WebResource with the following code, and register it to the form’s OnLoad event. (Or, add it to an existing WebResource/OnLoad handler.)
function OnLoad() {      Xrm.Page.ui.controls.get(<the lookup field name>).setDefaultView(“{<your view’s ID>}”); }
You can determine the view’s ID by opening the customization window to edit the view, and finding the ‘id’ parameter in the URL. For example, the ID is highlighted below:
https://orgname.crm.dynamics.com/tools/vieweditor/viewManager.aspx?appSolutionId=%7bFD140AAF-4DF4-11DD-BD17-0019B9312238%7d&entityId=%7b608861BC-50A4-4C5F-A02C-21FE1943E2CF%7d&id=%7b00000000-0000-0000-00AA-000010001033%7d
To set the Contact field on an Opportunity to use the “Inactive Contacts” view, the handler would look like this:
function OnLoad() {      Xrm.Page.ui.controls.get(‘parentcontactid’).setDefaultView(“{00000000-0000-0000-00AA-000010001033}”); }

Of course this solution is “as-is” without any warranties, and confers no rights.

Microsoft Dynamics CRM 2013 Online Prices for Switzerland

Since November 2014, new Dynamics CRM 2013 is available for Swiss customers. In my point of view, there is never a overview regarding the services and related prices for Switzerland. After spending some time, I found everything and I would like to share the details:

Microsoft Dynamics CRM Online Professional

The most comprehensive plan for users who need full sales, service, and marketing capabilities of Microsoft Dynamics CRM Online.

CHF 64.10 (by user / month)

Microsoft Dynamics CRM Online Basic

Subscription plan for users who need access to accounts, contacts, leads, cases, reporting, and custom relationship management (xRM) capabilities of Microsoft.

CHF 29.60 (by user / month)

Microsoft Dynamics CRM Online Essential

Subscription plan for users who need access to custom relationship management (xRM) capabilities of Microsoft Dynamics CRM Online.

CHF 14.60 (by user / month)

Enhanced Support for Microsoft Dynamics CRM Online

Microsoft Dynamics CRM Online Enhanced Support Plan includes a fastest response time of <2 hours and eLearning.  Customers must choose either Professional Direct or Enhanced for the same number of seats in which they have licensed.

CHF 4.90 (by user / month)

In addition, there are the following addons:

Microsoft Dynamics CRM Online Additional Storage

CHF 9.90 (by Gb / Month)

Microsoft Dynamics CRM Online Additional Production Instance

CHF 541.70 (by organization instance / month)

Microsoft Dynamics CRM Online Additional Non-Production Instance

CHF 148.00 (by organization instance)

Dynamics CRM 2013 On Premise to Online Migration

Explanation of the Issue

We have done our first migration from a Dynamics CRM 2013 On Premise to Online environment. First, we have mentioned the error “0x80040203- Entity campaignresponse : Quick create is not supported for OOB Activity Entity”.

After investigation into the problem, we have found out, that the entity option “Allow quick create” is enabled in the On Premise environment. This option was not activated in the Online environment and that is the correct setting because Activity entities never have this options enabled.

See the following two print screen from the On Premise and the Online environment:

On Premise

Online

Solution

To solve that problem, we have modified the file “Customizaiton.xml” within the exported solution. In the entity definition “Campaigneresponse”, we have changed the metainformation-tag “IsQuickCreateEnabled” from value “1” to value “0”. This solution is finally not supported from Microsoft and should be used as temporary workaround.

Microsoft Dynamics CRM 2013 offers a wide range of security modeling features

Microsoft Dynamics CRM 2013 offers a wide range of security modeling features and it is important to chose the most approciated one in business. Security is balance between controll and application usability so that the user can “drive” his / her work forward. Security is also a question of compliance and what / how you will let the users do in the application.

For an overview, please see the just published guide from Microsoft to the the most appreciated features in Dynamics CRM 2013:

http://www.microsoft.com/en-us/download/details.aspx?id=40861

Microsoft Dynamics CRM Server 2013 installed configuration components

The following post describe the installation of the Dynamics CRM 2013 Server. Specially it gives you an overview what will be created and what is necessary.

When you install Microsoft Dynamics CRM Server 2013, Setup creates the default folders listed in the following table.

Folder	Content
SystemDrive:\Program Files\Microsoft Dynamics CRM\	Microsoft Dynamics CRM Server 2013 program files
SystemDrive:\Program Files\Microsoft Dynamics CRM\LangPacks\<LanguageID>\Reports\MSCRM	Contains a Microsoft Dynamics CRM subfolder that contains an .rdl file for each default report
SystemDrive:\Program Files\Microsoft Dynamics CRM\LangPacks	Location of Language Pack installations. Language Packs are downloaded and installed separately
SystemDrive:\Program Files\Microsoft Dynamics CRM\Trace	Stores trace file logs when tracing is enabled
SystemDrive:\Program Files\Microsoft Dynamics CRM\CustomizationImport	Location used to process data imports
SystemDrive:\Program Files\Microsoft Dynamics CRM\Unzip	Location used for unpackaging solutions
SystemDrive:\Program Files\Microsoft Dynamics CRM\CRMWeb	Microsoft Dynamics CRM website and Web services
SystemDrive:\Program Files\Microsoft Dynamics CRM\CRMWeb\CRMReports	Microsoft Dynamics CRM report services

 

The following web components are added:

Component	Name	Description
Application Pool	CRMAppPool	Microsoft Dynamics CRM Server Setup creates a separate application pool for the Microsoft Dynamics CRM application.
Application Pool	CRMDeploymentServiceAppPool	Microsoft Dynamics CRM Server Setup creates a separate application pool for the Deployment Web Service.
Site	Microsoft Dynamics CRM	Website for Microsoft Dynamics CRM.
Applications	XRMDeployment	Facilitates the implementation of xRM deployments.
Applications	Help	Services the Microsoft Dynamics CRM Help system for the application.

 

The following Active Directory groups are added. When the Active Directory domain is set to Native Mode, this group must be of the type Domain Local Security or Universal Security.

Group	Description
PrivReportingGroup	Privileged Microsoft Dynamics CRM user group for reporting functions. This group is created during Microsoft Dynamics CRM Server Setup and configured during Microsoft Dynamics CRM Reporting Extensions Setup.
PrivUserGroup	Privileged Microsoft Dynamics CRM user group for special administrative functions; including CRMAppPool identity (domain user or Network Service). The users who configure Microsoft Dynamics CRM Server 2013 must be added to this group.
SQLAccessGroup	All server processes/service accounts that require access to SQL Server; including CRMAppPool identity (domain user or Network Service). Members of this group have db_owner permission on the Microsoft Dynamics CRM databases.
ReportingGroup	All Microsoft Dynamics CRM users are included in this group. This group is updated automatically as users are added and removed from Microsoft Dynamics CRM. By default, all Microsoft Dynamics CRM Reporting Services reports grant Browse permission to this group.

 

The following services are added:

Service	Description	Possible Service User Name (depending on your user naming convention)
Microsoft Dynamics CRM Asynchronous Processing Service	Services asynchronous processes such as bulk email and workflow.	DOMAIN\crm.asynchron
Microsoft Dynamics CRM Asynchronous Processing Service (maintenance)	Services asynchronous maintenance such as encryption key generation for authentication and database deletion clean up.	DOMAIN\crm.application
Microsoft Dynamics CRM Unzip Service	Handles the uncompressing of zipped files for data import. This service is installed as part of the Web Application Server role.	DOMAIN\crm.web
Microsoft Dynamics CRM Sandbox Processing Service	The Sandbox Processing Service server role enables an isolated environment to allow for the execution of custom code, such as plug-ins.	DOMAIN\crm.sandbox
Microsoft Dynamics CRM Monitoring Service	Monitors all Microsoft Dynamics CRM Server 2013 server roles that are installed on the local computer.	DOMAIN\crm.monitoring
Microsoft Dynamics CRM VSS Writer	Provides an interface to backup and restore Dynamics CRM data by using the Windows Server Volume Shadow Copy Service (VSS) infrastructure.	DOMAIN\crm.vss

 

Microsoft Dynamics CRM Server Setup

The user account used to run Microsoft Dynamics CRM Server Setup that includes the creation of databases requires the following minimum permissions:

• Be a member of the Active Directory Domain Users group. By default, Active Directory Users and Computers adds new users to the Domain Users group.
• Be a member of the Administrators group on the local computer where Setup is running.
• Have Local Program Files folder read and write permission.
• Be a member of the Administrators group on the local computer where the instance of SQL Server is located that will be used to store the Microsoft Dynamics CRM databases.
• Have sysadmin membership on the instance of SQL Server that will be used to store the Microsoft Dynamics CRM databases.
• Have organization and security group creation permission in Active Directory service (ADDS).
• If Microsoft SQL Server Reporting Services is installed on a different server, you must add the Content Manager role at the root level for the installing user account. You must also add the System Administrator role at the site-wide level for the installing user account.

Services and CRMAppPool IIS Application Pool Identity Permissions

The user account that is used for the Microsoft Dynamics CRM services and IIS application pools must meet the following criteria:

• Microsoft Dynamics CRM services and application pool identity accounts must not be configured as a Microsoft Dynamics CRM user. Doing so can cause authentication issues and unexpected behavior in the application for all Microsoft Dynamics CRM users.
• Managed service accounts, introduced in Windows Server 2008 R2, are not supported for running Microsoft Dynamics CRM services.

Microsoft Dynamics CRM Sandbox Processing Service

Sandbox Processing Service server role enables an isolated environment to allow for the execution of custom code, such as plug-ins.

• Domain User membership.
• That account must be granted the Logon as service permission in the Local Security Policy.
• Folder read and write permission on the \Trace, by default located under \Program Files\Microsoft Dynamics CRM\Trace, and user account %AppData% folders on the local computer.
• Read permission to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM subkey in the Windows Registry.
• The service account may need an SPN (server principal name) for the URL used to access the Web site that is associated with it. To set the SPN for the Sandbox Processing Service account, run the following command at a command prompt on the computer where the service is running.
• SETSPN –a MSCRMSandboxService/<ComputerName> <service account>

Services and CRMAppPool IIS Application Pool Identity Permissions

The user account that is used for the Microsoft Dynamics CRM services and IIS application pools must meet the following criteria:

• Microsoft Dynamics CRM services and application pool identity accounts must not be configured as a Microsoft Dynamics CRM user. Doing so can cause authentication issues and unexpected behavior in the application for all Microsoft Dynamics CRM users.
• Managed service accounts, introduced in Windows Server 2008 R2, are not supported for running Microsoft Dynamics CRM services.

Microsoft Dynamics CRM Sandbox Processing Service

• Domain User membership.
• That account must be granted the Logon as service permission in the Local Security Policy.
• Folder read and write permission on the \Trace, by default located under \Program Files\Microsoft Dynamics CRM\Trace, and user account %AppData% folders on the local computer.
• Read permission to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM subkey in the Windows Registry.
• The service account may need an SPN for the URL used to access the Web site that is associated with it. To set the SPN for the Sandbox Processing Service account, run the following command at a command prompt on the computer where the service is running.
• SETSPN –a MSCRMSandboxService/<ComputerName> <service account>

Microsoft Dynamics CRM Asynchronous Processing Service

• Domain User membership.
• Performance Log Users membership.
• That account must be granted the Logon as service permission in the Local Security Policy.
• Folder read and write permission on the Trace folder, by default located under \Program Files\Microsoft Dynamics CRM\, and user account %AppData% folder on the local computer.
• Read and write permission to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM and HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\MSCRMSandboxService subkeys in the Windows Registry.
• The service account may need an SPN for the URL used to access the Web site that is associated with it.

Deployment Web Service (CRMDeploymentServiceAppPool Application Pool identity)

• Domain User membership
• That account must be granted the Logon as service permission in the Local Security Policy.
• Local administrator group membership on the computer where the Deployment Web Service is running.
• Local administrator group membership on the computer where SQL Server is running.
• Sysadmin permission on the instance of SQL Server to be used for the configuration and organization databases.
• Folder read and write permission on the Trace and CRMWeb folders, by default located under \Program Files\Microsoft Dynamics CRM\, and user account %AppData% folder on the local computer.
• Read and write permission to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM and HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\MSCRMSandboxService subkeys in the Windows Registry.
• CRM_WPG group membership.  This group is used for IIS worker processes. The group is created and the membership is added during Microsoft Dynamics CRM Server Setup.
• The service account may need an SPN for the URL used to access the Web site that is associated with it.

Application Service (CRMAppPool IIS Application Pool identity)

• Member of the Active Directory Domain Users group.
• Member of the Active Directory Performance Log Users group.
• Administrators local group membership on the computer where SQL Server is running.
• Administrators local group membership on the computer where the Microsoft Dynamics CRM Web site is installed.
• Folder read and write permission on the Trace and CRMWeb folders, by default located under \Program Files\Microsoft Dynamics CRM\, and user account %AppData% folder on the local computer.
• Read and write permission to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM and HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\MSCRMaSandboxService subkeys in the Windows Registry.
• CRM_WPG group membership. This group is used for IIS worker processes. The group is created and the membership is added during Microsoft Dynamics CRM Server Setup.
• The service account may need an SPN for the URL used to access the Web site that is associated with it.

 

As a summary, for each service, it is recommend to select a low-privilege domain user account that is dedicated to running these services and is not used for any other purpose. Additionally, the user account that is used to run a Microsoft Dynamics CRM service cannot be a Microsoft Dynamics CRM user. The domain account must be a member of the Domain Users group. Additionally, if the Asynchronous Service and Sandbox Processing Service roles are installed, such as in a Full Server or a Back End Server installation, the domain account (Application- Asynchron- and Sandbox user) must be a member of the Performance Log Users security group.

If you select to run the ASP.NET service under a domain user account that is not a domain administrator or a local administrator, you must set a local security policy after you install Microsoft Dynamics CRM Server 2013 for the ASP.NET service to work correctly. Also, depending on the password policies that you have implemented for your organization, the password for the user may expire.

The following SQL Server components are added:

Component	Name	Description
Databases	MSCRM_CONFIG OrganizationName_MSCRM	Microsoft SQL Server Setup creates the SystemDrive:\Program Files\Microsoft SQL Server\MSSQL<ver>\MSSQL\Data\ folder and Microsoft Dynamics CRM Server Setup installs the Microsoft Dynamics CRM configuration database and organization databases in it.
SQL Server Jobs	MSCRM_CONFIG.SiteWideCleanup	Microsoft Dynamics CRM Server Setup creates one SQL Server job that is used for maintenance.
Logins	PrivReportingGroup ReportingGroup SQLAccessGroup MSCRMSqlLogin	Microsoft Dynamics CRM Server Setup creates SQL Server logins for the PrivReportingGroup, ReportingGroup, and SQLAccessGroup Active Directory groups that are created. MSCRMSqlLogin is used for time zone conversions when you use dashboards and charts, and do queries using Advanced Find. When Microsoft SQL Server is enabled to use common language runtime (CLR), this can significantly improve performance for those features. Note By default, CLR is not enabled in Microsoft SQL Server. For more information about how to enable CLR, see Enabling CLR Integration.

Microsoft Dynamics CRM 2013 is now available!

Beginning from this week of 7^th of October 2013, Microsoft have introduced Microsoft Dynamics CRM 2013 into the market. For original communication from Bob Stutz, please see his blog on https://community.dynamics.com/crm/b/crmconnection/archive/2013/10/09/microsoft-dynamics-crm-online-fall-13-now-available.aspx . So do you get faster up to speed, please following URLs for your information:

https://mbs.microsoft.com/partnersource/solutions/CRM/CRMLaunchPage.htm (need Microsoft partner credentials)

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

http://msdn.microsoft.com/en-us/library/dn281891.aspx

http://msdn.microsoft.com/en-us/dynamics/crm/jj937218

http://www.microsoft.com/en-us/download/details.aspx?id=40321

http://technet.microsoft.com/en-us/library/jj992623.aspx

I am very exiting about the new release and looking forward to work more in detail. Feel free to share more of your expression, questions and remarks here in my blog.

Happy xRM