---
title: "Open foris collect system error"
url: "https://openforis.support/questions/3288/open-foris-collect-system-error"
tags: ["openforis"]
status: "answered"
score: 0
answer_count: 2
asked: "2021-12-30T17:02:59"
last_activity: "2022-01-04T03:55:29"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Open foris collect system error

Asked by HaiPham on 2021-12-30

Dear Open foris team,
We have problem with system error on open foris collect when we connected via website, that happen when we updated on version 4.0.36 and 4.037 also.
Could you please let me know how to fix this.
Many thanks
The error showed:
System Error
Please report this error to the Open Foris team:
SQL [null]; batch entry 1: [SQLITE_TOOBIG] String or BLOB exceeds size limit (statement too long)

![alt text][1]


  [1]: http://


## Answer (score 0, by Stefano (OF) on 2021-12-31)

Link: https://openforis.support/questions/3288/open-foris-collect-system-error/3289

Dear user,  
When does this error occur? Does it occur when you try to import data in Collect format (.collect-data) from Data Management?  
Probably the size of the record you are trying to restore is too big... We will try to solve this issue with version 4.0.38 of Collect, meanwhile we will contact you to your private email so you can share with us your survey and the data your are trying to restore.  
Many thanks,  
Open Foris Team


## Answer (score 0, by HaiPham on 2022-01-04)

Link: https://openforis.support/questions/3288/open-foris-collect-system-error/3291

Dear OF team,
The problem occured when our colleagues imported Collect format (.collect-data) to our data mangement website, and would liked added more record in the tree table, we have already updated to 4.0.38. That happend when we updated to 4.0.36.
Please help us to resolve problem
Many thanks