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

Zabbix 2.0.0-rc2 upgrading Oracle errors

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Blocker
    • Resolution: Won't fix
    • 2.0.0rc2
    • None
    • Installation (I)
    • Oracle 11G

    Description

      Upgrading from Z 1.8.9 -> 2.0.0-rc2 yields

      ociexecute(): ORA-00942: table or view does not exist [include/db.inc.php:439]
      SQL error [ORA-00942: table or view does not exist] in [SELECT hin.* FROM host_inventory hin WHERE (hin.hostid IN ('80324')) ]
      ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:570]

      in any of the following menus,
      Monitoring,
      Dashboard | Overview | Web | Latest data | Triggers | Events

      the culprit was the CREATE TABLE host_inventory failing due to

      nvarchar2(2048) occurrences returning,

      ORA-00910: specified length too long for its datatype

      changing it to nvarchar2(1024) successfully created the table and cleared the errors.

      Attachments

        Issue Links

          Activity

            People

              dimir dimir
              zabbix_zen João Figueiredo
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: