ProgrammingError: relation "ir_sequence_031" does not exist

sequence postgresql9.2

2 Replies

4668 Views

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