Microsoft Dynamics CRM Blog from the Community and Application Store of Microsoft CRM 2011

SQL Server error. SQL Server error accrued. try this action again. If the problem continues, check with the Microsoft CRM community

30 Nov 2011 07:17:59:000

Issue:

When trying to log in to the web client, all users are getting the same error message "SQL Server error. SQL Server error accrued. try this action again. If the problem continues, check with the Microsoft CRM community

Resolution:?

Go to Tools >> Internet option >> General Tab >> click Delete and Delete the browser history, Cache and Cookies.

? Trusted Sites

?? CRM requires the URLs to be present in the ?Trusted Sites? zone to be able to run scripts effectively. When adding the URLs to the trusted sites, please keep it simple. Do not clutter the zone settings tab with too many URLs ? just add the two below ?

?? https://*.live.com

?? https://*.crm.dynamics.com

?? This will ensure that all of the pages served by live.com as part of the logon process and the pages served by the CRM Online application are allowed to execute with the appropriate privileges.

? Open up Internet Explorer (IE)

? Go to Tools > Internet Options

? Click the Security tab

? Click Trusted Sites > Sites

? then add the following URLs:

?https://*.live.com

https://*.crm.dynamics.com

Additional information:

What's New for Microsoft Dynamics CRM 2011?(MSDN)

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

Customizing Microsoft Dynamics CRM Online for your organization

https://rc.crm.dynamics.com/rc/2011/en-us/online/5.0/aboutcustomizing.aspx

Microsoft Dynamics CRM Online Resource centre

http://rc.crm.dynamics.com/rc/regcont/en_us/ONLINEsales.aspx

Microsoft Dynamics CRM Online Video Gallery

http://www.democrmonline.com/

CRM for outlook client

??????????http://download.microsoft.com/download/E/9/8/E98FD319-2B61-49A7-8613-9B54EF270B0E/CRM2011-Client-ENU-amd64.exe :( 64 bit)

http://download.microsoft.com/download/E/9/8/E98FD319-2B61-49A7-8613-9B54EF270B0E/CRM2011-Client-ENU-i386.exe : ?(32 bit)

CRM 2011 Help Menu Unavailable when you configure IFD

29 Sep 2011 07:04:45:000

We recently ran into an issue where the CRM 2011 help menu would display the error Internet Explorer cannot display the page, once we configured IFD.

This is a known issue by Microsoft and they will be releasing a fix in an upcoming rollup.

The workaround below is what we used to resolve the issue:

Resolution:

* please perform the database backup and perform the steps below:

Use MSCRM_CONFIG

select helpserverurl from configsettings

Use MSCRM_CONFIG
Update configsettings
Set helpserverurl = ?

IISRESET

CRM 2011 Reports Issue - The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file

27 Sep 2011 08:50:26:000

Issue:

When i try to acces reports using CRM 2011 i got this error

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file, or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.webServer/handlers section for Internet Information Services 7 or later.

Resolution:

Open web.config file in notepad from this location

C:/Program Files/..../Web.config

You will find?<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" /> from httpHandlers section

Please remove?validate="false" from it and do iisreset, try access to access the reports now.

How to Orders to be Bulk Editable in CRM 4.0

23 Sep 2011 01:25:00:000

Export ?the ISV config file and edit the salesorder entity as per the below code:

<Entity name="salesorder" >? ? ? ? ??

? ? ? ? ? <Grid>

? ? ? ? ? ? <MenuBar>

? ? ? ? ? ? ? <Buttons>

? ? ? ? ? ? ? ? <Button Icon="/_imgs/ico_18_debug.gif" JavaScript="doAction('crmGrid', '1088', 'bulkedit');" Client="Web">

? ? ? ? ? ? ? ? ? <Titles>

? ? ? ? ? ? ? ? ? ? <Title LCID="1033" Text="Bulk Edit." />

? ? ? ? ? ? ? ? ? </Titles>

? ? ? ? ? ? ? ? ? <ToolTips>

? ? ? ? ? ? ? ? ? ? <ToolTip LCID="1033" Text="Bulk Edit." />

? ? ? ? ? ? ? ? ? </ToolTips>

? ? ? ? ? ? ? ? </Button>

? ? ? ? ? ? ? </Buttons>

? ? ? ? ? ? </MenuBar>

? ? ? ? ? </Grid>

? ? ? ? </Entity>

save the file and import the customization.

Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed

20 Sep 2011 06:28:53:000

Issue:

Error| Import Organization (Name=SMEAssociatesInc, Id=aca0517f-8987-e011-b85d-78e7d1ecbde6) failed with Exception:

Microsoft.Crm.CrmException: Upgrade Organization with Id=aca0517f-8987-e011-b85d-78e7d1ecbde6 failed with Exception:

System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmException: You have reached the maximum number of user quota

Solution:

This is because of the Workgroup license.

I have installed CRM 4.0 using Professional License it cannot support to upgrade the CRM with Workgroup?license.

Later i have installed CRM 2011 with workgroup edition and import the CRM 4.0 Organization, while upgrading i got this error.

