alain_vu

Hello, I have tried changing the parameters to type java.sql.Date but that doesn't work either. when parameter is java.util.Date, the errormessage is: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $5 when parameter is java.sql.Date, the errormessage is the same (the jasperstudio tool let's me select a date on a calendar but displays the result as '1/1/13' and '1/31/13' whilst I would expect something like '2013-1-1' and '2013-1-31' ?) Thanks for helping me out here...

Hello, I have tried changing the parameters to type java.sql.Date but that doesn't work either. when parameter is java.util.Date, the errormessage is: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $5 when parameter is java.sql.Date, the errormessage is the same (the jasperstudio tool let's me select a date on a calendar but displays the result as '1/1/13' and '1/31/13' whilst I would expect something like '2013-1-1' and '2013-1-31' ?) Thanks for helping me out here...

in the WHERE- clause of my select I have: and ( ( $P{startdat} IS NULL and $P{einddat} IS NULL ) or ( NOT($P{startdat} IS NULL) and $P{einddat} IS NULL and account_period.date_start >= $P{startdat} ) or ( NOT($P{startdat} IS NULL) and NOT($P{einddat} IS NULL) and account_period.date_start >= $P{startdat} and account_period.date_stop <= $P{einddat} ) ) account_period.date_start and _stop are of the type java.sql.Date parameters startdat and einddat are of the type java.util.Date executing the sql gives an error because these 2 types can't be compared, how should this situation be handled? Many thanks in advance for any help. Alain

Has this been solved? I have the exact same problem....

