Failed to Enable Constraints Error with Execute Query

"RemoteException wrapping System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null,
or foreign-key constraints. "
When I run execute query activity in my project, I’m getting this error. However, I can run this query successfully in dbForge. I’m thinking it’s an issue with my output data table.
I can attach my WF if needed.

This is my exact error message.

For anyone who comes across this issue, I resolved It using casting in my select query. I casted all of my variables that were considered text datatypes into varchar(4000), and it resolved my error.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.