Back to list
Apr 13 2023

T24-2023 Schedule Service rules failing with 'MySql.Data.MySqlClient' error

BIOVIA CISPro

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:

<DbProviderFactories>

         <remove invariant="Oracle.ManagedDataAccess.Client" />

         <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />

         <!-- <remove invariant="MySql.Data.MySqlClient" /> -->

         <!-- <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.22.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> -->

</DbProviderFactories>

3. Replace the ‘entityFramework’ section with the following:

<entityFramework>

    <providers>

             <provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />

             <!-- <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.11.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> -->

    </providers>

</entityFramework>

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:

<DbProviderFactories>

         <remove invariant="Oracle.ManagedDataAccess.Client" />

         <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />

         <!-- <remove invariant="MySql.Data.MySqlClient" /> -->

         <!-- <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.22.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> -->

</DbProviderFactories>

7. Replace the ‘entityFramework’ section with the following:

<entityFramework>

    <providers>

             <provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />

             <!-- <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.11.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> -->

    </providers>

</entityFramework>

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.