When running a query or export with large text fields selected in the output, the following error may occur:
Run-time error '-2147211479 (80042729)': Array/Buffered Fetching is not Supported on DataSets with LONG BINARY/MEMO Fields.
Raiser's Edge fields with large amounts of text selected for output in a Query or Export may cause this error. Some examples of these fields are, but not limited to:
Any NotePad Notes field found on constituent notepads, gift notepads, action notepads, event notepads, proposal notepads, etc.
A large text box found on records, such as Fund (record) Notes, Campaign (record) Notes, Appeal (record) Notes, Relationship record Notes, Job record Description, etc.
A field with a Zoom feature, such as Gift Reference, to view more text.
This error may occur due to the Query or Export design (criteria and/or selected output fields) when a large text field has a lot of text and/or the output has a large number of records. Adjust the Query and/or Export settings using the following steps in order until the issue is resolved:
If a query, mark Suppress Duplicate Rows at Tools > Query Options > Record Processing tab. Re-run the query.
Remove the Notes-type field from the output fields in the query