Skip to Content
Odoo Menú
  • Registra entrada
  • Prova-ho gratis
  • Aplicacions
    Finances
    • Comptabilitat
    • Facturació
    • Despeses
    • Full de càlcul (IA)
    • Documents
    • Signatura
    Vendes
    • CRM
    • Vendes
    • Punt de venda per a botigues
    • Punt de venda per a restaurants
    • Subscripcions
    • Lloguer
    Imatges de llocs web
    • Creació de llocs web
    • Comerç electrònic
    • Blog
    • Fòrum
    • Xat en directe
    • Aprenentatge en línia
    Cadena de subministrament
    • Inventari
    • Fabricació
    • PLM
    • Compres
    • Manteniment
    • Qualitat
    Recursos humans
    • Empleats
    • Reclutament
    • Absències
    • Avaluacions
    • Recomanacions
    • Flota
    Màrqueting
    • Màrqueting Social
    • Màrqueting per correu electrònic
    • Màrqueting per SMS
    • Esdeveniments
    • Automatització del màrqueting
    • Enquestes
    Serveis
    • Projectes
    • Fulls d'hores
    • Servei de camp
    • Suport
    • Planificació
    • Cites
    Productivitat
    • Converses
    • Validacions
    • IoT
    • VoIP
    • Coneixements
    • WhatsApp
    Aplicacions de tercers Odoo Studio Plataforma d'Odoo al núvol
  • Sectors
    Comerç al detall
    • Llibreria
    • Botiga de roba
    • Botiga de mobles
    • Botiga d'ultramarins
    • Ferreteria
    • Botiga de joguines
    Food & Hospitality
    • Bar i pub
    • Restaurant
    • Menjar ràpid
    • Guest House
    • Distribuïdor de begudes
    • Hotel
    Immobiliari
    • Agència immobiliària
    • Estudi d'arquitectura
    • Construcció
    • Gestió immobiliària
    • Jardineria
    • Associació de propietaris de béns immobles
    Consultoria
    • Empresa comptable
    • Partner d'Odoo
    • Agència de màrqueting
    • Bufet d'advocats
    • Captació de talent
    • Auditoria i certificació
    Fabricació
    • Textile
    • Metal
    • Mobles
    • Menjar
    • Brewery
    • Regals corporatius
    Salut i fitness
    • Club d'esport
    • Òptica
    • Centre de fitness
    • Especialistes en benestar
    • Farmàcia
    • Perruqueria
    Trades
    • Servei de manteniment
    • Hardware i suport informàtic
    • Sistemes d'energia solar
    • Shoe Maker
    • Serveis de neteja
    • Instal·lacions HVAC
    Altres
    • Nonprofit Organization
    • Agència del medi ambient
    • Lloguer de panells publicitaris
    • Fotografia
    • Lloguer de bicicletes
    • Distribuïdors de programari
    Browse all Industries
  • Comunitat
    Aprèn
    • Tutorials
    • Documentació
    • Certificacions
    • Formació
    • Blog
    • Pòdcast
    Potenciar l'educació
    • Programa educatiu
    • Scale-Up! El joc empresarial
    • Visita Odoo
    Obtindre el programari
    • Descarregar
    • Comparar edicions
    • Novetats de les versions
    Col·laborar
    • GitHub
    • Fòrum
    • Esdeveniments
    • Traduccions
    • Converteix-te en partner
    • Services for Partners
    • Registra la teva empresa comptable
    Obtindre els serveis
    • Troba un partner
    • Troba un comptable
    • Contacta amb un expert
    • Serveis d'implementació
    • Referències del client
    • Suport
    • Actualitzacions
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Programar una demo
  • Preus
  • Ajuda

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Comptabilitat
  • Inventari
  • PoS
  • Projectes
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
Ajuda

Prodcut Import: Odoo Server Error | Exception during JSON request handling | No Such Savepoint

Subscriure's

Get notified when there's activity on this post

