0

v24 Excel Misleading Error for TVQ Limit

Version 24.0.1. In Admin\Views\Settings, there is a setting to limit "Max Return Tvq Count". By default, it's set to 10,000 (which I think is low). If someone in Excel asks for more TVQs than this, they get a misleading error saying "Sequence contains no elements." Is it possible to have the error say something to the effect of "that's too much data. Break it into chunks, or ask your admin to increase the limit."? Thanks!

3 replies

null
    • smason
    • 5 mths ago
    • Reported - view

    Hi Damon Vinciguerra , I think this is a generic error that Views is throwing. I've created a work item to have development look at it.

    • smason
    • 6 days ago
    • Reported - view

    This was fixed in v24.1.1

    The Excel Add-in requests data one tag at a time. So if the number of TVQs per tag were to exceed the Max Tvqs Per Request setting in Views, this error will be thrown.

    • damon_vinciguerra.1
    • 6 days ago
    • Reported - view

    Awesome! Thanks 

Content aside

print this pagePrint this page
  • Status Fixed
  • 6 days agoLast active
  • 3Replies
  • 21Views
  • 2 Following