Business Data Connectivity Service - BDC database adapter connection exception - Event 8080 (SharePoint 2010 Products)

SharePoint 2010

Applies to: SharePoint Server 2010

Topic Last Modified: 2011-09-24

Alert Name:   Business Data Connectivity Service - BDC database adapter connection exception

Event ID:   8080

Summary:   The Business Data Connectivity service runtime reads the metadata defined in the service application model, establishes a connection with the external data source, and calls the appropriate methods defined in the application model for any of the operations. This event is logged if this connection cannot be established for a database. None of the operations triggered by client applications will be executed, and the data may be rendered obsolete.

Symptoms:   This event appears in the event log: Event ID: 8080 Description: The BDC service application %1 failed to open connection using %2.

Cause:   One or the more of the following might be the cause:

  • The Business Data Connectivity service application model does not have the correct connection properties for the external data source.

  • The external data source is currently not functioning and is not responding.

You must be a member of the Farm Administrators SharePoint group to perform the following procedure.
Resolution:   Verify that the external data source connection properties are correct
  1. On the Central Administration Home page, click Application Management.

  2. On the Application Management page, in the Service Applications section, click Manage service applications.

  3. On the Service Applications page, select the BDC Service Application.

  4. On the Edit tab, in the View group, click External systems.

  5. Click the external system to view its instances.

    By default, the only instances of external system types that are configurable are databases and Web services.
  6. Select the external system name.

  7. Edit or view the settings.

For more information about the settings that are available for configuring a database external system, see Configure an instance of an external system. For more information about managing BDC models, see Manage BDC models (SharePoint Foundation 2010).

Resolution:   Verify that the network connection to the external data source is working
  • Open a Command Prompt window on the application server and type PING <servername>, where <servername> is the database server that hosts the external data source.