ÃÛ¶¹ÊÓƵ

Documentation

Delivery fails in ÃÛ¶¹ÊÓƵ 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 ÃÛ¶¹ÊÓƵ 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

ÃÛ¶¹ÊÓƵ 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

  1. Open the delivery in ÃÛ¶¹ÊÓƵ Campaign Classic v8.6.4.
  2. Go to the  Delivery tab under Delivery Properties.
  3. Locate the Message batch quantity setting.
  4. Set the value to a number less than 256 and greater than 0.
  5. Save the changes.
  6. Rerun the delivery preparation process.
  7. Test the updated configuration in a staging environment to evaluate performance impact.

Batch quantity in Campaign v8 documentation

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f