java.sql.SQLException error in portal-data

Article Id: 103864

Status: Published

Updated On: 05-07-2018 16:19

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.