Campaign: Dataflow Run Failure: Adobe Campaign Managed Cloud destination Export
A customer added a calculated field to the Adobe Campaign Destination in AEP and the export workflow started failing.
Description description
Error:
“code”: “ACC-0001-500” “message”: "Error occurred while execution for flowId 676f3fgd-7cef-4687-89f7-5aefb9050ye3
Attribute mapped with a calculated field:
Source - xdm: _xxxxxxxx.identity.email_id_sha256 Target - Attribute: email_id_sha256_hash
Resolution resolution
It is a known campaign-io bug.
The problem is that the column SEMAIL_ID_SHA256_HASH (Adobe Campaign Snowflake name for the email_id_sha256_hash attribute) existed as VARCHAR (16,777,216) Snowflake’s default when no size is specified.
When the customer saved the iif() mapping change, campaign-io sent a control plane event to ACC: “alter your Snowflake group table — SEMAIL_ID_SHA256_HASH should be VARCHAR (30,000).”
Snowflake does not allow reducing VARCHAR size. The column was 16,777,216 bytes; the instruction says 30,000. Snowflake returns:
ODB-240000: cannot change column SEMAIL_ID_SHA256_HASH from type VARCHAR(16777216)
Workaround step by step:
- Do NOT re-edit or re-save destination 645f3gfd — saving will trigger another failed ALTER TABLE
- Create a NEW destination connection in AEP pointing to the same ACC instance
- Configure the new destination with the iif() mapping from the initial creation (not as an edit)
- Activate the audience to the new destination and confirm runs succeed
- Deactivate the audience from the broken 645f3gfd destination
- Have the Campaign team validate that the workflow and any other workflows using this audience group are updated to read from the new group table.