none
Error while crawling LOB contents. ( Value cannot be null. Parameter name: fieldDotNotation ) RRS feed

  • Question

  • Hello,

    I built a solution using BCS Metaman which queries some information from Oracle, and it is working on my development farm which is running SharePoint 2010 Enterprise but does not have FAST installed. On my development farm I am able to display the information from oracle on a site in an external list, and crawl the data using SharePoint's built in Search, and search the data using the search Center. I am attempting to deploy a the solution to another SharePoint 2010 Enterprise farm with FAST Search, and when I deploy the solkution I am able to display the information from oracle in an external list on a site, but when I attempt to crawl the data using the Query SSA the following error is displayed in the crawl log:

    Error while crawling LOB contents. ( Value cannot be null. Parameter name: fieldDotNotation )

    Additionally, the following errors are displayed in the SharePoint log:

    03/14/2011 11:10:53.88 w3wp.exe (0x0D60) 0x1894 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) b8c37a21-b834-41e1-9b57-e4a40c08afb5
    03/14/2011 11:10:53.88 w3wp.exe (0x0D60) 0x1894 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.415415925767102 b8c37a21-b834-41e1-9b57-e4a40c08afb5
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data f8dk Medium Checking for current connection to SystemInstance: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqa Medium CurrentConnection is null, getting the connection from connection manager.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uq3 Medium Will return connection for the dot net assembly associated with LobSystem.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9upy Medium Adding Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqb Medium Got the connection, managing connection in the system utility.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqc Medium Getting the entity class instance from connection manager.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uq6 Medium Resolving entity object with the Type 'BCSMetaMan_TetraLinx_EMPLOYEES.Model.APPS_XX_EMPLOYEE_INFO_VEntityService, BCSMetaMan_TetraLinx_EMPLOYEESLobSystem'
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uq8 Medium Creating entity object of Type 'BCSMetaMan_TetraLinx_EMPLOYEES.Model.APPS_XX_EMPLOYEE_INFO_VEntityService, BCSMetaMan_TetraLinx_EMPLOYEESLobSystem'
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uqf Medium Parameter Signature: System.String EMPLOYEE_NUMBER,
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uqg Medium Parameter Values:
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uqh Medium
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uqh Medium Parameter 'EMPLOYEE_NUMBER':
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EF4 Business Connectivity Services Business Data 9uqh Medium An instance of type 'System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0D2C Business Connectivity Services Business Data 9uqf Medium Parameter Signature: System.String EMPLOYEE_NUMBER,
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0D2C Business Connectivity Services Business Data 9uqg Medium Parameter Values:
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0D2C Business Connectivity Services Business Data 9uqh Medium
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0D2C Business Connectivity Services Business Data 9uqh Medium Parameter 'EMPLOYEE_NUMBER':
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0D2C Business Connectivity Services Business Data 9uqh Medium An instance of type 'System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqf Medium Parameter Signature: System.String EMPLOYEE_NUMBER,
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqg Medium Parameter Values:
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqh Medium
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqh Medium Parameter 'EMPLOYEE_NUMBER':
    03/14/2011 11:10:53.90 mssdmn.exe (0x1694) 0x0EBC Business Connectivity Services Business Data 9uqh Medium An instance of type 'System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 Business Connectivity Services Business Data 9uqe Medium Closing the connection, managing connection in the system utility.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 Business Connectivity Services Business Data 9uq5 Medium Closing connection.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 Business Connectivity Services Business Data 9upz Medium Releasing Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (systemUtility.ExecuteStatic: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance : GetSingleAPPS_XX_EMPLOYEE_INFO_VEntityByID). Execution Time=393.850615092142
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 SharePoint Server Search FilterDaemon fld1 High Fltrdmn: failure reading ACL. Error 0x8004fd11 [fltrdaemon.cxx:2591] d:\office\source\search\native\mssdmn\fltrdaemon.cxx
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1670 SharePoint Server Search FilterDaemon e4ye High FLTRDMN: Errorinfo is "Value cannot be null. Parameter name: fieldDotNotation" [fltrsink.cxx:553] d:\office\source\search\native\mssdmn\fltrsink.cxx
    03/14/2011 11:10:54.10 mssearch.exe (0x012C) 0x0E04 SharePoint Server Search GatherSvc fus3 Medium Transaction failed in plugin RHTG Url bdc3://bcsmetaman_tetralinx_employeeslobsystem_bcsmetaman_tetralinx_employeeslobsysteminstance/Default/00000000%252D0000%252D0000%252D0000%252D000000000000/192/BCSMetaMan%255FTetraLinx%255FEMPLOYEESLobSystemInstance/194?s_id=SEAAAAA==NQAyADUAMwA1ADYA&s_ce=07h223vsg7h223vsg80g000g10204000u41gg3vu84000vprtf Error 0x8004fd11 [gthrtrx.cxx:1054] d:\office\source\search\native\gather\gthrsvc\gthrtrx.cxx
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data f8dk Medium Checking for current connection to SystemInstance: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqa Medium CurrentConnection is null, getting the connection from connection manager.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uq3 Medium Will return connection for the dot net assembly associated with LobSystem.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9upy Medium Adding Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqb Medium Got the connection, managing connection in the system utility.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqc Medium Getting the entity class instance from connection manager.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uq6 Medium Resolving entity object with the Type 'BCSMetaMan_TetraLinx_EMPLOYEES.Model.APPS_XX_EMPLOYEE_INFO_VEntityService, BCSMetaMan_TetraLinx_EMPLOYEESLobSystem'
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x0D3C SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://ttc012devspapp1:32843/31dd3b6c67ee415a98ec21749b2e2be6/BdcService.svc/http' Channel: 'Microsoft.SharePoint.BusinessData.SharedService.IBdcServiceApplication' Action: 'http://www.microsoft.com/Office/2009/BusinessDataCatalog/BusinessDataCatalogSharedService/GetServiceApplicationId' MessageId: 'urn:uuid:d2b24130-c65c-4a30-9249-32e5e597a573'
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1504 Business Connectivity Services Business Data 9uqe Medium Closing the connection, managing connection in the system utility.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1504 Business Connectivity Services Business Data 9uq5 Medium Closing connection.
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1504 Business Connectivity Services Business Data 9upz Medium Releasing Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:54.10 mssdmn.exe (0x1694) 0x1504 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (systemUtility.ExecuteStatic: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance : GetSingleAPPS_XX_EMPLOYEE_INFO_VEntityByID). Execution Time=426.055546165784
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x1504 SharePoint Server Search FilterDaemon fld1 High Fltrdmn: failure reading ACL. Error 0x8004fd11 [fltrdaemon.cxx:2591] d:\office\source\search\native\mssdmn\fltrdaemon.cxx
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x1504 SharePoint Server Search FilterDaemon e4ye High FLTRDMN: Errorinfo is "Value cannot be null. Parameter name: fieldDotNotation" [fltrsink.cxx:553] d:\office\source\search\native\mssdmn\fltrsink.cxx
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0E84 Business Connectivity Services Business Data 9uqe Medium Closing the connection, managing connection in the system utility.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0E84 Business Connectivity Services Business Data 9uq5 Medium Closing connection.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0E84 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (systemUtility.ExecuteStatic: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance : GetSingleAPPS_XX_EMPLOYEE_INFO_VEntityByID). Execution Time=430.587127693604
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0E84 SharePoint Server Search FilterDaemon fld1 High Fltrdmn: failure reading ACL. Error 0x8004fd11 [fltrdaemon.cxx:2591] d:\office\source\search\native\mssdmn\fltrdaemon.cxx
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0E84 SharePoint Server Search FilterDaemon e4ye High FLTRDMN: Errorinfo is "Value cannot be null. Parameter name: fieldDotNotation" [fltrsink.cxx:553] d:\office\source\search\native\mssdmn\fltrsink.cxx
    03/14/2011 11:10:54.12 w3wp.exe (0x0D60) 0x04EC SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://ttc012devspapp1.tt.local:32843/31dd3b6c67ee415a98ec21749b2e2be6/bdcservice.svc/http' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://www.microsoft.com/Office/2009/BusinessDataCatalog/BusinessDataCatalogSharedService/GetServiceApplicationId' MessageId: 'urn:uuid:d2b24130-c65c-4a30-9249-32e5e597a573' b1670f9b-7995-4b48-9e29-464b7cb180e5
    03/14/2011 11:10:54.12 w3wp.exe (0x0D60) 0x04EC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) b1670f9b-7995-4b48-9e29-464b7cb180e5
    03/14/2011 11:10:54.12 w3wp.exe (0x0D60) 0x04EC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.549511180890309 b1670f9b-7995-4b48-9e29-464b7cb180e5
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uq8 Medium Creating entity object of Type 'BCSMetaMan_TetraLinx_EMPLOYEES.Model.APPS_XX_EMPLOYEE_INFO_VEntityService, BCSMetaMan_TetraLinx_EMPLOYEESLobSystem'
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqf Medium Parameter Signature: System.String EMPLOYEE_NUMBER,
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqg Medium Parameter Values:
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqh Medium
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqh Medium Parameter 'EMPLOYEE_NUMBER':
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0D3C Business Connectivity Services Business Data 9uqh Medium An instance of type 'System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data f8dk Medium Checking for current connection to SystemInstance: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqa Medium CurrentConnection is null, getting the connection from connection manager.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uq3 Medium Will return connection for the dot net assembly associated with LobSystem.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9upy Medium Adding Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqb Medium Got the connection, managing connection in the system utility.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqc Medium Getting the entity class instance from connection manager.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uq6 Medium Resolving entity object with the Type 'BCSMetaMan_TetraLinx_EMPLOYEES.Model.APPS_XX_EMPLOYEE_INFO_VEntityService, BCSMetaMan_TetraLinx_EMPLOYEESLobSystem'
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqf Medium Parameter Signature: System.String EMPLOYEE_NUMBER,
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqg Medium Parameter Values:
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqh Medium
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqh Medium Parameter 'EMPLOYEE_NUMBER':
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x0F74 Business Connectivity Services Business Data 9uqh Medium An instance of type 'System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
    03/14/2011 11:10:54.12 mssearch.exe (0x012C) 0x1488 SharePoint Server Search GatherSvc fus3 Medium Transaction failed in plugin RHTG Url bdc3://bcsmetaman_tetralinx_employeeslobsystem_bcsmetaman_tetralinx_employeeslobsysteminstance/Default/00000000%252D0000%252D0000%252D0000%252D000000000000/192/BCSMetaMan%255FTetraLinx%255FEMPLOYEESLobSystemInstance/194?s_id=SEAAAAA==NQAyADUAMwAwADEA&s_ce=07h223vsg7h223vsg80g000g10204000u41gg3vu84000vprtf Error 0x8004fd11 [gthrtrx.cxx:1054] d:\office\source\search\native\gather\gthrsvc\gthrtrx.cxx
    03/14/2011 11:10:54.12 mssearch.exe (0x012C) 0x147C SharePoint Server Search GatherSvc fus3 Medium Transaction failed in plugin RHTG Url bdc3://bcsmetaman_tetralinx_employeeslobsystem_bcsmetaman_tetralinx_employeeslobsysteminstance/Default/00000000%252D0000%252D0000%252D0000%252D000000000000/192/BCSMetaMan%255FTetraLinx%255FEMPLOYEESLobSystemInstance/194?s_id=SEAAAAA==NQAxADIAOQA4ADQA&s_ce=07h223vsg7h223vsg80g000g10204000u41gg3vu84000vprvf Error 0x8004fd11 [gthrtrx.cxx:1054] d:\office\source\search\native\gather\gthrsvc\gthrtrx.cxx
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x13A0 Business Connectivity Services Business Data f8dk Medium Checking for current connection to SystemInstance: BCSMetaMan_TetraLinx_EMPLOYEESLobSystemInstance
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x13A0 Business Connectivity Services Business Data 9uqa Medium CurrentConnection is null, getting the connection from connection manager.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x13A0 Business Connectivity Services Business Data 9uq3 Medium Will return connection for the dot net assembly associated with LobSystem.
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x13A0 Business Connectivity Services Business Data 9upy Medium Adding Assembly resolve event on AppDomain.CurrentDomain
    03/14/2011 11:10:54.12 mssdmn.exe (0x1694) 0x13A0 Business Connectivity Services Business Data 9uqb Medium Got the connection, managing connection in the system utility.

    Thursday, March 17, 2011 4:58 AM

All replies

  • Quick note, you should add crawls to the Content SSA, not the query SSA.

    Regards,
    Mikael Svenson 


    Search Enthusiast - MCTS SharePoint/WCF4/ASP.Net4
    http://techmikael.blogspot.com/ - http://www.comperiosearch.com/
    Friday, March 18, 2011 10:53 AM
  • Hi Mikael,

    I appreciate your response. My statement above is incorrect, I acctually did add this to the Content SSA, and not the Query SSA. Let me know if you have any other ideas that might help resolve this issue.

    Tyler

    Monday, March 21, 2011 4:37 PM
  • Is fieldDotNotation a field in your BCS entity? If so, it seems it might be returning null for some entries thus causing the error. If you can modify the view/sql to have it always return data or an empty string, that might help.

    -m


    Search Enthusiast - MCTS SharePoint/WCF4/ASP.Net4
    http://techmikael.blogspot.com/ - http://www.comperiosearch.com/
    Monday, March 21, 2011 6:50 PM
  • Is fieldDotNotation a field in your BCS entity? If so, it seems it might be returning null for some entries thus causing the error. If you can modify the view/sql to have it always return data or an empty string, that might help.

    -m


    Search Enthusiast - MCTS SharePoint/WCF4/ASP.Net4
    http://techmikael.blogspot.com/ - http://www.comperiosearch.com/

    Hi Mikael,

    Thanks for your response, I had my DBA replace all NULL values with an empty space, but the problem is still happening. Let me know if you have any further ideas to address this issue.

    Thanks,

    Tyler

    Wednesday, March 23, 2011 6:54 PM
  • Just a thought, if you replace it with a character instead of space, do you still get the error?

    -m


    Search Enthusiast - MCTS SharePoint/WCF4/ASP.Net4
    http://techmikael.blogspot.com/ - http://www.comperiosearch.com/
    Thursday, March 24, 2011 1:33 PM
  • Hi Tyler Cranston - Wardrop,

    This error can occur if an Entity element in your Business Data Connectivity Model File has empty title property:

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

    so you should either remove this Property at all from BDC file or select any column to be the "Title" property (for exemple):

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


    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts
    • Proposed as answer by Rob Va - MSFT Tuesday, August 2, 2011 12:46 AM
    Wednesday, July 27, 2011 5:48 PM