Zabbix 2.0.0-rc2 upgrading Oracle errors

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Blocker
    • None
    • Affects Version/s: 2.0.0rc2
    • Component/s: Installation (I)
    • Environment:
      Oracle 11G

      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.

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

              Created:
              Updated:
              Resolved: