Error: Run-Time error '3021': No current record when removing Sex field from Constituent Batch

When removing the Sex field from a Constituent Batch users may experience the following errors:

Run-time error '3021': No current record
Run-time error '-2147418105 (80010007)': Automation error The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have executed.
Error:  ActiveX component can't create object.

This issue is documented in Constituent Batches where the Sex field was present prior to upgrading to version 7.96, patch 7. Patch 7 contains functionality where Gender has full code table functionality, rather than locking values to Male, Female, and Unknown. When users attempt to remove the Sex field in existing Constituent Batches after upgradeing this error occurs. To resolve users should consider the following:

1. If this is a Batch template recreate the template using the Gender field
2. Update the existing Batch with the Gender field and populate with the appropriate data leaving the Sex field blank

Steps to Duplicate

1. Log into Raiser's Edge Database View
2. Select Batch
3. Open a Constituent Batch
4. Select Tools > Edit Batch Setup
5. Select Fields tab
6. Select 'Sex' field and click left-arrow to remove it from the Batch
7. Run-time error '3021': No current record
8. Click OK.
9. Run-time error '-2147418105 (80010007)': Automation error The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have executed.
10. Click OK
11. Click "X" to exit Batch
12. Attempt to reopen Batch
13. Error:  Error:  ActiveX component can't create object.

Was this article helpful?