Steps to reproduce:

1. Create a test action with multiple steps (1-1, 2-2, 3-3)
2. Trigger some trigger
3. After first step, disable the trigger

Result:

An error in zabbix_server.log: 

1965:20211122:164551.611 [Z3005] query failed: [-1] ORA-00932: inconsistent datatypes: expected - got NCLOB [select distinct userid,mediatypeid,subject,message,esc_step from alerts where actionid=267 and mediatypeid is not null and alerttype=0 and acknowledgeid is null and eventid=33214 order by userid,mediatypeid,esc_step desc]

Expected:
Zabbix should send a message about cancelled escalation

Additional information:

I have this problem in 5.0.17 after upgrading from 5.0.10.

I tracked down query error to this code: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/zabbix_server/escalator/escalator.c?until=73f2457e27657bcd73bf433b819d0b23633d4424&untilPath=src%2Fzabbix_server%2Fescalator%2Fescalator.c&at=refs%2Fheads%2Frelease%2F5.0#715-724

It's probably introduced by "ZBX-18912 fixed escalation message is using template message instead of custom message in actions"