Insert has more target columns than expressions error in Adobe Campaign Classic
Sometimes everything looks properly set inside your workflow activity in Adobe Campaign. No errors when saving, no warnings – all good. And then comes the surprise. An error shows up during execution. For some, it makes sense immediately. For others, it does not. If you are in that second group, this article is for you.
07/04/2026 09:46:55 queryFailedWorkflows eration O1 ON (O1.iOperationId = W0.iOperationId) WHERE (W0.iFailed = 1) AND (((W0.iWorkflowId > 0 OR W0.iWorkflowId < 0) AND (W0.iDisabled = 0)))' could not be executed.
07/04/2026 09:46:55 queryFailedWorkflows WDB-200001 SQL statement 'INSERT INTO wkf1253911043_3_1 (sLabel,sInternalName,sLabel1,iFailed,iState,sCampaignInternalName,iId) SELECT DISTINCT W0.sInternalName, W0.sLabel, W0.iFailed, W0.iState, O1.sLabel, W0.iWorkflowId FROM XtkWorkflow W0 JOIN NmsOp
07/04/2026 09:46:55 queryFailedWorkflows PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions LINE 1: ...Name,sLabel1,iFailed,iState,sCampaignInternalName,iId) SELEC... ^ .It might look horrific at first, but the reason is simpler than you think.
In most cases, it simply means your “Add data” step added the same column twice with the same name.
It’s not just about the original column name, though. Even if you add two different columns but give them the same alias, the query activity (or enrichment) will fail with an error.
Share With Others
