The following error occurred when running the MySQL database resource creation script to create the XCOMTRST database
The problem is caused by the default character set on the MySQL server. It is possible that the MySQL server is using some Unicode character set, where each character is considered 4 bytes causing the length to exceed the 3072 bytes supported by the database.
Release : 11.6
Component : CA XCOM Data Transport for Linux PC
In order to resolve the problem, modify the following statement in the xcomtrstDB.sql file:
primary key (SYSNAME,SYSID,SYSTEM_NAME,GROUP_NAME,USER_NAME))
primary key (SYSNAME,SYSID,SYSTEM_NAME,GROUP_NAME,USER_NAME)) DEFAULT CHARSET=latin1 DATA DIRECTORY='path';