Forum Discussion

Nikpowar97's avatar
Nikpowar97
Contributor
3 years ago

Enforce Constraints on Data Table. Failed to enable constraints. One or more rows contain values.

I am trying to return a SQL query in a Data table inside the business rule. But I am Getting the issue: Failed to enable constraints. One or more rows contain values violating non-null, unique, or fo...
Dashboards
OS_Pizza's avatar
OS_Pizza
Contributor III
3 years ago

1. Use Try and catch to put up an exception when the error occurs.

2. Use datatable.Geterrors method to print the outlier.

 

JackLacava's avatar
JackLacava
Community Manager
3 years ago

I tried that, but getErrors returns an empty row. That's probably because we're not manipulating the datatable, but rather just replacing it with a new instance that executesql returns.