Could someone please explain what a ViewTooLargeException is?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

This occurs when I run a simple .Query(); on my table. No documentation on github, nothing on the dev forums.

Sample code:

public static IQClient client;
public static IQTable EvidenceItems;
public static IQApplication application;

public static void ReplicateQuickbaseData()
{
client = QuickBase.Login("xxxxx@xxxxxxxx.com", "xxxxxx", "xxxxxxxx.quickbase.com");
application = client.Connect("xxxxxxxx", "xxxxxxxxxxxxxxxxxxxxxxxxxx");
EvidenceItems = application.GetTable("xxxxxxxx");

EvidenceItems.Query(); //THIS LINE IS ERRORING
}

Photo of Curtis

Curtis

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Jesus

Jesus

  • 0 Points
I guess not even QB knows as it shows no information:

https://www.quickbase.com/api-guide/errorcodes.html
Photo of Curtis

Curtis

  • 0 Points
Yeah I saw that, it's error code 75 but there is no description listed
Photo of Keith

Keith, Champion

  • 1,192 Points 1k badge 2x thumb
how many records are in the table, also are there a lot of fields in that table as well?  if so, try that same code on a table with few records to see if it works.  It may be that the result set returned form the query is too big
Photo of Curtis

Curtis

  • 0 Points
There are about 6000 records in the table and ~95 fields that I need to replicate to SQL I tried this on a similarly sized different table and it works fine. We are thinking that it may be one particular field causing this issue. Still trying to figure out which one.
Photo of Curtis

Curtis

  • 0 Points
The Quickbase API error code is 75 for reference.