-
Problem report
-
Resolution: Fixed
-
Critical
-
5.4.3
-
None
-
Oracle 19.3
-
Sprint 79 (Aug 2021)
-
1
After automatical upgrade from 5.2 to 5.4.3 with Oracle DB as backend usage and converting remote commands to global scripts for actions no one action, related with script execution haven't working
No errors in frontend, no new records into actions log
escalations have creating, operations as well
Log info with debug log level for escalator processes
303668:20210811:154714.326 [Z3005] query failed: [-1] ORA-00932: inconsistent datatypes: expected - got NCLOB [select distinct h.hostid,h.proxy_hostid,h.host,s.type,s.scriptid,s.execute_on,s.port,s.authtype,s.username,s.password,s.publickey,s.privatekey,s.command,s.groupid,s.scope,s.timeout,s.name,h.tls_connect,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk from opcommand o,opcommand_hst oh,hosts h,scripts s where o.operationid=oh.operationid and o.scriptid=s.scriptid and oh.hostid=h.hostid and o.operationid=110 and h.status=0 union select distinct 0,0,null,s.type,s.scriptid,s.execute_on,s.port,s.authtype,s.username,s.password,s.publickey,s.privatekey,s.command,s.groupid,s.scope,s.timeout,s.name,1,0,2,null,null,null,null,null,null from opcommand o,opcommand_hst oh,scripts s where o.operationid=oh.operationid and o.scriptid=s.scriptid and o.operationid=110 and oh.hostid is null]
- duplicates
-
ZBX-19932 Zabbix Server - Oracle Error ORA-00932 with NCLOB columns and DISTINCT on alrts table
- Closed