Run Query - Run query: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Help Studio
, , , ,
1

While running my query in Uipath I am getting this error - Run query: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

If I run this query on databricks its working fine. I figured out the issue is with one of the column which have notes in it (string data type). I tried converting it to varchar,char that doesn’t work either. If I remove that column it work perfect.

Any help or suggestion will be appericated.

image

Thanks in advance

2

I fixed the issue
ODBC default string length was 255 changed that to 4000

image
image485×767 24.8 KB

1 Like
3

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