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

Cannot view host groups prototypes in host prototype settings on template.

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 6.2.6
    • API (A)
    • None
    • Zabbix with ORACLE DB
    • Team C
    • Sprint 95 (Dec 2022)
    • 0.125

    Description

      Steps to reproduce:
      Open host prototype on some template with existing host group prototypes.
      There should be listed some host group prototypes which was added earlier.

      Result:
      See screenshot...

      Query

      SELECT gp.hostid,gp.name FROM group_prototype gp WHERE gp.hostid=82764 AND gp.name!='';
      

      is not fetch result. i.e. current host group prototypes.

      If you use this query it works for Oracle.

      SELECT gp.hostid,gp.name FROM ZABBIX.group_prototype gp WHERE gp.hostid=82764 AND gp.name IS NOT NULL
      

      MySQL and PostgreSQL works fine with original query.

      Expected:
      So host group prototypes should be loaded. properly

      Attachments

        1. 1.JPG
          1.JPG
          503 kB
        2. 2.JPG
          2.JPG
          113 kB

        Issue Links

          Activity

            People

              vmaksimovs Vladimirs Maksimovs
              neogan Andrei Gushchin
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: