ERROR 1071 (42000) in upgrade CR09
search cancel

ERROR 1071 (42000) in upgrade CR09


Article ID: 116622


Updated On:


CA API Developer Portal CA API Gateway


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".


Component: APIPRD


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.