Ad Widget

Collapse

Zabbix & Oracle database : can't print "Most busy triggers top 100" page

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • max
    Member
    • Jan 2008
    • 36

    #1

    Zabbix & Oracle database : can't print "Most busy triggers top 100" page

    Hey

    It seems the "Most busy triggers top 100" page is not compatible with Oracle database.

    See below :
    http://tof.canardplus.com/show/75fb1...1c5287161.html
    Attached Files
  • Aly
    ZABBIX developer
    • May 2007
    • 1126

    #2
    Tested on Oracle 10g no errors found on this screen.
    Zabbix | ex GUI developer

    Comment

    • max
      Member
      • Jan 2008
      • 36

      #3
      Error in the sql statement !

      Yep !

      If you look carefully at the statement, you will notice that the column t.description is written twice... which causes the error.



      Bye !

      Comment

      • Aly
        ZABBIX developer
        • May 2007
        • 1126

        #4
        It's been already fixed, that's why I haven't found it. Try latest code from svn on from the Nightly build.
        Zabbix | ex GUI developer

        Comment

        • max
          Member
          • Jan 2008
          • 36

          #5
          I'm wondering if the nightly build are done correctly because I've downloaded them and I still find the error whereas svn://svn.zabbix.com/trunk/frontends/php/report5.php is ok...

          Comment

          • Aly
            ZABBIX developer
            • May 2007
            • 1126

            #6
            Oops,my bad. I looked into beta release, when in 1.4.4 problem still persist. Now it's really fixed

            P.S. there are some more improvements for Oracle in SVN
            Zabbix | ex GUI developer

            Comment

            • max
              Member
              • Jan 2008
              • 36

              #7
              This error had NOT been corrected in the new 1.4.5 !

              Comment

              • Aly
                ZABBIX developer
                • May 2007
                • 1126

                #8
                1.4.5 release date is 25 March, 2008, fixed 26.03.2008...
                Zabbix | ex GUI developer

                Comment

                • max
                  Member
                  • Jan 2008
                  • 36

                  #9
                  correct...

                  Comment

                  Working...