robsil

Greetings, I was reviewing my JasperServer logs and see numerous instances of the following exception... looking for some clarity on what this means: 16-Jan-2020 20:30:13.926 SEVERE [http-nio-8081-exec-5] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [JerseyREST] in context with path [/jasperserver-pro] threw exception org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into JIUserRole (userId, roleId) values (?, ?)]; constraint [jiuserrole_pkey]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:795) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:666) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy117.synchronize(Unknown Source) at com.jaspersoft.jasperserver.api.security.externalAuth.preauth.BasePreAuthenticatedProcessingFilter.successfulAuthentication(BasePreAuthenticatedProcessingFilter.java:189) at org.springframework.security.web.authentication.preauth.AbstractPreAuthenticatedProcessingFilter.doAuthenticate(AbstractPreAuthenticatedProcessingFilter.java:169) at org.springframework.security.web.authentication.preauth.AbstractPreAuthenticatedProcessingFilter.doFilter(AbstractPreAuthenticatedProcessingFilter.java:104) at com.jaspersoft.jasperserver.api.security.externalAuth.preauth.BasePreAuthenticatedProcessingFilter.doFilter(BasePreAuthenticatedProcessingFilter.java:130) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:234) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:160) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:40) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:147) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:84)

Greetings, I am working on some JasperServer audit reports and am having trouble querying the JasperServer DB. My development workstation cannot connect to my development JasperServer as I believe the DB is only configured for local access. Looking for advice on how to develop some audit reports the easiest? Have people just installed JasperServer locally, or is there a trick to connecting to my development JS? (I much prefer to connect to the dev Server, as my server has a lot more useful test data in it vs. a local install.) Thx, Rob

Hey Kurtis, Some of this might depend on your dataset... are your CRID's unique across the board, or will the project + the CRID form the PK for the table? I usually use the $X{IN, cr.change_request_key, CRID} syntax (assuming you have a multi-select input) and find it resolves to nothing when no matches occur. Could you make 1 or both of the params optional and allow this to occur? e.g. if no CRID, the project key takes over and it returns all CRID's for the project(s) selected. This depends a little on your data structure but it may work for you? Also should have a 1=1 in the where clause so that the query still pulls things back if both are blank.

Greetings, We recently upgraded to JasperServer 7. In 1 table report with many columns we've run into an issue. If a lot of the columns are hidden/unhidden and you try to reverse one... the bottom few colums in the popup list exceed the height of the browser window I am unable to scroll down to select the last few column names. Any use of mouse scroll wheel etc. removes focus from the drop down window that pops up when you choose to filter the table columns. Is there a way around this, to ensure that you can scroll the long list?

Is there a way to force a table to have its group header show up on next page with the 1st detail band when the header row is at very bottom of page? I have a table where the header shows at the bottom of a page and the 1st detail row is at the top of the next page. Want to keep them together so the header shows at least 1 row with it. Thx, Rob

I have a report I am running against a Progress DB. My goal is to have the items returned by my query show up in a field as comma seperated values. e.g. Students Table ID - Name 1 - Joe 2- Frank 3 - Susan 4 - Mary In my report I would have an area with a display such as: "Current Students: Joe, Frank, Susan, Mary" In SQL Server I see there are some DB functions to merge the select items, but nothing shows up on the Progress side. Suggestions on how I can accomplish this? (ideally DB-neutral solution)?

Set default value expression to be: java.sql.Date.valueOf(Calendar.getInstance().get(Calendar.YEAR) + "-01-01") and java.sql.Date.valueOf(Calendar.getInstance().get(Calendar.YEAR) + "-12-31")

java.sql.Date.valueOf(Calendar.getInstance().get(Calendar.YEAR) + "-01-01") and java.sql.Date.valueOf(Calendar.getInstance().get(Calendar.YEAR) + "-12-31")

Is there anyway to set this value globally? I have a large table report with lots of fields. Cringe at the thought of implementing this on a field by field basis.

Update... found the solution. I had my "2nd" parameter setup as for prompting. Once i removed that flag it processed the for prompting first... then it processed the not for prompting parameter and it resolved my issue. I am still unclear on any sequence/order that exists when evaluating parameters (and variables) but at least a "for prompting" param gets evaluated before any that are not for prompting.

This is a very high level description but should help you start to wrap your head around it... Think of a report as a series of bands of a page that get "stamped" onto the main page. Page Header goes first... followed by Column and Group Headers. Then for each detail band height left on the page a detail band will be stamped. Then the relevant Footer items. The field you add is calculated into whichever band it is placed based upon what data row in your data set is "current". So each time the field is "stamped" it calculates based upon it's expression. For example... if your data set is 1,000 "video games" and your field is "GameTitle" then as Jasper iterates over each row in your data set, the GameTitle would be placed into the report as the band is rendered. If your detail band is very tall... maybe only 1 field will have room per page... if it is very short, many fields will be displayed 1 below the next. Hope this helps. R.

Will need some more information. But preview should be producing the full report (page by page) based upon the data source and input parameters you selected. The text field should be showing you the value of it's expression based upon the current row in the DB. The detail band is "stamped" once per row in your data query so if there are enough elements it would make sense that you get so many pages and each has a different value for the next field.

Greetings, Is there a parameter that controls what the report filename is on the JasperServer when you upload a file? I am adding a new report via JasperStudio upload to JasperSerer option. The report unit I can control... it pulls it out of the report name. But the actual filename created witin the report unit always seems to be Main.jrxml. I'd like to name this similar to the report unit for clarity if possible. Is this a parameter that can be assigned to the report somewhere perhaps? Thx, Rob

Thanks Hozawa... do I apply those on the text field or the column? Also I should mention that the cells are in a group footer and not showing... I have hidden my detail band by setting height to 0. if I move the fields into the detail band they seem to show (e.g. delete the group footer row). I also set my background color for the group footer cells to be red and the detail cells to be blue and export to excel. It seems like my red group footer cells do not show at all, but the blue detail bands do show. Is there an issue with exporting to excel with only a group footer showing and not a detail band?

Does anyone have any ideas on why my report would show data just fine on screen in the JasperServer browser and when I export to PDF, but when I export to Excel there is the header row and blank text in each of the data rows? It looks like the rows are there... just no text in any of the rows (e.g. the row height is the height it would be in the report, for each of the rows that I see in the PDF). Just seems like the text is not exported into the table.