Actions operations haven't been working since upgrade from 5.2 to 5.4

XMLWordPrintable

    • Type: Problem report
    • Resolution: Fixed
    • Priority: Critical
    • 5.4.4rc1, 6.0.0alpha1, 6.0 (plan)
    • Affects Version/s: 5.4.3
    • Component/s: Server (S)
    • None
    • Environment:
      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]
      

       

            Assignee:
            Andris Zeila
            Reporter:
            Igor Gorbach (Inactive)
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: