Delivery fails in Adobe Campaign Classic v8.6.4 due to Snowflake string limit

Last update: Fri Jul 18 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Deliveries in Adobe Campaign Classic v8.6.4 fail during the PrepareMessageImpl step due to a Snowflake string limit error. To fix this, set the Batch quantity in delivery properties to a value below 256, ensuring it is greater than 0 to avoid automatic grouping.

Description description

Environment

Adobe Campaign Classic, v8.6.4

Issue/Symptoms

Delivery fails during the PrepareMessageImpl step.
Error message displayed: ODB-240000 ODBC エラー : String ‘(LISTAGG result)’ is too long and would be truncated SQLState: 22000

Cause

The delivery fails due to the Snowflake database enforcing a 16MB limit on string-type values.

Resolution resolution

Open the delivery in Adobe Campaign Classic v8.6.4.
Go to the Delivery tab under Delivery Properties.
Locate the Message batch quantity setting.
Set the value to a number less than 256 and greater than 0.
Save the changes.
Rerun the delivery preparation process.
Test the updated configuration in a staging environment to evaluate performance impact.

Batch quantity in Campaign v8 documentation

recommendation-more-help