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

Email notifications sending failed with ORA-01460

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.2.1
    • Server (S)
    • Solaris 10 x64, Oracle Server 10.2.0.5 64bit

      Zabbix 2.2.1 cant send email notices when compiled and running with Oracle 10.2 database. This caused by "ORA-01460: unimplemented or unreasonable conversion requested" error while inserting alert information into ALERTS table:

       11516:20140120:112322.690 query [txnlev:1] [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,esc_step,alerttype) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)]
       11516:20140120:112322.691 [Z3007] query failed: [-1] ORA-01460: unimplemented or unreasonable conversion requested
      

      More debug data in attached zabbix_server.log

      This is the only one inserting error. All other inserts into other tables are fine.

            Unassigned Unassigned
            teen N.Vazhenin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: