Hi, I a trying to generate reports but it does not work from Web UI (generating Adhoc report) and CLI. Opsview is "Build: 3.5.1.3761" and OS is a "Ubuntu 8.04.3 LTS" and java (as recommended) is at version 5. See below for java debug messages.
Do I overlook something? Is there someone having the same problem? bye, Karsten > java -versionjava version "1.5.0_20" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_20-b02) Java HotSpot(TM) Server VM (build 1.5.0_20-b02, mixed mode) > cd /usr/local/opsview-reports/types/generic_availability > java -jar ODWReportLauncher.jar -FConnections.xml -N3 -S2010-01 ODWReportLauncher starting... Using report id: '3' 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] 76 [main] DEBUG org.springframework.beans.factory.xml.DefaultDocumentLoader - Using JAXP provider [org.apache.xerces.jaxp.DocumentBuilderFactoryImpl] 343 [main] DEBUG org.springframework.beans.factory.xml.BeansDtdResolver - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath: spring-beans.dtd 390 [main] DEBUG org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader - Loading bean definitions 427 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'odwReportGenerator' as bean name and [] as aliases 444 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - Neither XML 'id' nor 'name' specified - using generated bean name [com.altinity.opsview.odw.bc.AvailabilityReportBC#9df6f1] 446 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - Neither XML 'id' nor 'name' specified - using generated bean name [com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#b8bef7] 449 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'reportDAO' as bean name and [] as aliases 450 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'daoDataSource' as bean name and [] as aliases 453 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'reportConfigDAO' as bean name and [] as aliases 453 [main] DEBUG org.springframework.beans.factory.xml.BeanDefinitionParserDelegate - No XML 'id' specified - using 'configDaoDataSource' as bean name and [] as aliases Config loaded 460 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'odwReportGenerator' 462 [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 495 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'com.altinity.opsview.odw.bc.AvailabilityReportBC#9df6f1' 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' 501 [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]] 510 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'reportDAO' to allow for resolving potential circular references 511 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'daoDataSource' 511 [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]] 517 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'daoDataSource' to allow for resolving potential circular references 542 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: com.mysql.jdbc.Driver 553 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'reportConfigDAO' 553 [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]] 554 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'reportConfigDAO' to allow for resolving potential circular references 554 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating shared instance of singleton bean 'configDaoDataSource' 555 [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]] 555 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Eagerly caching bean 'configDaoDataSource' to allow for resolving potential circular references 555 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: com.mysql.jdbc.Driver 569 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creating instance of bean 'com.altinity.opsview.odw.bc.WeeklyServiceAvailabilityReportBC#b8bef7' 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]] 570 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportDAO' 570 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportConfigDAO' 574 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Returning cached instance of singleton bean 'reportConfigDAO' Generating ODW3 Report... 612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 614 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [select type from reports where id = ?] 620 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 620 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/reports] org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:552) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:143) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:148) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:158) at com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId(ODWReportConfigDAO.java:267) at com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGenerator.java:70) at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:60) Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:283) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:271) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:255) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:236) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 10 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367) at java.net.Socket.connect(Socket.java:524) at java.net.Socket.connect(Socket.java:474) at java.net.Socket.<init>(Socket.java:371) at java.net.Socket.<init>(Socket.java:213) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027) ... 21 more Exception in thread "main" java.lang.RuntimeException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:68) Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:552) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:143) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:148) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:158) at com.altinity.opsview.odw.dao.ODWReportConfigDAO.getReportTypeByReportId(ODWReportConfigDAO.java:267) at com.altinity.opsview.odw.ODWReportGenerator.generateReport(ODWReportGenerator.java:70) at com.altinity.opsview.odw.ODWReportLauncher.main(ODWReportLauncher.java:60) Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:283) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:271) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:255) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:236) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 10 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367) at java.net.Socket.connect(Socket.java:524) at java.net.Socket.connect(Socket.java:474) at java.net.Socket.<init>(Socket.java:371) at java.net.Socket.<init>(Socket.java:213) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027) ... 21 more
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
