polubothusatish

February 26, 2014

Thank You!!

February 24, 2014

im using the lastet vesersion 5.51

February 24, 2014

Hi,

I did pass in the url as this jdbc:hive://atlas-ch2-66.sys.comcast.net:10000/ but still getting the same error. Did I write it properly?

February 19, 2014

URL:

jdbc:hive://atlas-ch2-66.sys.comcast.net:10000/default (what is wrong with URL?)

Error:

net.sf.jasperreports.engine.JRException: java.lang.IllegalArgumentException: Bad URL format

at com.jaspersoft.connectors.hive.adapter.HiveDataAdapterService.test(HiveDataAdapterService.java:92)

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:163)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Caused by: java.lang.IllegalArgumentException: Bad URL format

at org.apache.hive.jdbc.Utils.parseURL(Utils.java:185)

at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:84)

at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at com.jaspersoft.connectors.hive.connection.HiveConnection.createConnection(HiveConnection.java:175)

at com.jaspersoft.connectors.hive.connection.HiveConnection.<init>(HiveConnection.java:81)

at com.jaspersoft.connectors.hive.adapter.HiveDataAdapterService.createConnection(HiveDataAdapterService.java:68)

at com.jaspersoft.connectors.hive.adapter.HiveDataAdapterService.test(HiveDataAdapterService.java:89)

... 2 more

November 8, 2013

I was able to figure out the solution. is your repository database running? Maybe the database that Tomcat is trying to connect to isn't running. Check the context.xml file for the jasperserver application, which contains the database connection information, and see if you can connect to the database via some other tool.

- if the database is running, maybe there's something else that blocking connections to the database - like a firewall, for instance. In which case you would have to allow traffic on the database port.

In my case it was not connection to the database properly.

November 7, 2013

Hi all,

I was unable to log in to jasper server and it is giving me a 404 HTTP Status, How can i degub this. When i checked the logs that major erros im getting are:

ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeSource' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'themeCache' while setting bean property 'themeCache';

FactoryBean which is currently in creation returned null from getObject

Nov 7, 2013 3:01:40 PM org.apache.catalina.loader.WebappClassLoader findResourceInternal

INFO: Illegal access: this web application instance has been stopped already. Could not load ehcache-version.properties. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.

Exception in thread "hibernate" java.lang.NullPointerException

at org.slf4j.impl.Log4jLoggerAdapter.debug(Log4jLoggerAdapter.java:209)

at net.sf.ehcache.util.UpdateChecker.checkForUpdate(UpdateChecker.java:63)

at net.sf.ehcache.util.UpdateChecker.run(UpdateChecker.java:51)

at java.util.TimerThread.mainLoop(Timer.java:512)

at java.util.TimerThread.run(Timer.java:462)

[root@thundercats logs]#

-- - - - -- - -- -- - - - -- - -- -- - - - -- - -- -- - - - -- - --

This is the actual log When i checked the logs, im get:

[root@thundercats app]# cd jasperreports-server-cp-5.1.0/

[root@thundercats jasperreports-server-cp-5.1.0]# ls

apache-ant docs postgresql Third-Party-Notices.pdf

apache-tomcat installation.log properties.ini uninstall

buildomatic java releaseNotes.txt uninstall.dat

common licenses samples

ctlscript.sh license.txt scripts

[root@thundercats jasperreports-server-cp-5.1.0]# cd

apache-ant/ installation.log releaseNotes.txt

apache-tomcat/ java/ samples/

buildomatic/ licenses/ scripts/

common/ license.txt Third-Party-Notices.pdf

ctlscript.sh postgresql/ uninstall

docs/ properties.ini uninstall.dat

[root@thundercats jasperreports-server-cp-5.1.0]# cd

apache-ant/ installation.log releaseNotes.txt

apache-tomcat/ java/ samples/

buildomatic/ licenses/ scripts/

common/ license.txt Third-Party-Notices.pdf

ctlscript.sh postgresql/ uninstall

docs/ properties.ini uninstall.dat

[root@thundercats jasperreports-server-cp-5.1.0]# cd apache-tomcat/

[root@thundercats apache-tomcat]# cd logs

[root@thundercats logs]# ls

catalina.2013-10-23.log host-manager.2013-10-23.log localhost.2013-11-07.log

catalina.2013-11-07.log host-manager.2013-11-07.log manager.2013-10-23.log

