Hi Peter,
The repair task was successful apart from the warning.
I went through the notes of
https://support.plesk.com/hc/en-us/articles/12377717512983 and fixed the db issues as well. Latest of repair details are as following:-
ubuntu@HOSTNAME:~$ sudo plesk installer update
Downloading file products.inf3: 0%
Downloading file products.inf3: 100% was finished.
Downloading file pool/PSA_18.0.52_11600/release.inf3: 0%
Downloading file pool/PSA_18.0.52_11600/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.51_11495/release.inf3: 0%
Downloading file pool/PSA_18.0.51_11495/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.50_11079/release.inf3: 0%
Downloading file pool/PSA_18.0.50_11079/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.49_10759/release.inf3: 0%
Downloading file pool/PSA_18.0.49_10759/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.48_10183/release.inf3: 0%
Downloading file pool/PSA_18.0.48_10183/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.47_10005/release.inf3: 0%
Downloading file pool/PSA_18.0.47_10005/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.46_9775/release.inf3: 0%
Downloading file pool/PSA_18.0.46_9775/release.inf3: 100% was finished.
Downloading file pool/PSA_18.0.45_9299/release.inf3: 0%
Downloading file pool/PSA_18.0.45_9299/release.inf3: 100% was finished.
Downloading file plesk.inf3: 0%
Downloading file plesk.inf3: 100% was finished.
Downloading file sitebuilder.inf3: 0%
Downloading file sitebuilder.inf3: 100% was finished.
Downloading file pool/WPB_18.0.51_64/release.inf3: 0%
Downloading file pool/WPB_18.0.51_64/release.inf3: 100% was finished.
Downloading file PHP82_17/release.inf3: 0%
Downloading file PHP82_17/release.inf3: 100% was finished.
Downloading file PHP81_17/release.inf3: 0%
Downloading file PHP81_17/release.inf3: 100% was finished.
Downloading file php81.inf3: 0%
Downloading file php81.inf3: 100% was finished.
Downloading file PHP80_17/release.inf3: 0%
Downloading file PHP80_17/release.inf3: 100% was finished.
Downloading file php80.inf3: 0%
Downloading file php80.inf3: 100% was finished.
Downloading file php72.inf3: 0%
Downloading file php72.inf3: 100% was finished.
Downloading file PHP74_17/release.inf3: 0%
Downloading file PHP74_17/release.inf3: 100% was finished.
Downloading file php74.inf3: 0%
Downloading file php74.inf3: 100% was finished.
Downloading file php73.inf3: 0%
Downloading file php73.inf3: 100% was finished.
Downloading file php71.inf3: 0%
Downloading file php71.inf3: 100% was finished.
Downloading file setemplates.inf3: 0%
Downloading file setemplates.inf3: 100% was finished.
Downloading file pp-sitebuilder.inf3: 0%
Downloading file pp-sitebuilder.inf3: 100% was finished.
Downloading file billing.inf3: 0%
Downloading file billing.inf3: 100% was finished.
Downloading file mysql.inf3: 0%
Downloading file mysql.inf3: 100% was finished.
Downloading file apache.inf3: 0%
Downloading file apache.inf3: 100% was finished.
Downloading file nginx.inf3: 0%
Downloading file nginx.inf3: 100% was finished.
Downloading file php70.inf3: 0%
Downloading file php70.inf3: 100% was finished.
Downloading file php56.inf3: 0%
Downloading file php56.inf3: 100% was finished.
Downloading file php55.inf3: 0%
Downloading file php55.inf3: 100% was finished.
Downloading file php54.inf3: 0%
Downloading file php54.inf3: 100% was finished.
Downloading file php53.inf3: 0%
Downloading file php53.inf3: 100% was finished.
Downloading file php52.inf3: 0%
Downloading file php52.inf3: 100% was finished.
Downloading file pmm.inf3: 0%
Downloading file pmm.inf3: 100% was finished.
Checking for installed packages...
Downloading file pool/PSA_18.0.51_11495/plesk-18.0.51-ubt22.04-x86_64.inf3: 0%
Downloading file pool/PSA_18.0.51_11495/plesk-18.0.51-ubt22.04-x86_64.inf3: 100% was finished.
Downloading file PHP74_17/php74-ubt22.04-x86_64.inf3: 0%
Downloading file PHP74_17/php74-ubt22.04-x86_64.inf3: 100% was finished.
Downloading file PHP80_17/php80-ubt22.04-x86_64.inf3: 0%
Downloading file PHP80_17/php80-ubt22.04-x86_64.inf3: 100% was finished.
Downloading file PHP81_17/php81-ubt22.04-x86_64.inf3: 0%
Downloading file PHP81_17/php81-ubt22.04-x86_64.inf3: 100% was finished.
Downloading file PHP82_17/php82-ubt22.04-x86_64.inf3: 0%
Downloading file PHP82_17/php82-ubt22.04-x86_64.inf3: 100% was finished.
Downloading file pool/WPB_18.0.51_64/sitebuilder-18.0.51-deball-all.inf3: 0%
Downloading file pool/WPB_18.0.51_64/sitebuilder-18.0.51-deball-all.inf3: 100% was finished.
Registering i386 architecture support
Synchronizing the Debian APT package index files...
Hit:1
Index of /ubuntu jammy InRelease
Get:2
Index of /ubuntu jammy-updates InRelease [119 kB]
Hit:3
Index of /pool/PSA_18.0.51_11495 jammy InRelease
Hit:4
Index of /KAV_8.5.1 jammy InRelease
Hit:5
Index of /PHP74_17 jammy InRelease
Get:6
Index of /ubuntu jammy-backports InRelease [108 kB]
Hit:7
Index of /PHP80_17 jammy InRelease
Hit:8
Index of /PHP81_17 jammy InRelease
Hit:9
Index of /PHP82_17 jammy InRelease
Hit:10
Index of /pool/WPB_18.0.51_64 all InRelease
Get:11
Index of /ubuntu jammy-security InRelease [110 kB]
Get:12
Index of /ubuntu jammy-updates/main i386 Packages [484 kB]
Get:13
Index of /ubuntu jammy-updates/main amd64 Packages [1062 kB]
Get:14
Index of /ubuntu jammy-updates/universe i386 Packages [609 kB]
Get:15
Index of /ubuntu jammy-updates/universe amd64 Packages [910 kB]
Fetched 3402 kB in 7s (490 kB/s)
Reading package lists...
Detecting installed product components.
Retrieving information about the installed license key...
You already have the latest version of product(s) and all the selected components installed. Installation will not continue.
----
However the original problem persists