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
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')
^
This is popping up while
creating any records.
SQL dump file did not have "AS INTEGER" while creating the sequences
Thanks