catalina.out localhost.2013-10-23.log manager.2013-11-07.log

[root@thundercats logs]# ls -alrt

total 508

drwxr-xr-x 10 root root 4096 Aug 12 18:37 ..

-rw-r--r-- 1 root root 0 Oct 23 17:55 manager.2013-10-23.log

-rw-r--r-- 1 root root 0 Oct 23 17:55 host-manager.2013-10-23.log

-rw-r--r-- 1 root root 157605 Oct 23 17:55 localhost.2013-10-23.log

-rw-r--r-- 1 root root 3793 Oct 23 17:55 catalina.2013-10-23.log

-rw-r--r-- 1 root root 0 Nov 7 15:01 manager.2013-11-07.log

-rw-r--r-- 1 root root 0 Nov 7 15:01 host-manager.2013-11-07.log

drwxr-xr-x 2 root root 4096 Nov 7 15:01 .

-rw-r--r-- 1 root root 157598 Nov 7 15:01 localhost.2013-11-07.log

-rw-r--r-- 1 root root 167318 Nov 7 15:01 catalina.out

-rw-r--r-- 1 root root 5219 Nov 7 15:01 catalina.2013-11-07.log

[root@thundercats logs]# date

Thu Nov 7 15:34:32 UTC 2013

[root@thundercats logs]# cat catalina.out

Oct 23, 2013 5:55:07 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /opt/app/jasperreports-server-cp-5.1.0/java/jre/lib/amd64/server:/opt/app/jasperreports-server-cp-5.1.0/java/jre/lib/amd64:/opt/app/jasperreports-server-cp-5.1.0/java/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib

Oct 23, 2013 5:55:07 PM org.apache.coyote.http11.Http11Protocol init

INFO: Initializing Coyote HTTP/1.1 on http-8080

Oct 23, 2013 5:55:07 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 334 ms

Oct 23, 2013 5:55:07 PM org.apache.catalina.core.StandardService start

INFO: Starting service Catalina

Oct 23, 2013 5:55:07 PM org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/6.0.26

Oct 23, 2013 5:55:07 PM org.apache.catalina.startup.HostConfig deployDescriptor

INFO: Deploying configuration descriptor host-manager.xml

Oct 23, 2013 5:55:07 PM org.apache.catalina.startup.HostConfig deployDescriptor

INFO: Deploying configuration descriptor manager.xml

Oct 23, 2013 5:55:07 PM org.apache.catalina.startup.HostConfig deployDescriptor

INFO: Deploying configuration descriptor jasperserver.xml

2013-10-23 17:55:13,940 ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

2013-10-23 17:55:16,100 ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

2013-10-23 17:55:16,101 ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

2013-10-23 17:55:16,154 ERROR ContextLoader,main:307 - Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeSource' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'themeCache' while setting bean property 'themeCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeCache' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'unsecureRepositoryService' while setting bean property 'repositoryService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'hibernateRepositoryListeners' while setting bean property 'repositoryListeners'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryListeners' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection

Related cause: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulerService' defined in ServletContext resource [/WEB-INF/applicationContext-web-services.xml]: Cannot resolve reference to bean 'reportSchedulerServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulerServiceImpl' defined in ServletContext resource [/WEB-INF/applicationContext-web-services.xml]: Cannot resolve reference to bean 'jobsService' while setting bean property 'jobsService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jobsService': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportJobsPersistenceService' while setting bean property 'persistenceService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportJobsPersistenceService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportJobSecurity' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'authenticationManager' while setting bean property 'authenticationManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authenticationManager' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Cannot resolve reference to bean 'daoAuthenticationProvider' while setting bean property 'providers' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoAuthenticationProvider' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Cannot resolve reference to bean 'userAuthorityService' while setting bean property 'userDetailsService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAuthorityService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCurrentlyInCreationException: Error creating bean with name 'sessionFactory': FactoryBean which is currently in creation returned null from getObject

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1097)

at org.springframework.ui.context.support.UiApplicationContextUtils.initThemeSource(UiApplicationContextUtils.java:58)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.onRefresh(AbstractRefreshableWebApplicationContext.java:179)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:458)

at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:519)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

at org.apache.catalina.startup.Catalina.start(Catalina.java:581)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeCache' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'unsecureRepositoryService' while setting bean property 'repositoryService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'hibernateRepositoryListeners' while setting bean property 'repositoryListeners'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryListeners' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection