MySql tables on Unix/Linux are case-sensitive

Products

• CA Process Automation Base

Issue/Introduction

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. 

Environment

Release: ITPASA99000-4.3-Process Automation-Add On License for-CA Server Automation
Component:

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