Orabbix: no data

[tingtong5]

Hi all,

I have installed orabbix 1.2.3 on CentOS 6. The oracle database I am trying to monitor is version 11. However I do not get any data in my graphs in Zabbix. It seems that there is something wrong with loading the properties from query.props (see log file below).

Any ideas of what is going wrong here and how to troubleshoot/solve it?

2012-01-30 10:25:03,875 [main] DEBUG Orabbix - Loaded the properties from ./conf/query.props
 2012-01-30 10:25:03,877 [main] DEBUG Orabbix - Note: archive.NoDataFound null or not present null
 2012-01-30 10:25:03,877 [main] DEBUG Orabbix - Note: archive.WhenNotAlive null or not present null
 2012-01-30 10:25:03,877 [main] DEBUG Orabbix - Note: archive.Period null or not present null
 2012-01-30 10:25:03,877 [main] DEBUG Orabbix - Note: archive.ExcludeColumnsList error null
 2012-01-30 10:25:03,877 [main] DEBUG Orabbix - Note: archive.RaceConditionQueryExcludeColumnsList error null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.WhenNotAlive null or not present null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.RaceConditionQuery null or not present null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.RaceConditionValue null or not present null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.Period null or not present null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.ExcludeColumnsList error null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: audit.RaceConditionQueryExcludeColumnsList error null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: dbblockgets.NoDataFound null or not present null
 2012-01-30 10:25:03,879 [main] DEBUG Orabbix - Note: dbblockgets.WhenNotAlive null or not present null

Thanks!

Ronald

[sistemas.aquanima]

Same error with same config

None of the queries seems to work, Orabbix connect to server but all the logs shows queries error bad code related:

ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'dbversion'

Error while executing ->hitratio_body- on database ->DB1- Exception received Closed Connection

Error on DBEnquiry on query=hitratio_body on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_body'
2013-10-24 11:01:18,347 [pool-1-thread-1] WARN Orabbix - Error while executing ->hitratio_sqlarea- on database ->DB1- Exception received Closed Connection
2013-10-24 11:01:18,347 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=hitratio_sqlarea on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_sqlarea'
2013-10-24 11:01:18,347 [pool-1-thread-1] WARN Orabbix - Error while executing ->hitratio_table_proc- on database ->DB1- Exception received Closed Connection
2013-10-24 11:01:18,347 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=hitratio_table_proc on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_table_proc'
2013-10-24 11:01:18,347 [pool-1-thread-1] WARN Orabbix - Error while executing ->lio_current_read- on database ->DB1- Exception received Closed Connection
2013-10-24 11:01:18,347 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=lio_current_read on database=analysis Error returned is java.lang.IllegalArgumentException: null value for key 'lio_current_read'
2013-10-24 11:01:18,348 [pool-1-thread-1] WARN Orabbix - Error while executing ->locks- on database ->analysis- Exception received Closed Connection





java -version
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.11.90) (rhel-1.62.1.11.11.90.el6_4-x86_64)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)