I have 12 users in CRM and Workgroup supports only 5 users.

Then i went to Deployment Manger and changed the License to Server License and Import it again, it resolved the issue.

**Workgroup is 5 CAL Limit**

TMG: Publishing CRM Organization website

20 Sep 2011 06:03:22:000

This blogs provides you with brief?description?on?TMG - Publishing CRM Organization website::

In my scenario i have installed CRM on 443 and ADFS on 444 ports.

Forefront TMG --> Firewall Policy --> New --> Website Publishing Rule

Here i am creating a new web listener for CRM 2011.

As Dev.domain.com, auth.domain.com are on same port so i have added these piblic names in the same rule,

Now test the rule by click on Test Rule button,

I have created a new publishing rule and web listener for ADFS as it is installed on 444 port.?

Now apply the settings and try to access from Internet... :)

Upgrading CRM 4.0 to CRM 2011

16 Aug 2011 05:44:15:000

1.???????http://support.microsoft.com/kb/968520 ?(delete?asynchronous records from DataBase)

2.???????Complete the CRM installation

3.???????Install the update rollup 12 on the CRM server :?http://www.microsoft.com/downloads/details.aspx?FamilyID=a80147f8-130e-492d-93d3-e16e6b2e2fa1&displaylang=en

4.???????Please add the following registry keys on the CRM sever:

a. HKEY_Local_Machine\Software\Microsoft\MSCRM key

b. Right click on the blank space ,New???DWORD value

c. Enter the key named OptimizeOrgImport.

d. Modify the value of the key to ?1?

5.???????Add the following registry keys to increase the timeout values as specified in the KB article?http://support.microsoft.com/kb/918609[Method 1]

Ran the query below against the CRM 4.0 Org DB

select ObjectTypeCode, Name, BaseTableName, ExtensionTableName from EntityView where IsCustomizable = 1 and ( Name is null or BaseTableName is null or ExtensionTableName is null)

It returned the results

=============

ObjectTypeCode: 4700

Name: AsyncOperation

BaseTableName: AsyncOperationBase

ExtensionTableName: NULL

Resolution

1 . select ObjectTypeCode, Name, BaseTableName, ExtensionTableName, iscustomisable from EntityView where IsCustomizable = 1 and ( Name is null or BaseTableName is null or ExtensionTableName is null)

2 . This pointed to the row that has Objecttypecode = 4700 and IsCustomizable = 1.

3. Ran the query below

Update Entityview

Set IsCustomizable = 0

Where Objecttypecode = 4700 and IsCustomizable = 1

Then run the query below and send me the results.

select ObjectTypeCode, Name, BaseTableName, ExtensionTableName, iscustomizable from?Entityview

where Objecttypecode = 4700

Start upgrading CRM.

Changing the Default Organization in CRM 2011

16 Aug 2011 01:32:19:000

1.? ? ? 1. ?Go to SQL Server where CRM installed

**Kindly change the GUID's**

2.? ? ? ?2.?Use MSCRM_CONFIG

Select * from organization

You can find the list of organization in your CRM.

3.? ? ? 3. ?Find the User?s Systemuserid

You can also find the user GUID using this query:

Use <<Your Organization>>_MSCRM

Select systemuserid from systemuserbase where domainname = ?domain\user?

systemuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>

1.? ? ? ?4.?Find the User?s ID:

Use MSCRM_CONFIG

Select userid from systemuserorganizations where crmuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>

User ID <E0437EA7-9B8B-E011-9245-000C292CBBE1>

5.?Find the appropriate user in the systemuser table

Select * from systemuser where id = ?E0437EA7-9B8B-E011-9245-000C292CBBE1?

- Update the systemuser table to reflect the desired defaultorganizationid

2.? ? ? ?6.?Use MSCRM_CONFIG

Update SystemUser set DefaultOrganizationId = '6893E7A3-62B8-E011-AA60-000C292CBBE1?

Where id = 'E0437EA7-9B8B-E011-9245-000C292CBBE1'

DO IISRESET and access the CRM

Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed.Exception has been thrown by the target of an invocation.Data is Null. This method or property cannot be called on Null values.

18 Apr 2011 10:02:05:000

Migration?issues?from?CRM?4.0?to?CRM?2011.?It?fails?with?the?error?below:

Microsoft?Dynamics?CRM?Server?Setup?did?not?complete?successfully.?

Action?Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction?failed.
Exception?has?been?thrown?by?the?target?of?an?invocation.
Data?is?Null.?This?method?or?property?cannot?be?called?on?Null?values.

Solution :

select ObjectTypeCode, Name, BaseTableName, ExtensionTableName from EntityView where IsCustomizable = 1 and ( Name is null or BaseTableName is null or ExtensionTableName is null)

Please update IsCustomizable value to 0 by running the command below:

Update Entityview

Set IsCustomizable = 0

Where Objecttypecode = 4700 and IsCustomizable = 1

And then start upgrade.

Plugin Registration Console Application for Microsoft Dynamics CRM 2011

18 Apr 2011 06:40:33:000

Purpose

Plugin Registration Console Application Tool for Microsoft Dynamics CRM 2011.

