search cancel

Unable to logon to API Portal after migrating MySql databases to another server.


Article ID: 212164


Updated On:


CA API Developer Portal


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]-[157]-[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 .