search

osayouba / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 0 forks source link

Google Spreadsheets has a 400,000 cell limit #933

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Have an error from a user about Aggregate 1.3.4. 

Whey they go to the list of publishers for a particular form, they get "Error: 
Problem persisting data or accessing data (Some how DB entities got into 
problem state)". Looking through the logs and there also seems to be an error 
due to a Spreadsheets cell limit.  

org.opendatakit.aggregate.externalservice.GoogleSpreadsheet insertData: Unable 
to insert data into spreadsheet HHR-v22b exception: OK  
org.opendatakit.aggregate.task.gae.servlet.UploadSubmissionsTaskServlet doGet: 

org.opendatakit.aggregate.exception.ODKExternalServiceException: 
com.google.gdata.util.ServiceForbiddenException: OK This document has reached 
the 400,000 cell per spreadsheet limit. Create a new spreadsheet to continue 
working, as you may not be able to add any more rows or columns. For more 
information on size and complexity limits in Google spreadsheets, visit 
http://docs.google.com/support/bin/answer.py?answer=37603

Original issue reported on code.google.com by yano...@nafundi.com on 28 Oct 2013 at 5:47

GoogleCodeExporter commented 9 years ago 
This was noted on the Data Transfer page. 

Closing since it is now documented.

Original comment by mitchellsundt@gmail.com on 13 Mar 2014 at 8:51