Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Database error - cannot get table description


We are currently using Lighthouse Studio, version 9.5.3. and have tried to upload survey which contains around 12k-14k variables and have received an error  "The server returned the following error: Database error. Cannot get table description."

We have tried uploading the survey manually as well and the same error is replicated. Can anyone suggest what is the possible cause for this error .
asked Jul 4, 2018 by KarthikMahankali Bronze (3,725 points)

1 Answer

+1 vote
Best answer
I've responded to your request via email, but I'll put it here as well in case others run into it:

If you go into Compose, Survey Settings, Advanced there is a field named "Max Fields per Database Table". For some reason you have that set to 5,000.  The default is 300.  If you change that setting back to 300 things should work.
answered Jul 5, 2018 by Justin Luster Silver Sawtooth Software, Inc. (7,775 points)
selected Jul 6, 2018 by KarthikMahankali
Thank you so much Justin. This worked fine.