"The number of output child records exceeds the allowed value. If the output file contains Long Text Area or Rich Text Area fields, the maximum number of child records is approximately 100-200 records. The upper limit depends on the length of the data type. Aggregate query has too many rows for direct assignment" is displayed.

Child Record Limitations

• If the child template contains Long Text Area or Rich Text Area merge fields, the maximum number of child records is approximately 100-200 records.
• The maximum number of records depends on the length of the field and the number of fields.
• These Limitations apply when Long Text Area or Rich Text Area fields are included, regardless of whether they have record values or not.
• Since the application retrieves child records in a subquery and does not use For Loop, these limitations cannot be circumvented.

Resolution

• Remove the Long Text Area or Rich Text Area item insert from the template.
• Specify the output condition for child records and reduce the number of child records to
• Limit the number of output child records. (OFC Pro)

Salesforce Help

Aggregate query has too many rows for direct assignment but less than 200 rows

Instruction manual

Limitations