Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17614

Oracle SQL error while sending notifications

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.0.0beta1
    • Fix Version/s: 5.0.0beta2, 5.0 (plan)
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Oracle 11.2
    • Team:
      Team C
    • Sprint:
      Sprint 63 (Apr 2020)
    • Story Points:
      0.5

      Description

      Steps to reproduce:

      1. add trigger action with problem notification
      2. configure media for addressee
      3. generate problem event

      Result:

      1. action failed with error message "No media defined for user."
      2. error in server log file
         10297:20200421:155448.713 [Z3005] query failed: [-1] ORA-00905: missing keyword [select mtm.subject,mtm.message,mt.mediatypeid from media_type mt left join (select mediatypeid,subject,message from media_type_message where eventsource=0 and recovery=0) as mtm on mt.mediatypeid=mtm.mediatypeid join (select distinct mediatypeid from media where userid=1) as m on mt.mediatypeid=m.mediatypeid]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              asestakovs Aleksejs Sestakovs
              Reporter:
              sasha Alexander Vladishev
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: