How to execute view query in database

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

HI @jayasooryantm

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. :slight_smile:

1 Like

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.

Hi @jayasooryantm
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.

1 Like