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

Reading from columns of 'NCLOB' data type not possible

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.8.4
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Server: ZABBIX 1.8.4 (Oracle Call Interface)
      Server Database: Oracle RDBMS 11.2.0.1
      OS: CentOS release 5.5
      PHP: 5.1.6-27.el5_5.3
      PHP OCI8-Module: 5.1.6-27.el5_5.3 with oracle-instantclient11.2-basic-11.2.0.2.0-1

      Description

      Every attempt by the GUI(PHP) to fetch data from 'NCLOB' columns fails with the following error message:

      OCI-Lob::load() [<a href='function.OCI-Lob-load'>function.OCI-Lob-load</a>]: ORA-24806: LOB form mismatch[/usr/share/zabbix/include/db.inc.php:626]

        Attachments

        1. 3693.patch
          0.6 kB
        2. 3693.patch.png
          3693.patch.png
          33 kB
        3. history_log-gui.png
          history_log-gui.png
          23 kB
        4. history_log-sqlplus.png
          history_log-sqlplus.png
          15 kB
        5. nls_database_parameters_2.txt
          1 kB
        6. nls_database_parameters.txt
          1 kB

          Issue Links

            Activity

              People

              • Assignee:
                sasha Alexander Vladishev
                Reporter:
                okkuv9xh Marc
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: