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
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
3 years ago

Maybe it is just a typo?

Appendline() is quite unhandy for long sql statements. Alternatively, you can store the sql in a file (in a dashboard file, or in OS file structure) and access it via a BrApi call.

 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

I worked with his query in SQL Studio, removing the WHERE clauses, and it runs. Runs also in SQL Data Adapter. Then I dropped it into an executeSql call and I got his error. I guess it's some funky option our wrapping api sets, and we have no way to override it.