Hello, I installed jasperserver 5.5 (clean install from jasperreports-server-cp-5.5.0-linux-x64-installer.run) - selected bundled tomcat but existing postgresql install ran fine and jasperserver started at the end of the installation process and I could log in and run sample programs. after stopping and starting jasperserver, I can no longer log in (I get the loginscreen but nothing happens when I click the login button). CATALINA.out shows following errors: Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol pause INFO: Pausing ProtocolHandler ["http-bio-8080"] Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol pause INFO: Pausing ProtocolHandler ["ajp-bio-8009"] Nov 25, 2013 10:30:44 AM org.apache.catalina.core.StandardService stopInternal INFO: Stopping service Catalina Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-2] but has failed to stop it. This is very likely to create a memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [CascadeCacheCleaner] but has failed to stop it. This is very likely to create a memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@370722e3]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@3583814e]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@4c9e4354]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@2a566718]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@e8a6e5f]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@2254266e]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@42a7115d]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@666512da]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@75b8daba]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1] (value [com.jaspersoft.jasperserver.api.logging.context.impl.BasicLoggingContextProvider$1@5f720679]) and a value of type [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl] (value [com.jaspersoft.jasperserver.api.logging.context.impl.LoggingContextImpl@3b2025b7]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol stop INFO: Stopping ProtocolHandler ["http-bio-8080"] Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol stop INFO: Stopping ProtocolHandler ["ajp-bio-8009"] Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol destroy INFO: Destroying ProtocolHandler ["http-bio-8080"] Nov 25, 2013 10:30:44 AM org.apache.coyote.AbstractProtocol destroy INFO: Destroying ProtocolHandler ["ajp-bio-8009"] Nov 25, 2013 10:38:33 AM 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: /usr/local/pgsql/lib:/opt/jasperreports-server-cp-5.5.0/common/lib::/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib Nov 25, 2013 10:38:34 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["http-bio-8080"] Nov 25, 2013 10:38:34 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["ajp-bio-8009"] Nov 25, 2013 10:38:34 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 1857 ms Nov 25, 2013 10:38:34 AM org.apache.catalina.core.StandardService startInternal INFO: Starting service Catalina Nov 25, 2013 10:38:34 AM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/7.0.42 Nov 25, 2013 10:38:35 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory /opt/jasperreports-server-cp-5.5.0/apache-tomcat/webapps/manager Nov 25, 2013 10:38:35 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory /opt/jasperreports-server-cp-5.5.0/apache-tomcat/webapps/ROOT Nov 25, 2013 10:38:35 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory /opt/jasperreports-server-cp-5.5.0/apache-tomcat/webapps/jasperserver Nov 25, 2013 10:38:54 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.tonbeller.com/jpivot/core is already defined Nov 25, 2013 10:38:54 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined Nov 25, 2013 10:38:54 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined Creating ActionModelService object. Creating action model infrastructure. 2013-11-25 10:39:10,719 ERROR JNDIResourceProvider,localhost-startStop-1:75 - error closing context javax.naming.OperationNotSupportedException: Context is read only at org.apache.naming.NamingContext.checkWritable(NamingContext.java:962) at org.apache.naming.NamingContext.close(NamingContext.java:762) at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72) at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56) at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163) at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92) at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89) at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1113) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1671) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.servlet.SpringServlet getContext INFO: Using default applicationContext Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, scopedTarget.hypermediaRootDocumentJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.root.service.HypermediaRootDocumentJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, hypermediaRootDocumentJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.root.service.HypermediaRootDocumentJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, scopedTarget.hypermediaUserWorkflowJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.workflow.service.HypermediaUserWorkflowJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, hypermediaUserWorkflowJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.workflow.service.HypermediaUserWorkflowJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, scopedTarget.hypermediaContentReferenceJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.content.service.HypermediaContentReferenceJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, hypermediaContentReferenceJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.content.service.HypermediaContentReferenceJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, scopedTarget.hypermediaResourceLookupService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.resource.service.HypermediaResourceLookupService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, hypermediaResourceLookupService, of type com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.resource.service.HypermediaResourceLookupService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, jobsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.job.JobsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, runReportsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.report.RunReportsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, reportExecutionsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.report.ReportExecutionsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, inputControlsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, repositoryJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.resources.RepositoryJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, importJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.importexport.ImportJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, exportJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.importexport.ExportJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, repositoryPermissionsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.permission.RepositoryPermissionsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, genericParamExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.GenericParamExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, resourceNotFoundExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.ResourceNotFoundExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, accessDeniedExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.AccessDeniedExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, genericRemoteExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.GenericRemoteExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, springSecurityAccessDeniedExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.SpringSecurityAccessDeniedExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, genericExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.GenericExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, JSValidationExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.JSValidationExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, dataIntegrityViolationExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.DataIntegrityViolationExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, jsonMappingExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.JsonMappingExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, updateConflictExceptionMapper, of type com.jaspersoft.jasperserver.jaxrs.common.UpdateConflictExceptionMapper as a provider class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, connectionsJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.connection.ConnectionsJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, rolesJaxrsServiceWrapper, of type com.jaspersoft.jasperserver.jaxrs.authority.RolesJaxrsServiceWrapper as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, usersJaxrsServiceWrapper, of type com.jaspersoft.jasperserver.jaxrs.authority.UsersJaxrsServiceWrapper as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, localizationBundleJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.bundle.LocalizationBundleJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.spi.spring.container.SpringComponentProviderFactory registerSpringBeans INFO: Registering Spring bean, serverInfoJaxrsService, of type com.jaspersoft.jasperserver.jaxrs.serverInfo.ServerInfoJaxrsService as a root resource class Nov 25, 2013 10:39:11 AM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate INFO: Initiating Jersey application, version 'Jersey: 1.13-b01 03/09/2012 03:52 PM' Nov 25, 2013 10:39:11 AM com.sun.jersey.api.wadl.config.WadlGeneratorLoader loadWadlGenerator INFO: Loading wadlGenerator com.jaspersoft.jasperserver.jaxrs.wadl.PrivateFilteringWadlGenerator Nov 25, 2013 10:39:13 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory /opt/jasperreports-server-cp-5.5.0/apache-tomcat/webapps/host-manager Nov 25, 2013 10:39:14 AM org.apache.coyote.AbstractProtocol start INFO: Starting ProtocolHandler ["http-bio-8080"] Nov 25, 2013 10:39:14 AM org.apache.coyote.AbstractProtocol start INFO: Starting ProtocolHandler ["ajp-bio-8009"] Nov 25, 2013 10:39:14 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 39151 ms Can anyone help me on this one please? Thanks in advance

