Robotic Process Automation (RPA)

 View Only

 SQLite Script Works in Studio but Fails in Scheduler

Larissa Reis's profile image
Larissa Reis posted Wed July 09, 2025 07:50 AM

I’m currently facing a issue related to a script that uses SQLite. When executed through IBM RPA Studio, the script runs normally without any errors.

However, after updating Studio to version 30.0.0, the same script fails when triggered via schedule. The error message returned is "Could not load file or assembly 'MySql.Data, Version=8.0.33.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040"

The untranslated message is this: "Não foi possível carregar o arquivo ou assembly 'MySql.Data, Version=8.0.33.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' ou uma de suas dependências.A definição do manifesto do assembly localizado não corresponde à referência do assembly. (Exceção de HRESULT: 0x80131040)"

This is unexpected since the script does not use MySQL directly, only SQLite. It worked fine before the update, so I suspect the new version may have changed the way dependencies are handled during scheduled executions.

Has anyone faced something similar, or knows how to resolve it?

Milan Babčanec's profile image
Milan Babčanec posted Thu July 10, 2025 04:09 AM

Hi Larissa,

pls. follow this guide:
https://www.ibm.com/docs/en/rpa/30.0.x?topic=automation-installing-mysql-connector

However, use the MySQL version 8.0.33 (documentation is outdated). If the guide does not help, copy files "MySql.Data.dll" and "MySql.Data.EntityFramework.dll" to directory "C:\Program Files\IBM Robotic Process Automation\IBM Robotic Process Automation Client\".

You need to realize these steps on the computer, where the bot actually runs.

Related Content