[15->16] psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type timestamp: ""

[trvlprogrammer]

I have an error when migrating the db from 15 to 16. In this process, I am using openupgrade 16.0

odoo command run :
python odoo-bin -c ou_15_16.conf --database=buds_live_migrate --upgrade-path=D:\work\freelance\openupgrade\upenupgrade16\openupgrade_scripts\scripts --load=base,web,openupgrade_framework --update all --stop-after-init

ou_15_16.conf
[options]
db_host = localhost
db_port = 5432
db_user = odoo15
db_password = odoo15
addons_path = D:\work\freelance\odoo16\odoo\odoo\addons,D:\work\freelance\odoo16\odoo\addons,D:\work\freelance\odoo16\odoo\freelance\kaika\app\root\mnt\enterprise-addons,D:\work\freelance\odoo16\odoo\freelance\kaika\app\src,D:\work\freelance\odoo16\odoo\upenupgrade16\openupgrade_framework,D:\work\freelance\odoo16\odoo\upenupgrade16\openupgrade_scripts

and here is the error that I got when running that command

2023-04-05 02:57:33,202 12680 INFO buds_live_migrate odoo.modules.loading: Module iap loaded in 0.10s, 136 queries (+136 other)
2023-04-05 02:57:33,203 12680 INFO buds_live_migrate odoo.modules.loading: Loading module mail (24/148)
2023-04-05 02:57:33,278 12680 INFO buds_live_migrate odoo.modules.registry: module mail: creating or updating database tables
2023-04-05 02:57:44,790 12680 WARNING buds_live_migrate odoo.modules.loading: Transient module states were reset
2023-04-05 02:57:44,792 12680 ERROR buds_live_migrate odoo.modules.registry: Failed to load registry
2023-04-05 02:57:44,793 12680 CRITICAL buds_live_migrate odoo.service.server: Failed to initialize database buds_live_migrate.
Traceback (most recent call last):
File "D:\work\freelance\odoo16\odoo\odoo\service\server.py", line 1299, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "", line 2, in new
File "D:\work\freelance\odoo16\odoo\odoo\tools\func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "D:\work\freelance\odoo16\odoo\odoo\modules\registry.py", line 90, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "D:\work\freelance\odoo16\odoo\odoo\modules\loading.py", line 483, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "D:\work\freelance\odoo16\odoo\odoo\modules\loading.py", line 371, in load_marked_modules
loaded, processed = load_module_graph(
File "D:\work\freelance\odoo16\odoo\odoo\modules\loading.py", line 207, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "D:\work\freelance\odoo16\odoo\odoo\modules\registry.py", line 521, in init_models
model._auto_init()
File "D:\work\freelance\odoo16\odoo\odoo\models.py", line 2574, in _auto_init
new = field.update_db(self, columns)
File "D:\work\freelance\odoo16\odoo\odoo\fields.py", line 985, in update_db
self.update_db_column(model, column)
File "D:\work\freelance\odoo16\odoo\odoo\fields.py", line 1021, in update_db_column
self._convert_db_column(model, column)
File "D:\work\freelance\odoo16\odoo\odoo\fields.py", line 1025, in _convert_db_column
sql.convert_column(model._cr, model._table, self.name, self.column_type[1])
File "D:\work\freelance\odoo16\odoo\odoo\tools\sql.py", line 128, in convert_column
_convert_column(cr, tablename, columnname, columntype, using)
File "D:\work\freelance\odoo16\odoo\odoo\tools\sql.py", line 147, in _convert_column
cr.execute(query, log_exceptions=False)
File "D:\work\freelance\odoo16\odoo\odoo\sql_db.py", line 313, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type timestamp: ""

2023-04-05 02:57:44,796 12680 INFO buds_live_migrate odoo.service.server: Initiating shutdown
2023-04-05 02:57:44,796 12680 INFO buds_live_migrate odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2023-04-05 02:57:44,797 12680 INFO buds_live_migrate odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections

Any solution for this? I am new at the migration odoo database. Any advice really appreciates. Thanks.

Regards,
Fatih

[pedrobaeza]

There aren't still scripts for migrating mail module.

[aniol-roure]

Ì did:
UPDATE mail_mail SET scheduled_date = NULL WHERE scheduled_date = '';
and it worked (well it got stopped further away, but that is some other problem I'll have to investigate).
I dont know why the mail pre-migration did not work tho.

[pedrobaeza]

You should check, as maybe you are not executing cleanly the scripts.

[aniol-roure]

I'm running it using python 3.8 (checked requirentment.txt) with this config:
--addons-path=/home/vboxuser/Documents/odoo16/odoo/addons,/home/vboxuser/Documents/odoo16/odoo/custom-addons
--db-filter=test_db$
-c
/home/vboxuser/Documents/odoo16/odoo_local_nobom.conf
--update=all

and I droped openupgrade inside /home/vboxuser/Documents/odoo16/ so the scripts folder looks like this for example:
/home/vboxuser/Documents/odoo16/OpenUpgrade-16.0/openupgrade_scripts

Am I missing something?

[pedrobaeza]

I can't say, as there are a lot of variables. Check if there are traces in the log that migration scripts are being run.

[aniol-roure]

Yes, I think you where right and I wasn't full loading OpenUpgrade... My bad!
I was missing the --upgrade-path declaration as well as the path to the OpenUpgrade added in the --addons-path.
@pedrobaeza, thank you so much, that really helped!