We are using Boomi to do an integration between a DB and an MS Access DB. We are using uCanAccess as our JDBC so we can read/write the MS Access DB.
However if our initial query returns more than 49 rows, we receive the following error from Boomi and in turn uCanAccess. I tried using flow control in order to only process 10 documents at a time, but that didn't work. Same error. I tried changing the batch count. Nothing.
Test execution of RYN-EMPDATA-BadgeDB completed with errors. Embedded message: Timer already cancelled.
uCanAccess site Version 3.0.6 with the recommended Jackcess and HSQLDB versions
The insert operations succeed but the update operations do not. We are using a dynamic update DB profile that has been imported from the Access File.