.Net Framework Data Provider error in Qlik Compose

[Nanda_Ravindra]

Failed to find or load the registered .Net Framework Data Provider.

Resolution

1. Make sure the Oracle ODAC driver is installed.
   
   
2. On Compose, try to browse the Database list from the connection window. If you manage to do so, then there is something wrong with ODAC installation.
   
   To fix the issue please follow the steps below.
    
   
   1. Backup the current <ComposeCtl.exe.config > file from the Compose bin folder.
      
      Default location: C:\Program Files\Qlik\Compose\bin
      
      
   2. Back up the <machine.config> file.
      
      Default location: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
      
      
   3. Remove the below refence entries to the ODAC in the <machine.config> 
      
      <DbProviderFactories>
      <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.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
      
      
   4. Edit the <ComposeCtl.exe.config>, and add the above entry along with the additional "remove invariant " row quoted below under the matching <DbProviderFactories>.
      
      The file should read like this:
      

      <system.data>
       <DbProviderFactories>
         <remove invariant="Oracle.ManagedDataAccess.Client" />
           <add name="SQLite Data Provider" invariant="System.Data.SQLite" 
           description=".Net Framework Data Provider for SQLite" 
           type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"/>
           <add name="Oracle.DataAccess" invariant="Oracle.DataAccess.Client" 
           description="Oracle Data Provider for .NET, Unmanaged Driver" 
           type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, 
           Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
        </DbProviderFactories>
      </system.data>​

      
      
      
3. Restart Compose service

Environment

Qlik Compose all versions
Qlik Compose for Data Warehouses 7. x