Symptoms
Service 'pem' does not start after management node migration to another node (despite service 'pau' is running ok). The following error in /var/log/poa.log:
Oct 18 23:39:21 corenode.org : Caused by: org.postgresql.util.PSQLException: ERROR: column localident1_.pwd_expired does not exist
Position: 216
Cause
Improper DB was restored.
The most probably, the similar migration has already taken place before.
When migration script runs it backs up OA database to /usr/local/pem/db_backup/plesk.dump and restores later.
But the script does not overwrite the file if it is already exists. In the current case the backup created during previous migration (which might have been performed years ago) was restored thus 'pem' service could not start - it did not find the necessary fields in restores DB tables.
Resolution
Re run the migration, having removed the obsolete file /usr/local/pem/db_backup/plesk.dump before.
Feature request #POA-111103 to improve described migration script disadvantage was placed.