MySql tables on Unix/Linux are case-sensitive

Article Id: 6078

Status: Published

Updated On: 14-02-2018 08:10

Legacy Id: TEC1626705

Products:

CA Process Automation Base , 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