Oracle: Upgrade patch from 4.4 to 5.0.0alpha3 failure

XMLWordPrintable

    • Sprint 62 (Mar 2020)
    • 0.5

      Problem description: When attempting to upgrade an Oracle database from 4.4 to 5.0.0alpha3 (by running zabbix_server), the upgrade patch fails with the following error:

      23115:20200325:190059.976 query [txnlev:1] [alter table auditlog modify resourceid drop default]
23115:20200325:190100.062 [Z3005] query failed: [-1] ORA-00902: invalid datatype [alter table auditlog modify resourceid drop default]
23115:20200325:190100.062 query [alter table auditlog modify resourceid drop default] failed, setting transaction as failed
23115:20200325:190100.099 database upgrade failed

            Assignee:
            Aleksejs Sestakovs (Inactive)
            Reporter:
            Sergejs Olonkins
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: