Browse Button is disabled

Question

I have created a BDC using Application Definition Editor. The connectivity with the Oracle database worked well when setting it up. I was also able to successfully create the BDC Column

But when I try to add a new record, the Browse Button next to Check Names is disabled. What could be the issue?

 

 

Below is the ADF XML. Hope it can help locate a clue

 

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="1.0.0.0" Name="TESTLOB" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <LobSystemInstances>
    <LobSystemInstance Name="TESTLOB_Instance">
      <Properties>
        <Property Name="rdbconnectionData Source" Type="System.String">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.4)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))</Property>
        <Property Name="rdbconnectionIntegrated Security" Type="System.String">False</Property>
        <Property Name="rdbconnectionUser ID" Type="System.String">pay</Property>
        <Property Name="rdbconnectionPassword" Type="System.String">j0se</Property>
        <Property Name="rdbconnectionEnlist" Type="System.String">True</Property>
        <Property Name="rdbconnectionPooling" Type="System.String">True</Property>
        <Property Name="rdbconnectionMin Pool Size" Type="System.String">0</Property>
        <Property Name="rdbconnectionMax Pool Size" Type="System.String">100</Property>
        <Property Name="rdbconnectionUnicode" Type="System.String">False</Property>
        <Property Name="rdbconnectionLoad Balance Timeout" Type="System.String">0</Property>
        <Property Name="rdbconnectionOmit Oracle Connection Name" Type="System.String">False</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Oracle</Property>
        <Property Name="SsoApplicationId" Type="System.String">ORION10</Property>
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RdbCredentials</Property>
      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>
  <Entities>
    <Entity EstimatedInstanceCount="10000" Name="PAY.PM_EMP_KEY">
      <Identifiers>
        <Identifier TypeName="System.String" Name="EMP_CODE" />
      </Identifiers>
      <Methods>
        <Method Name="Find_PAY.PM_EMP_KEY">
          <Properties>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
            <Property Name="RdbCommandText" Type="System.String">Select "EMP_CODE","EMP_NAME","EMP_REF_FROM","EMP_REF_TXN_CODE" from  PAY.PM_EMP_KEY where EMP_CODE=:EMP_CODE</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="In" Name="EMP_CODE">
              <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE">
                <Properties>
                  <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                </Properties>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="Return" Name="@PAY.PM_EMP_KEY">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Reader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Record">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_NAME" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_REF_FROM" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_REF_TXN_CODE" />
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="SpecificFinder" ReturnParameterName="@PAY.PM_EMP_KEY" ReturnTypeDescriptorName="Reader" ReturnTypeDescriptorLevel="0" Name="Find_PAY.PM_EMP_KEY_Instance" />
          </MethodInstances>
        </Method>
        <Method Name="FindAll_PAY.PM_EMP_KEY">
          <Properties>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
            <Property Name="RdbCommandText" Type="System.String">Select "EMP_CODE" from  PAY.PM_EMP_KEY</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="Return" Name="@PAY.PM_EMP_KEY">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Reader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Record">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE">
                        <Properties>
                          <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                        </Properties>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="IdEnumerator" ReturnParameterName="@PAY.PM_EMP_KEY" ReturnTypeDescriptorName="Reader" ReturnTypeDescriptorLevel="0" Name="FindAll_PAY.PM_EMP_KEY_Instance" />
          </MethodInstances>
        </Method>
      </Methods>
    </Entity>
  </Entities>
</LobSystem>

Answer 1

The ADF file doesn't seem to be at fault.

Did you try BDC with another database/ADF file before?

Answer 2

Hi Sunny,

             Could you able to figure out what is the reason ?? because i am facing the same problem with my BDC Entity_Picker. browse button is disabled. i couldn't figure out a way.

If you figured it out, do reply back here. 

Thanks

Bob