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));
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.