Clarity

We are in the process of Prod data migration using XOG and we keep getting this error: <Severity>FATAL</Severity> <Description>Project Object update failed</Description> <Exception><![CDATA[SQL Exception with error code : 0]]></Exception> and this is with respect to a multi valued lookup and it its not consistent. it is working some times, the query is working fine DB. could you please help with this. this is causing the Data migration not progress impact lot of prod users

I would suggest to eliminate that Dynamic Lookup attribute and try to XOG as that will make you understand and confident if the issue is happening due to that lookup only. This might be a workaround. But to investigate further I guess it is better that you log a support case.