Odoo Help

3

4
5 Answers
2
Laura Jarvenpaa China
7/30/13, 3:42 AM

This is now just hypothesis BUT problem could be the fact that jQuery can't handle such a big amount of data based on this blog post: gabrieleromanato.name/the-limits-of-jquery-with-large-data-structures/ (I can't post links so removed http part from the beginning) it is said that jQuery crashes when example code described in this blog creates table with 30000 rows and 90000 table cells. And for fetching all your products from the databases jQuery has to create a table that has 70000 rows (even if it uses pagination to divide received data on multiple pages it will fetch all data from your db and how big amount of data it for once dumbs into a table showed on your openERP client depends on the implementation).

But like I said this is just hypothesis that you could use for trying to find solution from google I can't be 100% sure if this is connected to your problem.

Edit: out of curiousity could you test to import your products to runbot and check if it will have the same problem (other alternative if you don't want to put your data to runbot is that you download this 15 days trial if you haven't used it yet and test to import data there)? Then we would know if problem is in your configuration/system or in OpenERP in general.

1 Comment
yann France
8/2/13, 1:47 PM

Thanks for this answer ! I'll try what you say !

1
Avatar

Gustavo Argentina

--Gustavo--
1000
| 2 2 6
Buenos Aires, Argentina
--Gustavo--

Python developer, big fan of sailing

Gustavo Argentina
7/18/13, 4:43 PM

Restart your server with the --debug option and see what the log says. You will have detailed information of what caused the crash

3 Comments
yann France
7/19/13, 5:21 AM

Thanks, but the log file is exactly the same before and after clicking on this option (in debug mode)... perhaps this is not the same log file that we are talking about ? I work with the file /var/log/openerp/openerp-server.log, defined in openerp-server.conf (tutorial from The Open Sourcerer).

Daniel Reis Portugal
7/25/13, 7:18 AM

The --debug option doesn't change the logs - it makes the server console stop at the error with a (pdb) prompt. To increase log level use --log-level=debug.

yann France
7/25/13, 8:00 AM

I think I understand, but the log is written in the background, because I run OpenERP this way... So I've to run OpenERP in a console, in the foreground, with these options, to see this (pdb) prompt ?

0
Anton Chepurov Estonia
12/11/13, 8:30 AM

In the UI, there is absolutely no point in fetching all the records, when a user is only interested in finding a handful of them (see @Laura Jarvenpaa's reply on how JS handles it).

You could jump directly to /addons/web/static/src/js/view_form.js:2937 in your server and specify the limit explicitly:

--- addons/web/static/src/js/view_form.js   2013-10-10 09:11:25 +0000
+++ addons/web/static/src/js/view_form.js   2013-12-11 12:09:11 +0000
@@ -2934,7 +2934,7 @@
 values.push({
     label: _t("Search More..."),
     action: function() {
-        dataset.name_search(search_val, self.build_domain(), 'ilike', false).done(function(data) {
+        dataset.name_search(search_val, self.build_domain(), 'ilike', 500).done(function(data) {
             self._search_create_popup("search", data);
         });
     },

A limit of 500 records is more than enough for manual handling - and UI is exactly for this, it's not a batch processing of db data or something.

If you also use web_m2o_enhanced module, then the very same change will have to be introduced to the dataset.name_search() function invocation in web_m2o_enhanced/static/src/js/form.js (search for 'Search More...' in the file).

0
Thierry Godin France
7/18/13, 1:21 PM

Hello, Maybe you could start by taking a look at the openerp-server.log file You should find some useful informations in there.

Regards.

1 Comment
yann France
7/18/13, 1:35 PM

I've already done this. And this crash doesn't leave any log entry... The log is exactly the same before I click on "Search more" and after... but thanks for the answer.

0
Marco Di Francesco Italy
11/15/13, 7:04 AM

I tried this fix and works very well. h_t_t_p_s://code.launchpad.net/~openerp-dev/openerp-web/6.1-opw-574218-xal/+merge/10737

Ask a Question
Writer
Keep Informed
3 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now