Wednesday, February 22, 2012

Fetch XML Builder for CRM 2011.

Many of the MS Dynamic CRM 4.0 lovers used handy Fetch XML Builder to generate complex fetch XML quires to retrieve the data. So those developers  dreams for having a version of fetch XML builder, which supports for CRM 2011.

Why it doesn’t support for CRM 2011, if the CRM web service is still available in CRM 2011 for backward compatibility? Developers tend to think that it doesn’t support, when they get below run time error.

You get above runtime error since you are running Fetch XML builder probably in 64 bit CRM server or 64 bit CRM development machine. Fetch XML builder installation is shipped with 32 bit CRM 4.0 SDK dlls and not 64 bit dlls. So in order to fix above run time error, you just need to replace 32 bit SDK dlls in Fetch XML builder installation folder from 64 bit SDK dlls, which can be found at CRM 4.0 SDK.

Using fetch XML to write complex queries is still a good option since execution of complex query may be 100 times faster than complex CRM LINQ query, which returns same result and Fetch XML can still be executed using Organization Service introduced on CRM 2011. And also it supports outer join, where outer join in CRM LINQ query is not straight forward.

Would you like to try Fetch XML builder for CRM 2011? if yes here we go..
1.       Download Fetch XML builder from Fetch XML Builder and install it on your local machine or a server.
2.       If you need a key please drop me your email and I will send you a key.
3.       If your machine is 64 bit, Replace 32 bit CRM 4.0 SDK dlls,which can be found at Fetch XML builder installation folder, from 64 bit SDK dlls and you can download 64 bit CRM 4.0 SDK dlls from my share(64 bit SDK dlls)

Are you a Dynamic CRM Fetch XML Builder? I am..

--Thushara Manchanayake--

Tuesday, February 14, 2012

How CRM 2011 handles Max Length of text field.

When we increase Max Length of text field and click save at field customization area, it alter relevant column in CRM back end (SQL server) and we don’t even need to publish customization. But when we decreased Max Length of a field, it affects to CRM front end only and not in back end SQL server. So SQL Server holds the increased length as it was. It means that you can save text, which is not allowed enter in CRM front end, using SDK.

 --Thushara Manchanayake--

Monday, January 23, 2012

Discovery service URL is not for CRM online anymore

“An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.”

When you used to connect into CRM online to register plugin, you will get above error message and you may end up with no solution to fix this issue. There are many blogs and troubleshooting items in MSDN to fix this issue and none of them will help you now with latest CRM online environment. I couldn’t find any blog related to this new issue and found the solution myself. There are many blogs created in last year, which may mislead you now since they tell you to use  as discovery URL to connect into CRM online.

Actually those blogs are not valid any more. With latest MS CRM online, we must use URL, which is used to browse CRM using browser that is https://<OrganizationName>

--Thushara Manchanayake--