BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Fri, 26 Sep 2008 20:18:49 Z

Here's my issue -

Using BDC Meta Man - No Problem with File

Upload - No errors

BDC Web Part works fine when adding it to the Shared Service Provider Administration Site Collection, does not work for any other site collections in the same SSP pool, regardless of permissions settings. Still getting error:

Event Type:    Error
Event Source:    Office SharePoint Server
Event Category:    Business Data
Event ID:    5699
Date:        9/26/2008
Time:        3:02:01 PM
User:        N/A
Computer:    MOSS-DV
Description:
A Metadata Exception was constructed in App Domain '/LM/W3SVC/170705818/Root-1-128669299928155353'. The full exception text is: LobSystem could not be found using criteria 'id=1180'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Wed, 01 Oct 2008 08:57:30 Z

Try delete the BDC instance, reimport the ADF file and add the web part back to a web page in any web application that's member of the SSP you used to import the ADF file.

Daniel Bugday™ Web: © SharePoint Forum Blog: Daniel Bugday's Blog

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Tue, 10 Feb 2009 22:02:07 Z

Getting the same issue:

The full exception text is: LobSystem could not be found using criteria 'id=90'.

A Metadata Exception was constructed in App Domain '/LM/W3SVC/149965273/Root-1-128787734813082101'. The full exception text is: LobSystem could not be found using criteria 'id=90'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

XML imported into BDC -

<?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.7" Name="AIT" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">  

  <LobSystemInstances> 

    <LobSystemInstance Name="AIT_Instance">  

      <Properties> 

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

        <Property Name="rdbconnection Integrated Security" Type="System.String">False</Property> 

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

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

        <Property Name="rdbconnection Enlist" Type="System.String">True</Property> 

        <Property Name="rdbconnection Pooling" Type="System.String">True</Property> 

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

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

        <Property Name="rdbconnection Unicode" Type="System.String">False</Property> 

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

        <Property Name="rdbconnection Omit Oracle Connection Name" Type="System.String">False</Property> 

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

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

      </Properties> 

    </LobSystemInstance> 

  </LobSystemInstances> 

  <Entities> 

    <Entity EstimatedInstanceCount="10000" Name="APPL_AIT.DQ_VWS_APP">  

      <Properties> 

        <Property Name="Name" Type="System.String">Name</Property> 

      </Properties> 

      <Identifiers> 

        <Identifier TypeName="System.String" Name="APP_SHORT_NAME" /> 

      </Identifiers> 

      <Methods> 

        <Method Name="GetAITData">  

          <Properties> 

            <Property Name="RdbCommandText" Type="System.String">SELECT APP_ID, APP_FULL_NAME, APP_SHORT_NAME, APP_DESC, TEN_DOT_HIERARCHY, TECH_CONTACT_FNAME, TECH_CONTACT_LNAME FROM APPL_AIT.DQ_VWS_APP WHERE(APP_SHORT_NAME = 'RTI')  

            </Property> 

            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property> 

          </Properties> 

          <FilterDescriptors> 

            <FilterDescriptor Type="Comparison" Name="APP_SHORT_NAME">  

              <Properties> 

                <Property Name="Comparator" Type="System.String">Equals</Property> 

              </Properties> 

            </FilterDescriptor> 

          </FilterDescriptors> 

          <Parameters> 

            <Parameter Direction="In" Name="@APP_SHORT_NAME">  

              <TypeDescriptor TypeName="System.String" IdentifierName="APP_SHORT_NAME" AssociatedFilter="APP_SHORT_NAME" Name="APP_SHORT_NAME">  

                <DefaultValues> 

                  <DefaultValue MethodInstanceName="AppFinderInstance" Type="System.String">RTI</DefaultValue> 

                </DefaultValues> 

              </TypeDescriptor> 

            </Parameter> 

            <Parameter Direction="Return" Name="Apps">  

              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 

                              IsCollection="true" Name="AppDataReader">  

                <TypeDescriptors> 

                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 

                                  Name="AppDataRecord">  

                    <TypeDescriptors> 

                      <TypeDescriptor TypeName="System.String" IdentifierName="APP_SHORT_NAME" Name="APP_SHORT_NAME">  

                        <LocalizedDisplayNames> 

                          <LocalizedDisplayName LCID="1033">APP_SHORT_NAME</LocalizedDisplayName> 

                        </LocalizedDisplayNames> 

                      </TypeDescriptor> 

                      <TypeDescriptor TypeName="System.String" Name="Name">  

                        <LocalizedDisplayNames> 

                          <LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName> 

                        </LocalizedDisplayNames> 

                        <Properties> 

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

                        </Properties> 

                      </TypeDescriptor> 

                    </TypeDescriptors> 

                  </TypeDescriptor> 

                </TypeDescriptors> 

              </TypeDescriptor> 

            </Parameter> 

          </Parameters> 

          <MethodInstances> 

            <MethodInstance Name="AppFinderInstance" Type="Finder" ReturnParameterName="Apps" /> 

          </MethodInstances> 

        </Method> 

      </Methods> 

    </Entity> 

  </Entities> 

</LobSystem>

I hope Microsoft starts explaining to the business world that they better have a developer to write all this NO CODE for them...

http://www.mmwebs.com

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Wed, 11 Feb 2009 08:49:18 Z

From the error message it seems that web part is in different SSP

http://jardalu.blogspot.com

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Wed, 11 Feb 2009 15:35:12 Z

Jardalu said:

From the error message it seems that web part is in different SSP

http://jardalu.blogspot.com

Hmmm. If that is true how could I access the BDC while adding the Web part for BDC list?

http://www.mmwebs.com

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Mon, 29 Jun 2009 18:39:43 Z

Does anyone have an answer for this issue?

BDC Error 5699 - Works in SSP Admin Site Collection, Not Working in other Site Collections

Wed, 01 Jul 2009 03:52:17 Z

Do you have multiple SSPs created ? if so have u imported the ADF to the correct SSP which your web applications are associated with?
You might want to try changing your identifier to APP_ID instead and implement a specificfinder
MS BDC Editor has a feature where u can test your method instance, I would load the ADF into MS BDC editor and test all your methodinstances defined on entity