[ZBX-11424] Zabbix error monitoring Oracle Database ODBC Created: 2016 Nov 04  Updated: 2017 May 30  Resolved: 2016 Nov 07

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 3.0.5
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Leandro Moreira Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Zabbix installed in debian 8 through packages, zabbix server database is postgresql in separate server, zabbix server and components was recently upgraded from version 3.0.4 to 3.0.5.


Issue Links:
Duplicate
duplicates ZBX-11213 DB Monitoring stopped working after u... Closed

 Description   

Dear good night!
Zabbix installed in debian 8 through packages, this week made the updated version of zabbix-server from version 3.0.4 to 3.0.5 version, made some queries on oracle databases and then this update some stopped working , queries like select * from dual; and select count (*) from dual; below is the log information:

 MOREIRA: db.odbc.select [dc, {} $ DSN] "Became not supported: Received value [? X] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

Log in DebugLevel = 4

1703: 20,161,103: 235330,712 In substitute_key_macros () date: 'db.odbc.select [dc, {$ DSN}]'
  1703: 20,161,103: 235330,712 End of substitute_key_macros (): SUCCEED date 'db.odbc.select [dc, moreira]'
  1703: 20,161,103: 235330,712 In get_value () key: 'db.odbc.select [dc, {$ DSN}]'
  1703: 20,161,103: 235330,712 In get_value_db () key_orig 'db.odbc.select [dc, {$ DSN}]'
  1703: 20,161,103: 235330,712 In db_odbc_select () query: 'select count (*) from dual;'
  1703: 20,161,103: 235338,053 End of db_odbc_select (): NOTSUPPORTED
  1703: 20,161,103: 235338,053 Item [MOREIRA: db.odbc.select [dc, {$ DSN}]] error: Received value [) k?] Is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
  1718: 20,161,103: 235338,517 item "MOREIRA: db.odbc.select [dc, {} $ DSN]" Became not supported: Received value [?) K] is not suitable for value type [Numeric (unsigned)] and data type [ Decimal]
  1705: 20,161,103: 235339,099 End of db_odbc_select (): SUCCEED

Other selects with eg table space consumption are operating normally, the same banks that select * from dual .; e.g. error

I thank you help.



 Comments   
Comment by richlv [ 2016 Nov 04 ]

could this be a duplicate of ZBX-11213 ?

Comment by Glebs Ivanovskis (Inactive) [ 2016 Nov 07 ]

Closing as duplicate.

Generated at Fri Apr 26 21:11:06 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.