000017338 - RSA Archer Data Feed fails to connect to MySQL or Load Fields: Unable to find the requested Net Framework Data Provider. It may not be installed.

Document created by RSA Customer Support Employee on Mar 17, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000017338
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x
Platform: MySQL
IssueUnable to connect with MySQL server with a Data Feed using proper credentials and details.  Clicking Load Fields fails with Log Reference Id.

An unexpected error has occurred: Unable to find the requested .Net Framework Data Provider. It may not be installed.


Unable to create a database connection: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
Likely causes are the connection string is either improperly formatted or it contains unknown parameters
.


The following is a sample exception is from the w3wp log file:

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <SubType Name="Critical">0</SubType>
        <Source Name="ArcherTech.DataFeed" />
        <Execution ProcessName="w3wp" ProcessID="6548" ThreadID="211" />
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Critical" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>ArcherTech.DataFeed</TraceIdentifier>
                    <Description>Unable to create a database connection: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
Likely causes are the connection string is either improperly formatted or it contains unknown parameters.</Description>

                    <AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-131332415725574658</AppDomain>
                    <ContextData>
                        <LogReferenceId>030617-044705-6286</LogReferenceId>
                    </ContextData>
                    <Exception>
                        <ExceptionType>ArcherTech.DataFeed.Util.LoadFieldsException, ArcherTech.DataFeed.Util, Version=5.5.10000.1088, Culture=neutral, PublicKeyToken=null</ExceptionType>
                        <Message>Unable to create a database connection: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
Likely causes are the connection string is either improperly formatted or it contains unknown parameters.</Message>

                        <Source>ArcherTech.DataFeed.Util</Source>
                        <StackTrace>
   at ArcherTech.DataFeed.Util.SqlDbWrapper.GetDatabaseProviderFactory(String provider)
   at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetDatabaseQuerySchemaSet(XDocument configXDoc)
   at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetSchemaSetWithConfig(Stream streamConfigAndSource)</StackTrace>
                        <InnerException>
                            <ExceptionType>System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
                            <Message>Unable to find the requested .Net Framework Data Provider.  It may not be installed.</Message>
                            <Source>ArcherTech.DataFeed.Util</Source>
                            <ContextData>
                                <Provider>Odbc Data Provider</Provider>
                            </ContextData>
                            <StackTrace>   at ArcherTech.DataFeed.Util.SqlDbWrapper.GetDatabaseProviderFactory(String provider)</StackTrace>
                        </InnerException>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>


 
CauseThe MySQL drivers are not installed on all Archer servers.
Resolution

The following procedures are for adding test and configuring MySQL connection to RSA Archer.  
NOTE: The MySQL drivers version may be different than below.  Contact your MySQL DBA to get the correct version.


  1. Install MySQL drivers for the appropriate version of MySQL on the machine where Data Feed Manager is being used.
    For example: Connector/ODBC 5.3.2 for Windows (x86, 32-bit or 64-bit) ( mysql-connector-odbc-5.3.2-win32 or mysql-connector-odbc-5.3.2-winx64)
    • The Connector/ODBC drivers for MySQL can be obtained here: http://dev.mysql.com/downloads/connector/odbc
    • Before installing the Connector/ODBC drivers for MySQL on Windows:
       
      • Make sure your Microsoft Data Access Components (MDAC) are up to date. The latest version of MDAC can be obtained from the Microsoft Data Access and Storage Website.
      • Make sure you have the Microsoft Visual C++ 2010 Redistributable Package installed on your system. The package is available at the Microsoft Download Center.
      • Make sure to use the version of the package that matches the system type of your Connector/ODBC driver: use the 64-bit version if you are running a 64-bit driver with Archer 64-bit system, and use the 32-bit version if you are running a 32-bit driver with Archer 32-bit system.
       
  2. Using the Microsoft ODBC tool, ODBC Data Source, to the driver and connection string on the server to validate that a connection can be made to the MySQL system. There are the procedures to create the ODBC Data Source to test Connector/ODBC Driver for MySQL on Windows platform.
    1. Open Administrative Tools.
    2. Double-click on Data Source (ODBC).
    3. Click on the Add button. 
    4. Select MySQL ODBC x.x driver (where x.x is the version number) and then click on Finish.
    5. In the MySQL Connector/ODBC Data Source Configuration Dialog:
       
      1. Enter the data source name you would like to use and a description.
      2. Enter the MySQL server address.
      3. Enter the Username for the MySQL database.
      4. Enter the password for the MySQL database.
      5. Click Test. If connection is successful then continue on, otherwise double-check the details of your MySQL Address, Username and Password.
      6. You can select any particular database or leave it blank at this time.
       
  3. Configure the Transport page on the Data Feed setting in RSA Archer to specify the Provider to ODBC Data Provider and then enter the ODBC Connection string.
     
    Example connection string for a 64-bit version of Connector/ODBC driver:

    Driver={MySQL ODBC 5.3w Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;


     
    For more connection string examples, check out https://www.connectionstrings.com/mysql.
     
  4. After configuring the Transport page, try to get the Data Feed to load the schema on the Source Data page under the Data Feed setting in Archer. If you found any error to generate the schema, you need to double-check the configuration of Transport page, including ODBC Provider, connection string, username and password etc.
Legacy Article IDa65454

Attachments

    Outcomes