Limit of Work Items accesable in Excel

Limit of Work Items accesable in Excel

• EmacsUser

  I am not sure what the limitation is, but I believe it works by constructing a query with an expression with the ID of each work item chosen. You are probably hitting some limitation as that query is parsed or executed. If you right click on the query in the Team Explorer and invoke the command then you should not encounter the problem.
  

• sandy_patil

  Thanks for the log file. We where able to repro this problem also.

  We will take a look at the problem.

  Thanks for the information.

  
  
  

• Oleks

  We have tested till 5000 work items with our latest bits and it works.

  We should work with 2400 work items.

  The error message does not tell us much can you create a "excel.exe.config" file from the below code.

  <configuration>
  <system.diagnostics>
  <switches>
  <add name="General" value="3" />
  </switches>
  <trace autoflush="false" indentsize="3" />
  </system.diagnostics>
  </configuration>

  Copy it to %systemdrive%\Program Files\Microsoft Office\Office 11 directory

  Run your scenario, this will create a log file in %temp% directory called tfs_msexcel.log.

  Can provide the data in this log file.

  Thanks.

  
  
  

• Stephen J.Vanterpool

  Hi,
  it is still happening, when i mark all items in the query with STRG-A. @Tony: Thanks for your hint. I knew this workaround but wanted to post the "bug".
  
  The logfile generates the following output:
  [Info, PID 2276, TID 3912, 15:38:15.687] Managed ELead Excel AddIn loaded
  Middle tier URL: http://statfs02:8080/WorkItemTracking/v1.0/ClientService.asmx
  Middle tier configurationUrl: http://statfs02:8080/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx
  Default cache directory: C:\Dokumente und Einstellungen\m.patzak\Lokale Einstellungen\Anwendungsdaten\Microsoft\Team Foundation\1.0\Cache
  InstanceInfo Id: aac60822-1398-4c7b-935a-0d83900c21e9
  <detail><details id="-1" xmlns="http://schemas.microsoft.com/TeamFoundation/2005/06/WorkItemTracking/faultdetail/02" /></detail>
  Invalid argument exception from serverSystem.Web.Services.Protocols.SoapException: TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement ---> TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement
  at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
  at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
  at Microsoft.TeamFoundation.WorkItemTracking.Proxy.ClientServiceProxy.QueryWorkitems(XmlElement psQuery, QuerySortOrderEntry[] sort, Boolean useMaster, DateTime& asOfDate, MetadataTableHaveEntry[] metadataHave, String& dbStamp, RowSetCollection& metadata)
  at Microsoft.TeamFoundation.WorkItemTracking.Proxy.ClientService.QueryWorkitems(String requestId, XmlElement psQuery, QuerySortOrderEntry[] sort, Boolean useMaster, Int32[]& ids, DateTime& asOfDate, MetadataTableHaveEntry[] metadataHave, String& dbStamp, IMetadataRowSets& metadata)
  at CProdStudioBackendChannel.HrIGetIssueIDs(CProdStudioBackendChannel* , Int32 lObjectType, Char* bstrXMLFilter, Char* bstrRequestId, tagVARIANT* pvarsalIssueIDs, tagVARIANT* pvardtAsOf, tagVARIANT varsabstrSortBy, tagVARIANT varsafSortOrder)
  Got backend ex: TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement ---> TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement
  [Error, PID 2276, TID 3912, 15:38:21.937] {
  
  [Error, PID 2276, TID 3912, 15:38:22.374] Exception: {
  Exception Message: The server operation failed. (BackendArgumentException). (type UnexpectedErrorException)
  
  Exception Stack Trace: at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.HandleComException(Int32 hr)
  at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.DatastoreItemListClass.Execute()
  at Microsoft.TeamFoundation.WorkItemTracking.Client.Query.RunQueryWithRequestId(String requestId)
  at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.Query(String wiql, IDictionary context)
  at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadQuery.GetWorkItemsFromWiql(ProjectContext projectContext, String wiql)
  at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadQuery.GetWorkItemsFromReference(ProjectContext context, String queryReference)
  at Microsoft.TeamFoundation.OfficeIntegration.Client.ELeadWorkbook.CreateList(ProjectContext projectContext, Range range, String queryReference, Boolean bindToQuery)
  at Microsoft.TeamFoundation.OfficeIntegration.Client.ExcelAddIn.CreateDocumentInternal(String tfcNamespaceUrl, String tfcProject, String documentPath, String templateFile, String queryReference, Boolean bindToQuery)
  
  Inner Exception Details:
  
  Exception Message: TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement ---> TF51655: The update being performed generates a SQL batch with too many parameters. Try a smaller update.
  Parameter name: updateElement (type SoapException)
  
  Exception Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
  at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
  at Microsoft.TeamFoundation.WorkItemTracking.Proxy.ClientServiceProxy.QueryWorkitems(XmlElement psQuery, QuerySortOrderEntry[] sort, Boolean useMaster, DateTime& asOfDate, MetadataTableHaveEntry[] metadataHave, String& dbStamp, RowSetCollection& metadata)
  at Microsoft.TeamFoundation.WorkItemTracking.Proxy.ClientService.QueryWorkitems(String requestId, XmlElement psQuery, QuerySortOrderEntry[] sort, Boolean useMaster, Int32[]& ids, DateTime& asOfDate, MetadataTableHaveEntry[] metadataHave, String& dbStamp, IMetadataRowSets& metadata)
  at CProdStudioBackendChannel.HrIGetIssueIDs(CProdStudioBackendChannel* , Int32 lObjectType, Char* bstrXMLFilter, Char* bstrRequestId, tagVARIANT* pvarsalIssueIDs, tagVARIANT* pvardtAsOf, tagVARIANT varsabstrSortBy, tagVARIANT varsafSortOrder)
  
  }
  [Error, PID 2276, TID 3912, 15:38:22.374] }
  
  
  
  
• Limit of Work Items accesable in Excel