This question has been flagged
enterpriseversion10
2 Respostes
7978 Vistes
Avatar
Brandon Goblirsch

When trying to import a csv of updated product quantities and cost, Odoo process for about 30 seconds, then just says, "Odoo Server Error." 

This is what I'm trying to import (I'm ignoring all columns except "ID", "supplier_integration_ids/available_quantity", and "supplier_integration_ids/cost_value"):

id,supplier_integration_ids/id,supplier_integration_ids/product,supplier_integration_ids/nts_supplier_id,supplier_integration_ids/available_quantity,supplier_integration_ids/cost_value,default_c
tire.DRT396,__export__.nts_supplier_integration_10032,DRT396,Twin Valley,1,279,DRT396
tire.DRT316,__export__.nts_supplier_integration_10051,DRT316,Twin Valley,2,444,DRT316
tire.DRT362,__export__.nts_supplier_integration_10044,DRT362,Twin Valley,2,380,DRT362
tire.TRD278GY,__export__.nts_supplier_integration_10449,TRD278,Twin Valley,2,111,TRD278
tire.TRR335GY,__export__.nts_supplier_integration_10002,TRR335GY,Twin Valley,2,81,TRR335GY
tire.TRR230,__export__.nts_supplier_integration_10450,TRR230,Twin Valley,4,85,TRR230
tire.4LT317GY,__export__.nts_supplier_integration_10014,4LT317GY,Twin Valley,6,156,4LT317GY
tire.DRT351,__export__.nts_supplier_integration_10439,DRT351,Twin Valley,6,516,DRT351
tire.DRT395,__export__.nts_supplier_integration_10026,DRT395,Twin Valley,6,223,DRT395
tire.TRD395,__export__.nts_supplier_integration_10023,TRD395,Twin Valley,6,200,TRD395
tire.44R295,__export__.nts_supplier_integration_10361,44R295,Twin Valley,8,207,44R295
tire.DRT398,__export__.nts_supplier_integration_10015,DRT398,Twin Valley,10,159,DRT398
tire.TRD398,__export__.nts_supplier_integration_10017,TRD398,Twin Valley,10,161,TRD398
tire.DRT389,__export__.nts_supplier_integration_10440,DRT389,Twin Valley,20,316,DRT389

This is the server log:

Traceback (most recent call last):

