ProgrammingError: relation "ir_sequence_031" does not exist

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

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Project
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

ProgrammingError: relation "ir_sequence_031" does not exist

sequence postgresql9.2

2 Trả lời

2771 Lượt xem

Sampath Kumar S

Hi,

I restored a OpenERP 7 db from PostgreSQL 9.2 from one system to another system on a PostgreSQL9.2. All the sequences are created properly but still getting the error as below

2021-04-05 08:29:23,904 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:23] "POST /web/menu/load_needaction HTTP/1.1" 200 -

2021-04-05 08:29:24,216 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:24] "POST /web/action/load HTTP/1.1" 200 -

2021-04-05 08:29:24,750 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:24] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:24,865 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:24] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:24,970 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:24] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:25,155 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:25] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:25,188 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:25] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:25,279 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:25] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:25,717 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:25] "POST /web/dataset/search_read HTTP/1.1" 200 -

2021-04-05 08:29:27,732 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:27] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:28,240 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:28] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:28,464 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:28] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:28,740 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:28] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:34,549 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:34] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:35,668 8044 INFO OPENERP7_DB werkzeug: 127.0.0.1 - - [05/Apr/2021 08:29:35] "POST /web/dataset/call_kw HTTP/1.1" 200 -

2021-04-05 08:29:37,237 8044 ERROR OPENERP7_DB openerp.sql_db: Programming error: relation "ir_sequence_031" does not exist

LINE 1: SELECT nextval('ir_sequence_031')

, in query SELECT nextval('ir_sequence_031')

2021-04-05 08:29:37,237 8044 ERROR OPENERP7_DB openerp.osv.osv: Uncaught exception

Traceback (most recent call last):

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\osv\osv.py", line 132, in wrapper

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\osv\osv.py", line 199, in execute

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\osv\osv.py", line 187, in execute_cr

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\stock\stock.py", line 636, in create

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\base\ir\ir_sequence.py", line 307, in get

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\base\ir\ir_sequence.py", line 299, in get_id

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\base\ir\ir_sequence.py", line 284, in next_by_code

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\account\ir_sequence.py", line 57, in _next

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\openerp\addons\base\ir\ir_sequence.py", line 249, in _next

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\sql_db.py", line 161, in wrapper

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\sql_db.py", line 226, in execute

ProgrammingError: relation "ir_sequence_031" does not exist

LINE 1: SELECT nextval('ir_sequence_031')

2021-04-05 08:29:37,239 8044 ERROR OPENERP7_DB openerp.netsvc: relation "ir_sequence_031" does not exist

LINE 1: SELECT nextval('ir_sequence_031')

Traceback (most recent call last):

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\netsvc.py", line 306, in dispatch_rpc

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\service\web_services.py", line 632, in dispatch

File "C:\Program Files (x86)\Openerp7.0\OpenERP 7.0-20170301\server\.\openerp\osv\osv.py", line 190, in execute_kw