Skip to Content
Menu
This question has been flagged
1 Reply
5521 Views

Hi, i was trying to import product with excel

but the google console throws this error

Server application error {"code":200,"message":"Odoo Server Error","data":{"exception_type":"internal_error","name":"psycopg2.InternalError","message":"current transaction is aborted, commands ignored until end of transaction block\n","arguments":["current transaction is aborted, commands ignored until end of transaction block\n"],"debug":"Traceback (most recent call last):\n File \"/odoo/odoo-server/odoo/http.py\", line 646, in _handle_exception\n return super(JsonRequest, self)._handle_exception(exception)\n File \"/odoo/odoo-server/odoo/http.py\", line 307, in _handle_exception\n raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])\n File \"/odoo/odoo-server/odoo/tools/pycompat.py\", line 87, in reraise\n raise value\n File \"/odoo/odoo-server/odoo/http.py\", line 683, in dispatch\n result = self._call_function(**self.params)\n File \"/odoo/odoo-server/odoo/http.py\", line 339, in _call_function\n return checked_call(self.db, *args, **kwargs)\n File \"/odoo/odoo-server/odoo/service/model.py\", line 97, in wrapper\n return f(dbname, *args, **kwargs)\n File \"/odoo/odoo-server/odoo/http.py\", line 332, in checked_call\n result = self.endpoint(*a, **kw)\n File \"/odoo/odoo-server/odoo/http.py\", line 927, in __call__\n return self.method(*args, **kw)\n File \"/odoo/odoo-server/odoo/http.py\", line 512, in response_wrap\n response = f(*args, **kw)\n File \"/odoo/odoo-server/addons/web/controllers/main.py\", line 920, in call_kw\n return self._call_kw(model, method, args, kwargs)\n File \"/odoo/odoo-server/addons/web/controllers/main.py\", line 912, in _call_kw\n return call_kw(request.env[model], method, args, kwargs)\n File \"/odoo/odoo-server/odoo/api.py\", line 689, in call_kw\n return call_kw_multi(method, model, args, kwargs)\n File \"/odoo/odoo-server/odoo/api.py\", line 680, in call_kw_multi\n result = method(recs, *args, **kwargs)\n File \"/odoo/odoo-server/addons/base_import/models/base_import.py\", line 671, in do\n import_result = model.load(import_fields, data)\n File \"/odoo/odoo-server/odoo/models.py\", line 768, in load\n for id, xid, record, info in converted:\n File \"/odoo/odoo-server/odoo/models.py\", line 932, in _convert_records\n converted = convert(record, functools.partial(_log, extras, stream.index))\n File \"/odoo/odoo-server/odoo/addons/base/ir/ir_fields.py\", line 79, in fn\n converted[field], ws = converters[field](value)\n File \"/odoo/odoo-server/odoo/addons/base/ir/ir_fields.py\", line 402, in _str_to_many2many\n id, _, ws = self.db_id_for(model, field, subfield, reference)\n File \"/odoo/odoo-server/odoo/addons/base/ir/ir_fields.py\", line 318, in db_id_for\n if RelatedModel.search([('id', '=', tentative_id)]):\n File \"/odoo/odoo-server/odoo/models.py\", line 1411, in search\n res = self._search(args, offset=offset, limit=limit, order=order, count=count)\n File \"/odoo/odoo-server/odoo/models.py\", line 3695, in _search\n self._cr.execute(query_str, where_clause_params)\n File \"/odoo/odoo-server/odoo/sql_db.py\", line 155, in wrapper\n return f(self, *args, **kwargs)\n File \"/odoo/odoo-server/odoo/sql_db.py\", line 232, in execute\n res = self._obj.execute(query, params)\npsycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block\n\n"}}


Pleae help

Avatar
Discard
Best Answer

Hi Vootipong, it looks like a PostgreSQL error that will usually occur during import of a large number of records.

Possible Cause: Using the odoo instance and doing updates at the same time while the imports are going on.

Possible Solution:
1. Use the IP address of the ODO instance instead of the domain name for doing imports. [EX: use 10.0.1.150:8090 instead of www.abcd.com]

2.Try to avoid use of the system until import get completed.

Avatar
Discard