"Database Monitor" item, Oracle Database, "SELECT COUNT
" query, unixODBC, Oracle Instantclient 12cR1, Red Hat Linux 6.8
[ZBX-11442] "Database Monitor" item, Oracle Database, "SELECT COUNT(*)" query, unixODBC, Oracle Instantclient 12cR1 Created: 2016 Nov 08 Updated: 2017 May 30 Resolved: 2016 Nov 09 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 3.2.1 |
| Fix Version/s: | None |
| Type: | Incident report | Priority: | Major |
| Reporter: | Marcus Oliveira | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | items | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
"Database Monitor" item, Oracle Database, "SELECT COUNT |
||
| Issue Links: |
|
||||||||
| Description |
|
"Database Monitor" item, Oracle Database, "SELECT COUNT(*)" query, unixODBC, Oracle Instantclient 12cR1 generates the error below : 70009:20161108:173829.349 error reason for "lab:db.odbc.select[oracle_database_number_of_active_users,{HOST.NAME}]" changed: Received value [x?x?<] is not suitable for value type [Numeric (unsigned)] and data type [Decimal] |
| Comments |
| Comment by richlv [ 2016 Nov 08 ] |
|
might be a duplicate of |
| Comment by Marcus Oliveira [ 2016 Nov 08 ] |
|
Thanks for the reply. Just noticed that any number coming from database receives similar error. 69784:20161108:174731.238 Item [lab:db.odbc.select[oracle_database_number_teste,{HOST.NAME}]] error: Received value [x?x?<] is not suitable for value type [Numeric (unsigned)] and data type [Decimal] Query : SELECT 1 FROM DUAL. |
| Comment by Marcus Oliveira [ 2016 Nov 08 ] |
|
More info : a number coming from database transformed using the "uptime" units, works. |
| Comment by Glebs Ivanovskis (Inactive) [ 2016 Nov 09 ] |
|
Closing as duplicate of |