ispconfig migrator tool job failed due to pgsql

Hi,
I ran the migration tool from ispconfig3 to ispconfig3, all same packages source and target on Debian 12, but it failed due to pgsql database. dry run didn't give any error, migration failed. mariadb wordpress websites also didn't migrate. pgsql same version 18 installed on the target server as well.

Failed to create 3 mysql database users as well. created 5 users successfully including 1 pgsql user, failed 3 mysql users.
[8/8] <CRON> processing job
[ERROR] API call to sites_database_user_add failed. See log file for details.
[ERROR] API call to sites_database_user_add failed. See log file for details.
[ERROR] API call to sites_database_user_add failed. See log file for details.
[8/8] <DBUser> processing c7_another_database_username

Lastly..
ERROR 1049 (42000): Unknown database 'c5_pgsql_databasename'
ERROR 1049 (42000): Unknown database 'c5_pgsql_databasename'
mysqldump: Got error: 1049: "Unknown database 'c5_pgsql_databasename'" when selecting t he database
ERROR 1049 (42000): Unknown database 'c5_pgsql_databasename'
[ERROR] job failed. Stopping Sync!

Also noticed anomaly in Mailbox Quota
Source
Used space Quota
Email1 1 kB Unlimited
Email2 665 kB Unlimited
Email3 1 kB Unlimited

Target after failed migration
Used space Quota
Email1 2 kB Unlimited
Email2 457.02 MB Unlimited
Email3 26 kB Unlimited