I have Jasperserver 5.5.0 and Jaspersoft Studio 5.5.0. I have created a new report using psql as language in my query as I'm using a WITH RECURSIVE.... The report runs fine in Jaspersoft Studio but I can not load it into Jasperserver where I find this error: Caused by: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language. Can anyone help me solve this problem please? Thanks in advance for any help, Greetings, Alain

Hello, I have folowing sql that I can execute in an SQL-window in PgAdmin on my database but used in an Jasper Report, I get no data: select * from ( WITH RECURSIVE q AS ( SELECT h, 1 AS level, ARRAY[h.code] AS breadcrumb, a.name as nummer, ac.code as rekening, a.ref as ref, a.amount as amount, res_company.name as company_name, account_period.name as period_name, account_analytic_dimension.sequence as an_dim_seq, account_analytic_dimension.name as an_dim_name, a.write_date as datum, account_analytic_journal.name as an_jrnl_name FROM account_analytic_account h INNER JOIN res_company on res_company.id = h.company_id LEFT OUTER JOIN account_analytic_line a ON a.account_id = h.id LEFT OUTER JOIN account_account ac ON ac.id = a.general_account_id LEFT OUTER JOIN account_analytic_journal on account_analytic_journal.id = a.journal_id LEFT OUTER JOIN account_period on account_period.id = a.period_id LEFT OUTER JOIN account_fiscalyear on account_fiscalyear.id = account_period.fiscalyear_id LEFT OUTER JOIN account_analytic_dimension on account_analytic_dimension.id = h.dimension_id WHERE h.code = 'B01' and res_company.name = 'Natuurpunt Beheer vzw' and ( a.name IS NULL or '2013' = account_fiscalyear.name ) UNION ALL SELECT hi, q.level + 1 AS level, breadcrumb || hi.code, al.name as nummer, ac.code as rekening, al.ref as ref, al.amount as amount, res_company.name as company_name, account_period.name as period_name, account_analytic_dimension.sequence as an_dim_seq, account_analytic_dimension.name as an_dim_name, al.write_date as datum, account_analytic_journal.name as an_jrnl_name FROM q JOIN account_analytic_account hi ON hi.parent_id = (q.h).id INNER JOIN res_company on res_company.id = hi.company_id LEFT OUTER JOIN account_analytic_line al ON al.account_id = hi.id LEFT OUTER JOIN account_account ac ON ac.id = al.general_account_id LEFT OUTER JOIN account_analytic_journal on account_analytic_journal.id = al.journal_id LEFT OUTER JOIN account_period on account_period.id = al.period_id LEFT OUTER JOIN account_fiscalyear on account_fiscalyear.id = account_period.fiscalyear_id LEFT OUTER JOIN account_analytic_dimension on account_analytic_dimension.id = hi.dimension_id ) SELECT REPEAT(' ', level) || (q.h).id, (q.h).parent_id, (q.h).code, rekening, level, nummer, ref, amount, company_name, period_name, an_dim_seq, an_dim_name, datum, an_jrnl_name, breadcrumb::VARCHAR AS path FROM q ORDER BY breadcrumb) as t Does anybody have any idea what may be the reason? Thanks in advance for any help

Found the problem by reviewing the xml-files. The default folders that were created automaticaly by the installation on the 2 servers have different uri but same names: - queries vs Querys - reports vs Reports etc... The result is that it appears all directories exist 2 times (different uri but same name). The only explanation is that a different version ofthe installation file was used on the 2 servers... Greetings

I export my reports on one server: js-export.sh --uris /Reports/NP --output-dir myExport I import this directory on another server; js-import.sh --input-dir /home/alain/Documents/myExport --update My problem is that several directories in my jasperserver now exist twice: the import apparantly created a new directory Data Sources, Queries and Reports instead of just adding the subdir NP in each of these as was the case on the server I exported. The strange thing is that for Input Controls it worked fine as expected, it just created a subdir there called NP that contains the input controls needed for my NP reports. Any suggestions? All help is greatly appreciated.