Gift Entry instances with the Error, "The lookup value provided in Donation Imported, or Payment Imported, is not valid." when all the Donations were successfully inserted into the System.

The user had entered details of all of the Donations that they planned on inserting and hit "Batch Dry Run". All the rows showed the status "Dry Run - validation" and then later on when they hit "Process Batch", all the rows started showing the Donation Import Status as "The lookup value provided in Donation Imported, or Payment Imported, is not valid".

But the catch is all the Donations were successfully inserted into the system.

When I looked up on the issue, I already found a conversation in https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000IQFEzSAP

However, it wasn't very helpful.

Can someone help me understand what went wrong?