Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-4767

Cannot upgrade Oracle instalation to 2.8

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • None
    • 2.8 CR1
    • System
    • None
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • 3scale 2020-03-09, 3scale 2020-03-23

      When you upgrade templated based Oracle installation the system-sphinx will fail with this error:

      indexing index 'account_delta'...
ERROR: index 'account_delta': sql_query_range: : range-query failed: [Oracle][ODBC][Ora]ORA-30076: invalid extract field for extract source
 (DSN=odbc://dballo02:***@oracle-12cr2-cdb.mwqe.upshift.rdu2.redhat.com:1521/pdb1).

      I have used this documentation for the whole process https://gitlab.cee.redhat.com/red-hat-3scale-documentation/3scale-documentation/merge_requests/258

      EDIT: It fails with both templates and operator upgrade

        1. system-sphinx-4-nt59x.log
          16 kB

              Unassigned Unassigned
              phala@redhat.com Petr Hála (Inactive)
              Hery Ramihajamalala Hery Ramihajamalala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: