tag:blogger.com,1999:blog-4093201867537118791.post1853876225223635651..comments2022-01-31T20:04:58.590+03:00Comments on Microsoft Dynamics CRM Revolution: 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.)Mohammed S. Jamoushttp://www.blogger.com/profile/03258827950024050448noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4093201867537118791.post-88533955920882151772017-02-09T09:30:31.351+03:002017-02-09T09:30:31.351+03:00AnytimeAnytimeMohammed S. Jamoushttps://www.blogger.com/profile/03258827950024050448noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-72426085287191639062017-02-09T02:26:22.799+03:002017-02-09T02:26:22.799+03:00Thank you very much! It really helped me while upg...Thank you very much! It really helped me while upgrading from AX 2012 R2 to R3. I just got an error like this one and thanks to you... it's fixed! Greetings!Erick Aldihttps://www.blogger.com/profile/05959253460390631747noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-21379163221838476862012-05-11T10:17:00.193+03:002012-05-11T10:17:00.193+03:00Hi Richard, I experienced the same error with Anon...Hi Richard, I experienced the same error with Anonymous and nick62. Your solution is exactly working for me! Nice!noelhttps://www.blogger.com/profile/00361484866426877527noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-13798441136779828672011-04-18T14:11:18.798+03:002011-04-18T14:11:18.798+03:00The problem is probably because you have a differe...The problem is probably because you have a different length of the ItemName EDT. The three used edt:s are: ItemName, WrkCtrName and CostSheetNodeDescription. All these three EDT inherits Name (60) in standard AX 2009. If you have an customization on either one of these, the sync will not work. For example if you have ItemName set as length = 50, there will be a sync problem in the upgrade guide (when synchronize database is run).<br /><br />Best regards<br /><br />Richard Hellstenius<br />Accigo AB<br />www.accigo.seRichard Hellsteniushttp://www.accigo.senoreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-45375378673175093122011-01-19T14:36:45.189+03:002011-01-19T14:36:45.189+03:00@nick62: what is the name of the two fields that a...@nick62: what is the name of the two fields that are mismatched? <br /><br />if you can give me more details so i can help :)Mohammed S. Jamoushttps://www.blogger.com/profile/03258827950024050448noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-4910685104904886042011-01-19T14:20:52.221+03:002011-01-19T14:20:52.221+03:00hi,
I have the same problem as Anonymous, I can&#...hi,<br /><br />I have the same problem as Anonymous, I can't seem to figure it out.<br /><br />I'm pretty new to ax and this has thrown a spanner in the works big time.nick62https://www.blogger.com/profile/12856348288102586423noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-74806115126489289012010-12-29T15:03:53.311+03:002010-12-29T15:03:53.311+03:00@Anonymous : what is the name of the two fields th...@Anonymous : what is the name of the two fields that are mismatched?Mohammed S. Jamoushttps://www.blogger.com/profile/03258827950024050448noreply@blogger.comtag:blogger.com,1999:blog-4093201867537118791.post-54337262710848803082010-12-29T13:18:28.022+03:002010-12-29T13:18:28.022+03:00Hi
I have same problem after upgrading the rollu...Hi <br /><br />I have same problem after upgrading the rollup6 hotfix but different table name InventvaluereportresourceIdlookup error message "Synchronize database there is a field mismatch in the union query. Field ResourceName is not compatible with field ResourceName. <br /><br />I already check the resourceName and compare to Itemname in Inventtable. and it is the same what is the possible solution?Anonymousnoreply@blogger.com