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

Products

• CA API Developer Portal

Issue/Introduction

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

Environment

Release : 4.5

Component : API PORTAL

Resolution

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 .