I have a query that retrieves data from a database view table. I can run the query successfully from database client. but from UiPath it’s throwing an error - “Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints”. Is there any difference while running normal query and view query
I think this link will describe the cause of the error and the resolution to it…
This describes the scenario well… I know, this is from a different forum, but it helps to find the answer.
Thank for the reply @Lahiru.Fernando. but it is client DB I can not change any of the db configurations. so is there any way to get the data as it is?. I have tried disabling constraints in datatable, it’s not helping.
Could you please share us the query to retrieve the data from view table, if possible.
Also can you try running base table from Uipath, is this working?
query - “select * from v_inventories”
i have tried for base table it says direct access to the table is denied.