Technical Note T24-2023
April 2023
Schedule Service rules failing with 'MySql.Data.MySqlClient' error
Program
BIOVIA CISPro 2023 SP1
Background
This issue affects all customers who have installed or plan to install CISPro 2023 SP1. An architecture change made as part of the CISPro 2023 SP1 release causes one or more Schedule Service rules to fail with the following error:
The Entity Framework provider type 'MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.11.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' registered in the application config file for the ADO.NET provider with invariant name 'MySql.Data.MySqlClient' could not be loaded.
This issue does NOT cause data loss. This issue only affects the Schedule Service; it does not affect any UI or API operations.
Resolution
1. Open the ‘NbtSchedService.exe.config’ file located in the {CISPro Installation Directory}\23.1.100.6006\Executables directory in a text editor of your choice.
2. Replace the ‘DbProviderFactories’ section with the following:
3. Replace the ‘entityFramework’ section with the following:
4. Save changes to the ‘NbtSchedService.exe.config’ file.
5. Open the ‘app.config’ file located in the {CISPro Installation Directory}\23.1.100.6006\Executables directory in a text editor of your choice.
6. Replace the ‘DbProviderFactories’ section with the following:
7. Replace the ‘entityFramework’ section with the following:
8. Save changes to the ‘app.config’ file.
9. Restart the ‘BIOVIA CISPro Scheduled Service’ Windows service.
How to contact BIOVIA Support
If you have any questions, please contact BIOVIA Support.