Terrible

Finally, i've managed to solve this easily without modifiying jasperserver files or doing technically complicated actions. First, remove all folder permisions from the ROLE_USER and leave only access to the minimum number of folders/resources needed to login and show something. Next, create a new role ROLE_XXX and assign read/write/execute permissions in all the desired resources/folders/reports, etc .. Last, create a new user and assign to it both ROLE_USER and ROLE_XXX et voila, the user can login and access only the resources granted by ROLE_XXX The procedure for additional requirements will be the creation of new roles, every of them with it's own permissions. Every new user will be assigned to ROLE_USER and ROLE_XXXn depending of the permissions level desired. Perhaps this is far from perfect, but i think is a tecnically valid solution in order to create and assign new users and roles without doing anything technically complex. Best regards. Iván

Thanks for your updates. I'll try to do something similar. Best regards. Iván

Since i'm unable to get any reply, we're assuming the jasperserver role system doesn't work with new roles, and there's only two real usable roles, role_admin and role_user. If anyone knows how to enable a new role in jasperserver please feel free to contact me. Regards.

Hi everyone : There is any procedure in order to create and assign permissions to a new role in jasperserver? We want to create a new role similar to the ROLE_USERS, but after creating the role, if you assign this role only to a user, this user can't connect and do anything. I've modified some files (applicationContext-security, applicationContext and other xmls) trying to assign to the new role the same permissions as the ROLE_USER but actually if you login into jasperserver with this role only the application hangs.. Any ideas/procedure/docs in order to create and assign permissions for a new role? Thanks in advance !! Terrible

Thanks for the reply I've solved the issue changing the format of the date returned to 'YYYYMMDD' and now the graphic works well Best regards

Hi everyone : I've experiencing a strange problem with some reports. After finishing the report design with ireport, all runs fine and the report output is ok. This is the report query : SELECT COD_INDICADOR,TO_DATE(FECHA_VALOR, 'DD/MM/YYYY') AS DIA, SUM(VALOR) FROM YELL_BUSSINESS_DATA WHERE FECHA_VALOR >= $P{FechaInicial} AND FECHA_VALOR < TO_DATE($P{FechaFinal})+1 AND COD_INDICADOR IN (SELECT COD_INDICADOR FROM YELL_SRV_IND WHERE COD_SERVICIO='PAOL') GROUP BY COD_INDICADOR, TO_DATE(FECHA_VALOR, 'DD/MM/YYYY') ORDER BY COD_INDICADOR, TO_DATE(FECHA_VALOR, 'DD/MM/YYYY') ASC Simply, groups the data by day between two dates. The report generation and publication are ok. But, if we add a time series graphic, with the time period=day (see the first attach), the report works fine with ireport, but after publishing it with jasperserver, we're getting the error java.lang.IllegalArgumentException: Null 'period' argumentDeleting the graphic, the report can be published and run normally. The two parameters are java.util.date class Any idea to solve this? Thanks in advance

Thanks a lot !! The problem was effectively the permissions granted to the data source. After setting the acces to "read only" level for the ROLE_USER on the data source, the reports are now accesible. Thanks for your help Regards.

Hi : I've created a couple of new accounts in jasperserver in order to provide access (read and execute) to some previously generated reports. These accounts have assigned the ROLE_USER Unfortunately, logging with these accounts is impossible to execute any report, no matter the permissions you assign to the folder, if you want to execute a report you get the following error : org.acegisecurity.AccessDeniedException: Access is deniedorg.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)Currently, the only way to enable the execution of a report to another user is to assign itthe ADMINISTRATOR_ROLE, and this is obviously not valid for us.Can anyone get me a idea to solve this?, i've find in the documentation but there isn'tany solution.Thanks !!

Hi : We're generating a set of reports and need to use some date calculating functions. I've created the following oracle function in order to calculate the last mars sunday date : CREATE OR REPLACE FUNCTION HQADMIN.LASTMARSUNDAY (YEAR NUMBER) RETURN DATE IS SALIDA DATE; DIASEM VARCHAR2(20); BEGIN SELECT TO_CHAR(TO_DATE('02-01-2000', 'DD-MM-YYYY'), 'DAY') INTO DIASEM FROM DUAL; select next_day(TO_DATE('24-03-'|| YEAR ||' 02:00:00', 'DD-MM-YYYY HH24:MI:SS'),DIASEM) INTO SALIDA from dual; RETURN SALIDA; END; / This function returns the date of the last mars sunday of the year entered. First recovers the value "SUNDAY" (in the corresponding language) into the DIASEM variable, and then recovers the date passing this parameter to a query using next_day function and returns the date as follows : select lastmarsunday(2008) from dual; 30/03/2008 2:00:00 I've generated a report using ireport with the following query : SELECT LASTMARSUNDAY(2008) FROM DUAL The compilation and execution was ok, but after publishing this test report in jasperserver, we're receiving the following oracle error : Caused by: java.sql.SQLException: ORA-01846: not a valid day of the week ORA-06512: at "HQADMIN.LASTMARSUNDAY", line 9 This occurs in the sentence "select next_day ..." when the second parameter passed (day of the week) is in a different language than the specified in the NLS_DATE_LANGUAGE parameter. However, i've put the DIASEM parameter and the first query just to avoid this problem, and the function works fine in both the database and iReport, but not in jasperserver. Any ideas about the problem's root? Thanks in advance !!

Lucian : Thanks for the reply. I've reset the datasource time zome to blank, restarted the jasperserver and now the hours are displayed ok, so problem's over. Best regards.

Hi : I've been running a report with two date parameters and then publish is using jasperserver. Running the report locally from any client is ok, and running the report via jasperserver works, but there is a 2 hours gap in the displayed dates, so if you put startdate 16/06/2008 08:00:00 and end date 16/06/2008 12:00:00, the report works and the data (values) displayed are ok, but the date range printed goes from 06:00:00 to 10:00:00, so 2 hours less than the real date. This problems occurs only via url/jasperserver, working with ireport is ok. Seems to be any issue related to jasperserver timezone configuration, but any ideas? Thanks a lot

Hi everyone : We're finishing a set of reports againts a hyperic HQ repository, these reports displays a variety of tech metrics of the monitorized machines, and have various input parameters (ie machine name, plattform, dates, ..) in order to get only the selected data. My questions are : 1) How can i launch a report (with parameters) using command-line?. Any example will be welcome 2) It's possible to automatize the generation of a report using the windows scheduler? (if the point 1 is possible, i think yes). We can put all the command sequence in a .bat file (or similar) and schedule the run?, it's possible also to choose the output format of the report and it's destination? If anyone knows the answer, please try to give a simple example to do this. Thanks in advance