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.

I am researching the same thing. I have a table that has a group and want to show the group header/footer data vs. detail band data. Can't seem to find an option in JasperDesigner to delete the detail band in a table.

Hi there, Is there anyway to ensure the order in which parameters are evaluated? I have 2 parameters (e.g.) and 1 refers to the other and is a substring of that first parameter. Sometimes though, param2 is null, sometimes it has a value taken from Param1. Just wondering how I can enforce P1 is always evaluated before P2? You can run the below source with Parameter1 being test1,test2,test3 repeatedly to see what I mean. Sometimes Parameter2 will be null, sometimes it will be "test1". Sample source: <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="sample" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d9385bae-2cc3-433e-bf49-27d6a50e3d62"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <parameter name="Parameter1" class="java.lang.String"/> <parameter name="Parameter2" class="java.lang.String"> <defaultValueExpression><![CDATA[$P{Parameter1}.indexOf(",") > 0?$P{Parameter1}.substring(0, $P{Parameter1}.indexOf(",")):$P{Parameter1}]]></defaultValueExpression> </parameter> <queryString> <![CDATA[]]> </queryString> <detail> <band height="125" splitType="Stretch"> <textField> <reportElement x="120" y="10" width="278" height="30" uuid="924e8f84-e48b-4975-af13-c90b4b5973cf"/> <textFieldExpression><![CDATA["param1: " + $P{Parameter1}]]></textFieldExpression> </textField> <textField> <reportElement x="120" y="50" width="277" height="30" uuid="f3d8943b-253f-4a90-8810-26802bb463d2"/> <textFieldExpression><![CDATA["param2: " + $P{Parameter2}]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

Has anyone encountered this error when printing off one of their Jasperreports as a pdf? I have it happening on 1 printer, but not any of the others. Just wondering if there is a fix that can be applied at the Jasper level, or if this is a printer bug, or other?

Greetings, I have a table that is displaying basic data on meds (Name, Dosage, Doctors Instructions). Each row of meds can be in my data source more than once (e.g. if the doctor adds another note). So I am trying to group by Med Name, Med Dosage within my Table. It currently will show the data just fine, just will have repeated rows if more than 1 note is added to a med. e.g. Aspirin | 2 tablets daily | Take with water Aspirin | 2 tablets daily | Also take after a meal. Tylenol | 15mL every 4 hrs | For infants only My goal (since this table doesn't care about doctors instructions) is this: Aspirin | 2 tablets daily Tylenol | 15mL every 4 hrs So I click on my table data set, select Groups sub menu, right-click and Create Group, calling it MedsOnlyGroup. In the dialog I enter a name and then an expression of "$F{MedName}+$F{Dosage}". I then attempt to preview my report and I get an error: No group named MedsOnlyGroup" found in subdataset MedsTable_DataSet. (note only 1 quote in error message. Suspect this is just a typo though) Reset group "MedsOnlyGroup" not found for variable: Group1_COUNT Anyone know what I am doing wrong? Thanks, Rob

Can you confirm the XY and width/height of every field? THey should match exactly for the output to be aligned properly.

Hozawa that helped a little... my calibri font is now working, but I do not seem to see Arial on those sites. Do you know why I would see Calibri but not Arial? Thx, Rob

What are the field data types you are working with?

Are the dates in the DB? If there are two columns in your DB you can use the SQL function "DATEDIFF" to creat e a column that will have the days diff you require. If not, you can use an expression... it all depends on what class the dates are. Assuming they are a Date, you can use $F{DateOne}.getTime()-$F{DateTwo}.getTime() which will return the milliseconds... to convert to days: ($F{DateOne}.getTime()-$F{DateTwo}.getTime()) /(24*60*60*1000)

Reportdev that did not work... when I export to PDF (even from within JasperStudio). The bold text is still not bolded.

I have a text field that is showing a disclaimer at the bottom. The word "Disclaimer:" is bolded but the rest of the text is not. I use a style tag with rtf markup to achieve this. When I show in jasper, it is bolded fine but when I export to PDF it dissapears. I have seen similar issues but am not clear on how to resolve this. How can I configure it so that my PDF shows the word(s) I desire bolded using the <style> approach? Sample text field: "<style isBold="true" >DISCLAIMER: </style>This report is confidential. <style isBold="true" >Do not share. </style> If found, please destroy." My desired report font is Calibri 10 Italicized.