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
Icon for OneStream Employee rankOneStream Employee
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.