Hi, I am using Open erp all in one v5.0.0_rc3. I'm trying to import multiple csv files (partner, partner address, projects, orders). All the data files have a reference to a partner and are thus dependend on each other. Since they are linked, all the files must be uploaded in one session. Otherwise the id that links them is lost if i first upload the partners and then the orders for example.
However upon uploading i get the following error: [Fri Jan 16 2009 11:11:10] ERROR:web-services:[01]: Exception in call: Traceback (most recent call last): [Fri Jan 16 2009 11:11:10] ERROR:web-services:[02]: File "wizard\__init__.pyo", line 73, in execute_cr [Fri Jan 16 2009 11:11:10] ERROR:web-services:[03]: File "C:\Program Files\OpenERP AllInOne\Server\addons\base\module\wizard\wizard_module_upgrade.py", line 92, in _upgrade_module [Fri Jan 16 2009 11:11:10] ERROR:web-services:[04]: File "pooler.pyo", line 55, in restart_pool [Fri Jan 16 2009 11:11:10] ERROR:web-services:[05]: File "pooler.pyo", line 38, in get_db_and_pool [Fri Jan 16 2009 11:11:10] ERROR:web-services:[06]: File "addons\__init__.pyo", line 638, in load_modules [Fri Jan 16 2009 11:11:10] ERROR:web-services:[07]: File "addons\__init__.pyo", line 539, in load_module_graph [Fri Jan 16 2009 11:11:10] ERROR:web-services:[08]: File "tools\convert.pyo", line 837, in convert_csv_import [Fri Jan 16 2009 11:11:10] ERROR:web-services:[09]: File "osv\orm.pyo", line 633, in import_data [Fri Jan 16 2009 11:11:10] ERROR:web-services:[10]: File "C:\Program Files\OpenERP AllInOne\Server\addons\base\ir\ir_model.py", line 488, in _update [Fri Jan 16 2009 11:11:10] ERROR:web-services:[11]: File "osv\orm.pyo", line 2384, in create [Fri Jan 16 2009 11:11:10] ERROR:web-services:[12]: File "sql_db.pyo", line 76, in wrapper [Fri Jan 16 2009 11:11:10] ERROR:web-services:[13]: File "sql_db.pyo", line 114, in execute [Fri Jan 16 2009 11:11:10] ERROR:web-services:[14]: IntegrityError: insert or update on table "order_history" violates foreign key constraint "order_history_partner_id_fkey" [Fri Jan 16 2009 11:11:10] ERROR:web-services:[15]: DETAIL: Key (partner_id)=(161932) is not present in table "res_partner". The referenced partner id (161932) is the id generated by OpenErp itself. Multiple tries give an other failing key partnerid each time. I assume the internal primary key simple gets incremented. When i encountered this issue before i increased the max_locks_per_transaction param in postgreSQL. Then i was able to upload my data. Now i have more data however and though i increased max_locks_per_transaction to 1024 and shared_buffers = 256MB in the postgreSQL configuration i still have the same problem. I assume the problem is because of the load of data (15 mb in total). Any idea how i can configure Openerp or postgreSQL so that i can import my data? Or perhaps there is another cause? The error message doesn't tell much. Thanks in advance. -------------------- m2f -------------------- -- http://www.openerp.com/forum/viewtopic.php?p=28587#28587 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
