java.sql.SQLException error in portal-data

Products

• CA API Developer Portal
• CA API Gateway

Issue/Introduction

In the portal_portal-data service log you receive this error:

java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

 

Environment

CA API Developer Portal 4.2.5.4
MySQL EE 5.7

Resolution

Add the line " log_bin_trust_function_creators=1" to the my.cnf under the mysqld section at the end of the file. This requires a restart of the MySQL service. Once this is completed, all databases should be created properly.