Scoped Application Issue: Global "Delete" UI Action Error

[Logan Poynter]

I'm working on a scoped application and have run into an error message that I cannot find any ServiceNow specific documentation on, or let alone a cause. I have the Global "Delete" UI Action shown on my record - no override in place - and when clicked and confirmed, the record deletes but I am given the error message "(conn=21558) ALGORITHM=NOCOPY is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY"

The only documentation I can find relates to InnoDB (MariaDB)? When the delete action is performed, there is no logs recorded by the system. Anyone have some insight into this? 

[Community Alums]

Hi @Logan Poynter ,

This is how you can fix with the help of InnoDB Documentation : https://mariadb.com/kb/en/innodb-online-ddl-operations-with-the-inplace-alter-algorithm/

[Logan Poynter]

Thanks Sandeep for your reply, but my issue exists with OOB functionality in the platform (Global Delete UI Action). I'm not doing anything with InnoDB as part of my config so the documentation linked is unfortunately of no benefit. 

[Fumiya_F]

Hi Logan

It's been a long time, but were you able to solve the problem?

I found the cause and workaround for this.

[Jesse10]

I'm with this problem now. Can you help me?