ERROR 1071 (42000) in upgrade CR09

Document ID : KB000116622
Last Modified Date : 01/10/2018
Show Technical Document Details
Issue:
When trying to upgrade our CA Developer Portal from v3.5 CR00 to v3.5 CR09.
We have been following the instructions of the official guide. But we have a problem. When we execute the .sh file we receive this message in the prompt
"ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 1000 bytes".
 
Cause:
The key auditlog_path on the auditlog table is set to 1000 bytes and the switch to character set utf8mb4 and collation utf8mb4_unicode_ci required by the upgrade to Portal 3.5 CR9 is invalid.
 
Resolution:
Run the following 2 alter commands against the lrs DB.

alter table auditlog drop key auditlog_path; 
alter table auditlog add key auditlog_path (path(250)); 
 
Additional Information:
The auditlog_path is not used for any functionality and is safe to remove.
We will remove this key automatically in the next CR. 
Planned for inclusion in CR10.