Hi! We just recently closed out our largest fundraiser of the year. We have a silent auction, live auction, raffle and paddle raise. I'm trying to enter all gifts into our system, separating them into distinct batches according to their specific categories (raffle, paddle raise, auction, etc), but I'm receiving the above error, "An Event Already Exists in a Controlled Batch for this Constituent" so I'm unable to enter new gifts. Is there a setting I need to turn off? I'd like to keep the batches open before processing so I can double check my work. Has anyone run into this and know of any solutions? Thanks!
Hi,
Just ran into this problem.
Try running:
select top 1000 * from TM_EVENT_EXTRACT
What result do you get?
In that table you'll see the mir_lock. You can write a sql script to get rid of that lock and see if that works.
If it doesn't look at the mir_lock's batch number and see if that gift is listed in that batch with the customer number. If it is not, then great, you should be able to remove the whole line in TM_EVENT_EXTRACT and start again.
Failing that I'd look at closing the whole batch and removing all locks from TM_EVENT_EXTRACT and T_ORDERS relating to that batch and separate the order and gifts and contributions to separate batches and hopefully that works.
select * from TM_EVENT_EXTRACT
-- Find the evex_no and mir_lock(batch_no) that is listed in that table. Then you can use the update script
Update TM_EVENT_EXTRACTSET mir_lock = 0Where evex_no = 2809 and mir_lock = 127568