[ZBX-11497] ODBC Returning strange value Created: 2016 Nov 17 Updated: 2017 May 30 Resolved: 2016 Nov 17 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | None |
| Affects Version/s: | 3.0.5, 3.2.1 |
| Fix Version/s: | None |
| Type: | Incident report | Priority: | Major |
| Reporter: | Gerhard Pegel | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| 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'. |
| Comments |
| Comment by Glebs Ivanovskis (Inactive) [ 2016 Nov 17 ] |
|
Closing as duplicate of |
| Comment by Gerhard Pegel [ 2016 Nov 17 ] |
|
Why is this already closed? That other one |
| Comment by richlv [ 2016 Nov 17 ] |
|
gpegel, as already discussed on irc, you could test a development version. this issue was closed because it is a duplicate. creating duplicate issues only wastes developer time, there is no benefit in keeping it open. please see http://zabbix.org/wiki/Getting_help for support options - if needed, consider the commercial support option, linked from that page |
| Comment by Glebs Ivanovskis (Inactive) [ 2016 Nov 17 ] |