ERROR 1071 (42000) in upgrade CR09

Document ID : KB000116622
Last Modified Date : 01/10/2018
Show Technical Document Details
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".
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.
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.