MySql tables on Unix/Linux are case-sensitive

Document ID : KB000006078
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

This issue presents itself in the user interface with an error "An error has occurred on the server. Check the server log for details".  Checking the c2o.log in Process Automation shows errors similar to this:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'PAM.C2ORuntimeObjectsarch' doesn't exist 

Checking the database will show the table is there, but the case is different.

 

Cause:

With MySql on *nix platforms, the table names are case sensitive which causes these errors in Process Automation. 

Resolution:

There is a configuration parameter that can be added to my.cnf file.  Once added and the MySql service is restarted, PAM can then be installed on this MySql and build the table names as lower case without the problem. 

lower_case_table_names = 1