I have a very simple scenario
MySQL Table has 5 rows
id → primary key
name → non primary
Package installed: UiPath.Database.Activities v1.7.1
After establishing the connection, I use Execute Query.
SELECT id from TableName – works
SELECT * from TableName – fails
SELECT name from TableName – fails
SELECT name from TableName where id=‘XXX’ – fails
The error message is
System.Exception: Job stopped with an unexpected exit code: 0xC0000005
Looks like SELECT query works if I ONLY extract the primary key.
I need all or a selection of columns. In all the failure scenarios the job stops with an unexpected exit code.
INSERT/UPDATE has no issues