When executing a query I’m getting this error when I try to get a column containing a string:
**Execute query : Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.**
Being completely new to UiPath, I did not yet find out how to disable these constraints.
Steps to reproduce:
My flow is as follows:
Connect -> 2)execute query -> 3)For each row (where I use write line row(0).ToString)
My connection is an ODBC source
For testing my query is as simple as: "SELECT productname FROM products"
This works fine on some columns but many (string) columns result in the error.
I tried adjusting the flow to first set a type for a column name:
Connect -> Build Data Table -> Execute query -> For each row
In ‘Build Data Table’ I added 1 column of string type with column name “productname” (the one I use in the query). This did not solve the error.
UiPath Studio Community Version 2016.2.6344 Stable
OS Version: Windows Server 2012 R2 Standard 64-bit. .NET 4.0.30319.42000
Hopefully someone can point me in the right direction, or can make some suggestions what to check