SharePoint Gen

The official blog of Chandrasekar, Microsoft SharePoint PFE

Business Data Catalog with Oracle

Business Data Catalog with Oracle

  • Comments 4

 

There are multiple scenarios in BDC, where we can see this error message “An error occurred while retrieving data from <InstanceName>. Administrators, see the server log for more information.”  Let me talk about one of the instance that can happen when we use BDC Application Definition File (ADF) that uses Oracle database in SharePoint web part.

 

This is the LobSystemInstance that we generally use in ADF when connecting to Oracle database.

 

<Properties>

        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Oracle</Property>

        <Property Name="AuthenticationMode"   Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>

        <Property Name="rdbconnection Data Source" Type="System.String">datasource</Property>

        <Property Name="rdbconnection Integrated Security" Type="System.Boolean">false</Property>

        <Property Name="rdbconnection User ID" Type="System.String">uid</Property>

        <Property Name="rdbconnection Password" Type="System.String">pwd</Property>

        <Property Name="rdbconnection Enlist" Type="System.Boolean">true</Property>

        <Property Name="rdbconnection Pooling" Type="System.Boolean">true</Property>

        <Property Name="rdbconnection Min Pool Size" Type="System.Int32">0</Property>

        <Property Name="rdbconnection Max Pool Size" Type="System.Int32">100</Property>

        <Property Name="rdbconnection Unicode" Type="System.Boolean">false</Property>

        <Property Name="rdbconnection Load Balance Timeout" Type="System.Int32">0</Property>

        <Property Name="rdbconnection Omit Oracle Connection Name" Type="System.Boolean">false</Property>

</Properties>

 

This xml file works fine in BDC tool.  But, when you use in SharePoint BDC web part, the data may not come.  One of the reason could be when Oracle database server and MOSS 2007 server are on a different box.  To overcome this issue, we must install Oracle Client Tools, and Oracle Data Provider .NET support on all SharePoint Servers.

 

Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
  • PingBack from http://blog.a-foton.ru/2008/07/business-data-catalog-with-oracle/

  • Hey,

    I am getting same error "An error occurred while retrieving data from OracleInstance. Administrators, see the server log for more information" while displaying data from Oracle into BDC list web part, I can see column names but data is not coming.

    As per you I need to install Oracle client into SharePoint server system, but on wider view it's not fesible, can you please give me some more detail ?

    Thanks,

    Sanket

  • The best way to troubleshoot this issue is, check the Application log in Event Viewer.  You will get the exact error message.  Let me know what msg it is.

  • I have a Large Server farm . Here i configured BDC , which pulls data from Oracle. But i want to install oracle client on the sharepoint server. I want to know on which server(web front end \ Index server \ Application server \ SQL server) i have to install the Oracle client

Page 1 of 1 (4 items)