Schedule Service rules failing with 'MySql.Data.MySqlClient' error

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.