java.sql.SQLException error in portal-data

Document ID : KB000103864
Last Modified Date : 05/07/2018
Show Technical Document Details
Issue:
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.