Getting Data type mismatch error in Union Queries. Although I tried all the solution (Links) provided on net but still not able to solve this issue. Main thing is that we have only one field in query from the comparison of two fields. as in below error we have only Sales Name in “SmmActiitiesAssociation”.
Just because of this error we are not able to Sync and Compile Data Dictionary fully.
Error:-
Synchronize database There is a field mismatch in the union query. Field SalesName is not compatible with field Description.
Could you please show screenshot with your query in AOT (datasources and field lists)
I had faced the same issue before, make sure if anyone changed the EDT size of some filed in table. Make sure the table which are used in the query data source it should be same size for all the table in the query, If any one field mis matches between the table u will receive this error.
Don’t Forget to Verify Solution www.waytoax.wordpress.com
I fixed this error by increasing the EDT size but I as we didn’t changes the length but still It was changed … May be our functional person wanted to be James Bond…