Ectomorph

I too am experiencing this problem, see http://community.jaspersoft.com/questions/844584/scheduled-reports-not-using-defaultvalueexpression-date

Hi, would this cause scheduled reports not to use the relative date each scheduled run? - This is what is happening with mine, they keep using the same date from first time they were run

I have a report designed using Jaspersoft iReport Designer 5.1 with two input parameters defined with a default value expression to define a date range : <parameter name="lowerDate" class="net.sf.jasperreports.types.date.DateRange"> <parameterDescription><![CDATA[Enter Lower date]]><parameterDescription> <defaultParameterExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("YEAR").toDateRange().getStart()]]></defaultValueExpression></parameter> <parameter name="upperDate" class="net.sf.jasperreports.types.date.DateRange"> <parameterDescription><![CDATA[Enter Upper date]]><parameterDescription> <defaultParameterExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("DAY").toDateRange().getEnd()]]></defaultValueExpression></parameter> In the report configuration in JRS I have defined the input parameters and bound them to the report parameter names and set them as not mandatory. The report runs just fine and populates the date fields appropriately with the year start date and today's current date without prompting.My issue is I cannot get the same behaviour when the report is run via a schedule which I have configured to run daily. In the schedule configuration, as I did not make the input parameters as mandatory, are blank - assuming the default values as specified in the report should be used, however the 'upperDate' parameter is not reflecting the current day but retaining the original value from the report first ran. I've tried various combinations in the config but nothing seems to make the report update the date values during a scheduled run. Any help would be most appreciated. Cheers.

Hi, I have installed Glassfish3 and JRS as a non-root user on Linux, firing up Glassfish with ./asadmin start-domain domain1 works just fine with Glassfish starting successfully, however JRS failed to start with a string of errors. The first one being... [#|2014-03-07T14:44:11.849+1000|INFO|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=1;_ThreadName=Thread-2;|2014-03-07 14:44:11,835 ERROR ContextLoader,main:307 - Context initialization failed[/code]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]: Cannot resolve reference to bean 'engineService' while setting bean property 'schedulerContextAsMap' with key [TypedStringValue: value [engineService], target type [null]];nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'engineService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'engineServiceDataCacheProvider' while setting bean property 'dataCacheProvider';nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'engineServiceDataCacheProvider' defined in ServletContext resource [/WEB-INF/applicationContext-data-snapshots.xml]: Cannot resolve reference to bean 'dataSnapshotService' while setting bean property 'dataSnapshotService';nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSnapshotService' defined in ServletContext resource [/WEB-INF/applicationContext-data-snapshots.xml]: Cannot resolve reference to bean 'dataSnapshotCachingService' while setting bean property 'cachingService';nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSnapshotCachingService' defined in ServletContext resource [/WEB-INF/applicationContext-data-snapshots.xml]: Cannot create inner bean 'org.springframework.cache.ehcache.EhCacheFactoryBean#2ea4fd4c' of type [org.springframework.cache.ehcache.EhCacheFactoryBean] while setting bean property 'contentsCache';nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.ehcache.EhCacheFactoryBean#2ea4fd4c' defined in ServletContext resource [/WEB-INF/applicationContext-data-snapshots.xml]: Invocation of init method failed;nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied 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.|#][/code]... However, if I start Glassfish with sudo then all works well and good. Obviously its a permissions thing and we have gone through making sure the glassfish and jasper war are all owned by the same user. Any ideas ?

startdate works just fine in other reports, as mentioned, and the query still fails even if i remove this line completely.

Many thanks for your suggestion, hozawa, but the "and startdate >= ? and startdate <= ?" works just fine in similar report queries I have running successfully. For example, the query below has no problems generating a report; select o.orgname, a.accountno, a.level, c.fee, a.discount, a.startdate, a.expiry FROM organization o, account a, charges c where o.id=a.memberid and c.acclevel=a.level and status=1 and acctypeid=2 and acctype=2 and startdate >= $P{startDate} and startdate <= $P{endDate} order by level asc Note: The above query was taken directly from the report thats why the startdate and enddate have the parameterized EL as opposed to '?' as shown in the error snippet.

Hi, I'm running JasperReports Server v5.5 in Glassfish and with a MySQL db. I have an issue when trying to produce a particular report, the server logs the following error message; Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL:select o.orgname, a.accountno, a.level, a.startdate, a.expiry from organization o, account a where o.id=a.memberid and a.acctypeid=1 and a.status=1 and a.level='Trial' and startdate >= ? and startdate <= ? order by a.startdate|#][#|2014-02-19T10:46:36.363+1000|INFO|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=151;_ThreadName=Thread-2;|2014-02-1910:46:36,362 ERROR AsyncJasperPrintAccessor,pool-16-thread-2:299 -Error during report executioncom.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)[/code]As you can see, the query is simple enough. The startdate and endate values are matched against passed parameters. If I set sql validation to false from within security-config.properties then the report works fine, but ideally I dont want to do that. Can anyone spot anything in the query that is causing JasperReports Server to fail validation? Thanks.

Well, if i set input.validation=false then it works but I really dont want to do that.

I have a two questions regarding CE that I cant find the answer to. 1. Is JNDI data sources enabled as I cant for the life of me get it to work? 2. Is https supported? Thanks.

No, there were no errors, just output from installing the app successfully then picking up the war again and redeploying.

For whatever reason, starting glassfish with sudo got the thing up and running. Obviously a permissions issue somewhere.

After getting JRS to run fine on https, i'm having issues with https. The problem starts after logging in with the log INFO message; 2;|2014-02-13 09:58:30,788 ERROR Validator,http-thread-pool-8080(4):408 - [sECURITY FAILURE context=userTimezone-Login_context, key=userTimezone, type(Timezone)=null, input=Australia/Brisbane, maxLength=100, isBlacklist=false] and the screen displaying error 5321 contact administrator. If I set security.validation.input.on= false then it all works, but this is not a good solution. If I comment out the userTimezone=Alpha,Timezone,100,true,userTimezone-Login_context in security.properties then I simply get another similar validation error. Commenting this one out leads to another and so on. Any ideas on what the issue is? Thanks.

I've been able to install the JRS from the war file to glassfish but have been unable to start the application. When starting glassfish, it tries to deploy JRS over and over without actually successfully deploying it. I have to shut down glassfish. It is installed using the same user:group as glassfish. Ideas? Thanks.

Greeetngs one and all. I've deployed Jasper report server to my glassfish3 container and I'm running a MySQL database. I have imported two versions of the same .jrmxl report, one which is based on SQL and one based on EJBQL. Its a very simple report only using one table/EJB. I have created two datasources, one to connect to the MySQL database and a JNDI connection datasource, both passed connection tests (note, I had to include a <resource-ref> block in the WEB-INF/web.xml file refering to the jdbc/mydatasource, in the same manner as the examples in this file, of the jasperreport server deployment to get the connection to work). Finally, I assigned each reoprt their appropriate datasource. Now, the report based on SQL runs just fine however the JNDI based report yeilds no results, saying instead that the report is empty. I'm unable to find any decent articles on the web covering JNDI for jasperreport server. Can anyone offer any advice? Many thanks.