After migrating the API portal databases from one MySql server to another Mysql server using mysqldump .
The portal container are starting correctly after updating the portal.conf with the new MySql server details but nobody is able to login.
The pssg container log shows a error like :
WARNING]--[com.l7tech.server.jdbc.JdbcQueryingManagerImpl]-Failed to perform querying since FUNCTION portal.AES_DECRYPT_PORTAL does not exist
Release : 4.5
Component : API PORTAL
The Mysql dump did not include the option --routines to include any stored procedures and functions in the database backup.
Make sure the mysqldump is taken with the option -routines so the defined functions in the portal database are also migrated .