File "/opt/odoo/odoo_10/odoo/addons/base/ir/ir_attachment.py", line 100, in _file_read
r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/.local/share/Odoo/filestore/05_2019/1b/1bdd2f86352db984b4bbd34c8e1e43071019aced'
2019-06-19 17:58:24,880 6587 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:24,880 6587 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:24,880 6587 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:24,880 6587 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:24,924 6587 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:27,448 6590 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:27,485 6590 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:27,485 6590 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:27,485 6590 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:27,508 6590 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:27,979 8085 INFO 05_2019 odoo.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/.local/share/Odoo/filestore/05_2019/96/96cc6c89a2539bb3e3b08bbbc08c9cb0180984a9
Traceback (most recent call last):
File "/opt/odoo/odoo_10/odoo/addons/base/ir/ir_attachment.py", line 100, in _file_read
r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/.local/share/Odoo/filestore/05_2019/96/96cc6c89a2539bb3e3b08bbbc08c9cb0180984a9'
2019-06-19 17:58:30,006 6593 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:30,006 6593 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:30,006 6593 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:30,006 6593 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:30,029 6593 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:32,713 6596 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:32,713 6596 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:32,731 6596 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:32,731 6596 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:32,792 6596 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:33,888 8087 INFO 05_2019 odoo.addons.nts_kmtire.models.nts_kmtire: 2081 - 15120
2019-06-19 17:58:34,194 8085 INFO 05_2019 odoo.sql_db: bad query: RELEASE SAVEPOINT model_load_save
2019-06-19 17:58:34,195 8085 INFO 05_2019 odoo.sql_db: bad query: ROLLBACK TO SAVEPOINT model_load_save
2019-06-19 17:58:34,195 8085 ERROR 05_2019 odoo.http: Exception during JSON request handling.
Traceback (most recent call last):
File "/opt/odoo/odoo_10/odoo/http.py", line 642, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/nts-internal/newrelic/__init__.py", line 63, in _handle_exception
return wrapped(*args, **kwargs)
File "/opt/odoo/odoo_10/odoo/http.py", line 684, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo/odoo_10/odoo/http.py", line 334, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/service/model.py", line 101, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/http.py", line 327, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo/odoo_10/odoo/http.py", line 942, in __call__
return self.method(*args, **kw)
File "/opt/odoo/odoo_10/odoo/http.py", line 507, in response_wrap
response = f(*args, **kw)
File "/opt/odoo/odoo_10/addons/web/controllers/main.py", line 892, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/opt/odoo/odoo_10/addons/web/controllers/main.py", line 884, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo/odoo_10/odoo/api.py", line 689, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/opt/odoo/odoo_10/odoo/api.py", line 680, in call_kw_multi
result = method(recs, *args, **kwargs)
File "/opt/odoo/enterprise/addons/account_bank_statement_import_csv/wizard/account_bank_statement_import_csv.py", line 159, in do
return super(AccountBankStmtImportCSV, self).do(fields, options, dryrun=dryrun)
File "/opt/odoo/odoo_10/addons/base_import/models/base_import.py", line 690, in do
import_result = model.load(import_fields, data)
File "/opt/odoo/odoo_10/odoo/models.py", line 894, in load
cr.execute('ROLLBACK TO SAVEPOINT model_load_save')
File "/opt/odoo/odoo_10/odoo/sql_db.py", line 154, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/sql_db.py", line 231, in execute
res = self._obj.execute(query, params)
File "/usr/local/lib/python2.7/dist-packages/newrelic-2.78.0.57/newrelic/hooks/database_dbapi2.py", line 22, in execute
*args, **kwargs)
InternalError: no such savepoint

0
Avatar
Descartar
Paresh Wagh

Are you using New Relic for monitoring ? One of the New Relic scripts seems to be triggering the error.

Looking here may provide a clue:

"/usr/local/lib/python2.7/dist-packages/newrelic-2.78.0.57/newrelic/hooks/database_dbapi2.py", line 22

Khue Pham

Yeah, that's right, I'm using new relic

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrar-se
Related Posts Respostes Vistes Activitat
Create customer users without incurring enterprise fees for all
enterprise
Avatar
Avatar
1
d’abr. 23
5590
why would Odoo 14 enterprise server reboot every 5 - 10 minutes ?.
enterprise
Avatar
0
de juny 21
2431
Problem during installation of module that affected another module
version10
Avatar
Avatar
1
de gen. 20
4517
Odoo Warning - Validation Error
version10
Avatar
Avatar
2
de gen. 20
4393
How to access new version of Odoo studio Solved
enterprise
Avatar
Avatar
1
de març 17
8833
Community
  • Tutorials
  • Documentació
  • Fòrum
Codi obert
  • Descarregar
  • GitHub
  • Runbot
  • Traduccions
Serveis
  • Allotjament a Odoo.sh
  • Suport
  • Actualització
  • Desenvolupaments personalitzats
  • Educació
  • Troba un comptable
  • Troba un partner
  • Converteix-te en partner
Sobre nosaltres
  • La nostra empresa
  • Actius de marca
  • Contacta amb nosaltres
  • Llocs de treball
  • Esdeveniments
  • Pòdcast
  • Blog
  • Clients
  • Informació legal • Privacitat
  • Seguretat
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo és un conjunt d'aplicacions empresarials de codi obert que cobreix totes les necessitats de la teva empresa: CRM, comerç electrònic, comptabilitat, inventari, punt de venda, gestió de projectes, etc.

La proposta única de valor d'Odoo és ser molt fàcil d'utilitzar i estar totalment integrat, ambdues alhora.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now