Sunday, October 10, 2010

Error When Publishing Workflows in Dynamics CRM 4.0 (an error occurred when the workflow was being created. try to save the workflow again).

A couple of days ago I received the above error when trying to publish a workflow in CRM. After some searching I found out that this error may occur after installing Update Rollup2 Update Rollup2 For Microsoft Dynamics CRM 4.0  .
What actually happened is the the following line has been removed from web.config for CRM Web Application.

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System.Globalization" TypeName="CultureInfo" Authorized="True"/> 

So what you need to do is adding the above line under <authorizedType> Node in web.config  and execute IISReset /Noforce .

That’s it.

Thursday, October 7, 2010

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId.)

 

Yesterday I was trying to install Dynamics AX 2009 . Suddenly I received the following error when I started the Synchronize Database Step in Initialization Checklist :-

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId 1

Then I started to think why this error occurred. Maybe because I changed some of the properties in the Modify Data Types Step . So I returned back to Modify Data Types Step and changed back everything to their Default Values but unfortunately everything is the same . I tried to Synchronize again and the error occurred.

So I finished all the Steps in Initialization Checklist and started to investigate.

I opened AOT > Data Dictionaries > Views > Dirpartyview > Fields .

And then I saw the StringSize Property of both the fields ( AccountNum, PartyId ). and Woooh they are not the same. so that’s why they are not compatible.

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId 2

 

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId 3

 

If you noticed both fields Data Source Property is the CustTable . so what you need to do is going to CustTable and right click on PartyId field and choose Add-Ins > Open new window > Open used Extended Data Type

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId 4

 

Then you will notice StringSize Property of DirPartyid changed it to be the same as AccountNum StringSize Property.

Error While Synchronizing Database In Dynamics AX 2009 (There is a field mismatch in the union query. Field AccountNum is not compatible with field PartyId 5

 

That’s it Smile . Save your changes and Synchronize the Database Again.

Maybe you will have warnings that few tables will be dropped and recreated but it is okay as long as you don’t have any data yet.

 

Conclusion:-

I didn’t know what is exactly the reason for this error. Maybe it is bug or maybe something wrong I did in the Initialization but there’s a solution for it Smile.

Sunday, October 3, 2010

Microsoft Dynamics CRM 4.0 Build Numbers ( Rollups)

 

I've seen many times people asking what is my CRM current version ? Which Rollup i should apply ? . Below is a table that will show you each CRM build number and the Rollup Versions:-

Microsoft Dynamics CRM 4.0 Build Numbers

Version Build Number Release Date KB Article
RTM 4.0.7333.3 12/19/2007 ###
Rollup 1 4.0.7333.1113 11/24/2008 952858
Rollup 2 4.0.7333.1312 or
4.0.7333.1316
1/15/2009,
2/8/2009
959419
Rollup 3 4.0.7333.1408 3/12/2009 961768
Rollup 4 4.0.7333.1551 5/7/2009 968176
Rollup 5 44.0.7333.1644 or
4.0.7333.1645
7/2/2009 970141
Rollup 6 4.0.7333.1750 9/27/2009 970148
Rollup 7 4.0.7333.2138 10/22/2009 971782
Rollup 8 4.0.7333.2542 12/17/2009 975995
Rollup 9 4.0.7333.2644 02/11/2010 977650
Rollup 10 4.0.7333.2741 04/08/2010 979347
Rollup 11 44.0.7333.2861 or
4.0.7333.2862
06/03/2010 981328
Rollup 12 4.0.7333.2935 08/02/2010 2028381
Rollup 13 4.0.7333.3018 09/23/2010 2267499
Rollup 14 4.0.7333.3135 11/18/2010 2389019
Rollup 15 4.0.7333.3231 13/01/2011 2449283

 

 

 

 

 

 

 

 

 

 

 

 

 

Mouse Over the Rollup Version or KB Article Number to go to the appropriate Page.

To determine what is your current Rollup Number in CRM Web Client or CRM Outlook Client go to:-

Help > About Microsoft Dynamics CRM .

CRM 4.0 Build Numbers About

CRM 4.0 Build Numbers About 2

Also if you noticed a different number than the above mentioned, than you've likely installed a Hotfix Click here to Go to the Hotfixes Page.

Of course I will keep this Post Up-to-date with the Upcoming Rollups .

Happy updates Smile.