AnsweredAssumed Answered

Connecting UiPath to Filemaker DB

Question asked by MikkoErva on Sep 7, 2018
Latest reply on Sep 8, 2018 by MikkoErva

Hi,

 

I am trying to connect FM database to UiPath RPA with FileMaker ODBC. I can connect to DB and add records with SQL INSERT but when try to read records from table i get following error from UiPath. This is some .NET stuff, i'am not very good at this.

 

- In table is two columns and two rows, all cells contain string so no null values

- All strings are uniq

- So maybe trouble is in foreign key constrain?.

 

When opening FM db in ODBC Query Tool, everything works fine. Can read table.

 

Any idea what's causing the error?

 

Thanks

-mikko

 

System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

 

Server stack trace:

   at System.Data.DataTable.EnableConstraints()

   at System.Data.DataTable.set_EnforceConstraints(Boolean value)

   at System.Data.DataTable.EndLoadData()

   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)

   at UiPath.Database.DatabaseConnection.ExecuteQuery(String sql, Dictionary`2 parameters, Int32 commandTimeout, CommandType commandType)

   at UiPath.Database.Activities.ExecuteQuery.<>c__DisplayClass38_0.<BeginExecute>b__0()

   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)

   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Outcomes