You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Installation Problems

ProblemPossible ReasonSolution

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

ProblemPossible ReasonSolution

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 PAS BRIDGE Bridge are not correct.

Check the Oracle Adapter preferences on the Preferences tab of the Scheer PAS BRIDGE.

For more information on how to configure database access to an Oracle database, refer to the Scheer PAS BRIDGE Documentation > Installing and Configuring Database Access for Oracle.

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 PAS BRIDGE are not correct.

Check the MySQL Adapter preferences on the Preferences tab of the Scheer PAS BRIDGE.

For more information on how to configure database access to a MySQL database, refer to Scheer PAS BRIDGE Documentation > Installing and Configuring Database Access for MySQL.

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.


Related Documentation:

  • No labels