Issues with MySQL database - query and looping

[Herschel]

I have a simple task:
1. Connect to MySQL DB and issue a select
select req_id from email_process where action = "Open" and processed =0;
2. Open Notepad.exe
3. Start Loop Each row in SQL Query dataset
4. Keystroke Req:$Dataset Column(1)$[ENTER]
5. End Loop

There are three rows in the result set (when running SQL directly). However it looks like an issue in Automation Anywhere where there are extra empty rows as I get the following in notepad (and I eventually ESC to get out of the loop):
Req:261349
Req:261247
Req:258628
Req:
Req:
Req:
Req:
Req:
Req:
Req:
Req:
Req:

As mentioned in the below thread there is a known bug/issue when using AA with MySQL database:
MySQL & Loop Requires Maximum Number of Records

At least for the version I'm using which is 5.0.2 Premier. I've used the workaround discovered by the other gentlemen and set max fetch rows = 1,000. Before doing this I would never enter the loop (but I could access the $Dataset Column(1)$ value directly before the loop).

Are there any thoughts or other workarounds in use to get Automation Anywhere to work with MySQL? I'm using the latest MySQL ODBC client.

Thanks

[forumstaff]

Hello Herschel,

We will be able to guide you with proper solutions only after taking a look at the task on your end.
If you can share your contact details with us on support@automationanywhere.com we can give you a call and we can schedule an online meeting which will be helpful for us in suggesting you with solutions.

Thanks & Regards