You can now register your plugins and custom workflow activities from a command line, within Visual Studio from the post-build event or from a TFS Build post-build event.

Uses a source XML file.

Download Link :?http://pluginregcrm2011.codeplex.com/#

CRM 2011 ? Visual Studio Plugin Templates

15 Apr 2011 09:24:39:000

Purpose

To create a new plugin or custom workflow activity without having to remember each time how to code them from scratch.

How to Install

Simply copy the zip files (do not extract them ? just copy the archives directly) into the folder:

<My Documents>\Visual Studio 2010\Templates\ProjectTemplates\Visual C#\CRM 2011\

I called my new folder ?CRM 2011' ? you can call it what you wish. ?The name you choose will appear as a new category when you create a new Visual Studio project:

http://www.mediafire.com/?5ai40s51qjqv24o

http://www.mediafire.com/?ip9avvd5wnc87f0

Crm2011 custom advanced find with silverlight

15 Apr 2011 06:20:58:000

The CRM 2011 OData Query Designer is a Silverlight 4 application that is packaged as a Managed CRM 2011 Solution. This tool allows you to build OData queries by selecting filter criteria, select attributes and order by attributes. The tool also allows you to Execute the query and view the ATOM and JSON data returned.?

The look and feel of this component will improve and new functionality will be added in the near future so please provide feedback on your experience.

Latest Update 8th March 2011
1. Added dropdown list of available OptionSet values for a filter when of type OptionSet, Boolean, Status and State.
2. Attribute lists now show the UserLocalizedLabel Display Name instead of Schema Name.
3. Resolved issues with some attribute types not generating correctly when used in a filter.

http://crm2011odatatool.codeplex.com/releases/view/62066#DownloadId=213953

CRM 2011 Metadata Browser

15 Apr 2011 06:15:19:000

The CRM 2011 Metadata Browser is a Silverlight 4 application that is packaged as a Managed CRM 2011 Solution. This tool allows you to view metadata within CRM including Entities, Attributes and Relationships.

The look and feel of this component will improve and new functionality will be added in the near future so please provide feedback on your experience.

http://crm2011metabrowser.codeplex.com/releases/view/61231#DownloadId=209243

CRM 4 to CRM 2011 JavaScript Converter

15 Apr 2011 06:08:25:000

CRM 4 to CRM 2011 Javascript Converter helps convert scripts to the latest CRM 2011 Form scripting model. The converter uses an xml file that contains CRM4 and CRM5 nodes which allow the converter to find/replace specific instances of text. For further details please see the documentation area.

?
Usage

Simply paste your CRM 4 script into the left hand text area and click Convert.

http://crm2011scriptconvert.codeplex.com/

Orderby and Groupby in Retrieve Multiple

12 Apr 2011 05:41:27:000

var xml = "" +?
"<?xml version=\"1.0\" encoding=\"utf-8\"?>" +?
"<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +?
"? <soap:Header>" +?
"??? <CrmAuthenticationToken xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +?
"????? <AuthenticationType xmlns=\"http://schemas.microsoft.com/crm/2007/CoreTypes\">0</AuthenticationType>" +?
"????? <OrganizationName xmlns=\"http://schemas.microsoft.com/crm/2007/CoreTypes\">Procad</OrganizationName>" +?
"????? <CallerId xmlns=\"http://schemas.microsoft.com/crm/2007/CoreTypes\">00000000-0000-0000-0000-000000000000</CallerId>" +?
"??? </CrmAuthenticationToken>" +?
"? </soap:Header>" +?
"? <soap:Body>" +?
"??? <RetrieveMultiple xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +?
"????? <query xmlns:q1=\"http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryExpression\">" +?
"??????? <q1:EntityName>account</q1:EntityName>" +?
"??????? <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +?
"????????? <q1:Attributes>" +?
"??????????? <q1:Attribute>accountnumber</q1:Attribute>" +?
"??????????? <q1:Attribute>name</q1:Attribute>" +?
"????????? </q1:Attributes>" +?
"??????? </q1:ColumnSet>" +?
"??????? <q1:Distinct>true</q1:Distinct>" +?
"??????? <q1:PageInfo>" +?
"????????? <q1:PageNumber>1</q1:PageNumber>" +?
"????????? <q1:Count>250</q1:Count>" +?
"??????? </q1:PageInfo>" +?
"??????? <q1:Orders>" +?
"????????? <q1:Order>" +?
"??????????? <q1:AttributeName>name</q1:AttributeName>" +?
"??????????? <q1:OrderType>Ascending</q1:OrderType>" +?
"????????? </q1:Order>" +?
"????????? <q1:Order>" +?
"??????????? <q1:AttributeName>accountnumber</q1:AttributeName>" +?
"??????????? <q1:OrderType>Descending</q1:OrderType>" +?
"????????? </q1:Order>" +?
"??????? </q1:Orders>" +?
"????? </query>" +?
"??? </RetrieveMultiple>" +?
"? </soap:Body>" +?
"</soap:Envelope>" +?
"";
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);
var resultXml = xmlHttpRequest.responseXML;