There is a field mismatch in the union Query. Field ActivityId is not compatible with ActivityId.

Finance and Operations/AX Technical Forum
1

Hi Experts,

Can anyone help me out this?

I am facing this below error while synchronizing Database .

There is a field mismatch in the union query. Field ActivityId is not compatible with field ActivityId.

Cannot execute a data definition language command on Worker project or quotation commitments view (ResourceActivityCommitmentsView).
The view cannot be created. The underlying table may not exist.

I tried Droping of this (ResourceActivityCommitmentsView) view from SQL DB but no luck.

please suggest.

Thanks in Advance

2

Hello MuraliMohan,

try to check the field ActivityId on view and on query which is being used for this view,
compare it with the table from which it is being fetched. if they are not same please delete it from query and view and add it again from table

3

Hi Kunal,

Thanks for your reply

I checked the field id unfortunately its same for both query and view.
even though i followed your solution but still no luck.

Thanks.

4

Hello Muralimohan,

can you check if projId field of PSASchedEmplReservation table and activityid of ResourceActivityCommitmentsView is having same size?