Hello everyone,
Since the installation of Opsview, I had issues with scheduled reporting. It's been a couple of months, but I couldn't figure out what's wrong. It seems to be issue with java. I am currently running the following version of java which came with my Centos installation: [nag...@miau bin]$ java -version java version "1.6.0" OpenJDK Runtime Environment (build 1.6.0-b09) OpenJDK Client VM (build 1.6.0-b09, mixed mode) The error I get when running scheduled report script from cmd: [nag...@miau bin]$ ./run_opsview_report -N 99 -S 2010-03 -f miau.pdf -t generic_availability ODWReportLauncher starting... Using report id: '99' Loading config... 0 [main] DEBUG org.springframework.util.ClassUtils - Class [org.apache.commons.collections.map.CaseInsensitiveMap] or one of its dependencies is not present: java.lang.ClassNotFoundException: org.apache.commons.collections.map.CaseInsensitiveMap 2 [main] DEBUG org.springframework.util.ClassUtils - Class [edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap] or one of its dependencies is not present: java.lang.ClassNotFoundException: edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap 54 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [/usr/local/opsview-reports/types/generic_availability/Connections.xml] 74 [main] DEBUG org.springframework.beans.factory.xml.DefaultDocumentLoader - Using JAXP provider [org.apache.xerces.jaxp.DocumentBuilderFactoryImpl] 338 [main] DEBUG org.springframework.beans.factory.xml.BeansDtdResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath: spring-beans.dtd 374 [main] DEBUG org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReade r - Loading bean definitions 413 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'odwReportGenerator' as bean name and [] as aliases 434 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - Neither XML 'id' nor 'name' specified - using generated bean name [com.altinity.opsview.odw.bc.AvailabilityReportBC#3e0ebb] 436 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - Neither XML 'id' nor 'name' specified - using generated bean name [com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#1afae45] 439 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'reportDAO' as bean name and [] as aliases 440 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'daoDataSource' as bean name and [] as aliases 442 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'reportConfigDAO' as bean name and [] as aliases 443 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'configDaoDataSource' as bean name and [] as aliases Config loaded 448 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'odwReportGenerator' 450 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'odwReportGenerator' with merged definition [Root bean: class [com.altinity.opsview.odw.ODWReportGenerator]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 491 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'odwReportGenerator' to allow for resolving potential circular references 496 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'com.altinity.opsview.odw.bc.AvailabilityReportBC#3e0ebb' with merged definition [Root bean: class [com.altinity.opsview.odw.bc.AvailabilityReportBC]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 501 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'reportDAO' 502 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'reportDAO' with merged definition [Root bean: class [com.altinity.opsview.odw.dao.ODWReportDAO]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 514 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'reportDAO' to allow for resolving potential circular references 514 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'daoDataSource' 514 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'daoDataSource' with merged definition [Root bean: class [org.springframework.jdbc.datasource.DriverManagerDataSource]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 520 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'daoDataSource' to allow for resolving potential circular references 557 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: com.mysql.jdbc.Driver 574 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'reportConfigDAO' 574 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'reportConfigDAO' with merged definition [Root bean: class [com.altinity.opsview.odw.dao.ODWReportConfigDAO]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 576 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'reportConfigDAO' to allow for resolving potential circular references 576 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'configDaoDataSource' 576 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'configDaoDataSource' with merged definition [Root bean: class [org.springframework.jdbc.datasource.DriverManagerDataSource]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 576 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'configDaoDataSource' to allow for resolving potential circular references 577 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: com.mysql.jdbc.Driver 595 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#1afae45' with merged definition [Root bean: class [com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC]; scope=singleton; abstract=false; lazyInit=false; autowireCandidate=true; autowireMode=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [/usr/local/opsview-reports/types/generic_availability/Connections.xml]] 597 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportDAO' 597 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportConfigDAO' 602 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportConfigDAO' Generating ODW3 Report... 638 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 639 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [select type from reports where id = ?] 645 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 645 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/reports] 1128 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [99], value class [java.lang.Integer], SQL type unknown 1147 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(Dat aAccessUtils.java:71) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.quer yForObject(NamedParameterJdbcTemplate.java:144) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.quer yForObject(NamedParameterJdbcTemplate.java:148) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(S impleJdbcTemplate.java:158) at com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId( ODWReportConfigDAO.java:267) at com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGene rator.java:70) at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:6 0) Exception in thread "main" java.lang.RuntimeException: org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:6 8) Caused by: org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(Dat aAccessUtils.java:71) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.quer yForObject(NamedParameterJdbcTemplate.java:144) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.quer yForObject(NamedParameterJdbcTemplate.java:148) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(S impleJdbcTemplate.java:158) at com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId( ODWReportConfigDAO.java:267) at com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGene rator.java:70) at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:6 0) system() failed at ./run_opsview_report line 81. Anyone has any ideas? For those who scheduled reports are working, could you please share your java version? Thanks!!! Rimvydas Sneideris
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
