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

Oracle SQL error while sending notifications

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 5.0.0beta1
    • 5.0.0beta2, 5.0 (plan)
    • Server (S)
    • None
    • Oracle 11.2
    • Team C
    • Sprint 63 (Apr 2020)
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: