While installing the Process Analytics database you get the following error: You do not have the SUPER privilege and binary logging is enabled
You are installing the Process Analytics database on a MySQL Database using Amazon Web Services RDS, and you do not have log_bin_trust_function_creators enabled.
Enable log_bin_trust_function_creators by following the explanations of the AWS Guide.
Problems Concerning TrxLogsETL
Problem
Possible Reason
Solution
The service throws the following error: [2013-11-15
09:46:45 +0100][0000000002][Error][External][SQLSM][3][Can not connect:
-1 "oci.dll: The specified module could not be found.
The Oracle Adapter preferences on the Scheer PASBRIDGE Bridge are not correct.
Check the Oracle Adapter preferences on the Preferences tab of the Scheer PASBRIDGE.
The service throws the following error: [2013-11-15
09:46:45 +0100][0000000002][Error][External][SQLSM][3][Can not connect:
-1 "libmySQL.dll: The specified module could not be found.
The MySQL Adapter preferences on the Scheer PASBRIDGE are not correct.
Check the MySQL Adapter preferences on the Preferences tab of the Scheer PASBRIDGE.
The service throws the following SQL error: [2014-01-10
10:14:17 +0100][0000000000][Error][Internal][BESM][12][SQLAPI dbms api
error while calling "Execute SQL" on "PSTATE": 1071 Specified key was
too long; max key length is 767 bytes.]
You ran into MySQL database limitations.
Make sure that you use MyISAM as your storage-engine with MySQL to avoid these limitations.