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

Query error in retrive host info on Oracle 10.1.0.4.0 EE

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 2.0.3
    • Server (S)

      Errors found in zabbix server log:

      [Z3005] query failed: [-1] ORA-01425: escape character must be character string of length 1 [select host from hosts where host like 'servername.domain.net%' escape '!' and hostid between 0 and 99999999999999]

      escape character used is '!'

      Workaround used:
      1) if you use escaped character all works good (select host from hosts where host like 'servername.domain.net%' escape '!' and hostid between 0 and 99999999999999)
      2) if you set a logon trigger to set escape '!' all works good
      3) Problems is the same using sqlplus. Add " set escape '!' " in the glogin.sql fine and all works good

            Unassigned Unassigned
            yayo yayo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: