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

ODBC Returning strange value

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.0.5, 3.2.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      I have 3 environments running with different versions of Zabbix. All 3 environments do have a couple of Database Monitoring items using ODBC to execute some queries on a Oracle Database.

      In version 3.0.4 this is working well and executing a SQL qeury gives me clear results.

      In version 3.0.5 and 3.2.1 it isn't working anymore. The zabbix_server.log says "error reason for "server1:db.odbc.select[ABORTED_JOBS,ORACLE_DATABASE]" changed: Received value [?g?*] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

      Why looks the 'received value' scrambled or fuzzy? Because when I start iSQL on the Zabbix Server and execute the same query than iSQL shows me the correct value. But Zabbix is returning this 'garbage'.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              GPegel Gerhard Pegel
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: