kkriplani

August 26, 2016

Hi,

In <tomcat>/conf/server.xml , you will find a <connector .... /> Tag. Replace the complete tag with :

<Connector compressableMimeType="text/html,text/xml,text/css,text/javascript, application/x-javascript,application/javascript"
compression="on"
compressionMinSize="128"
connectionTimeout="20000"
noCompressionUserAgents="gozilla, traviata"
port=" ***** "
maxHttpHeaderSize="65536"
redirectPort=" **** " protocol="HTTP/1.1" />

Note: Replace the stars with relevant connector port and redirect port.

This is a way to tune your tomcat, go through the following link to learn about more ways to tune you tomcat.

Regards,
KKriplani

August 25, 2016

Hi,
I apologize, I would like to correct myself.

Go with this default expression:

$P{param_prj_id}.isEmpty() ? "1" : "0"

Let me know if you get the desired results :)

Regards,
KKriplani

August 25, 2016

Hi,

This is the default functionality of multi-select, i.e, if no values are passed through the input control, it considers the scenario as all are values selected.

So if you want to display a message, create a parameter (Lets say $P{test} ) with an expression like below;

$P{param_prj_id} == null ? "1" :"0"

Using this parameter, display a band saying "No values selected" (as per your requirement) and use print when condition for that band using $P{test}

Regards,
KKriplani

August 24, 2016

Hi,
Which version of jasperserver are you using?

This is due to the fact that the chart is a flash component and pdf format does not support flash component. Try saving the pdf in your system and then view it.

Regards,
Kkriplani

August 23, 2016

Yeah that should work fine.

August 22, 2016

Hi,
Well I guess you cannot display the Three bands as you said but there can be a work around by handling through "Print When Condition".

May I know what you are printing in the title band and Page footer band? Is it a value returned from the query or just simple text fields?

If it is not populated through the query, create a replica of them in the No data band.

Hope this helps,
Meanwhile I will try finding a better resolution.

KKriplani

August 22, 2016

Hi,
The blue table can all together be printed using a single dataset.
While for the green and grey section, I would suggest you to include both the queries as one, i.e, in a single dataset and print the table.

Note: A table can use only one dataset and not more.

Regards,
KKriplani

August 22, 2016

Hi,
Yes, Create a "No Data" band and click on the main report. Then in the property section you will notice a property named "When No Data", in the drop down, select "No Data Section".

Regards,
KKriplani

August 18, 2016

Hi,

One possiblity of this issue could be that you are calling an image or subreport or any resource in the main report and the user has access to the main report but not to that other resource. Check this point.

Hope it helps,
KKriplani

August 18, 2016

Hi,
You must understand that tooltips are available on Images, text fields, charts, etc but not on Static Fields. So make sure that your report name is a Text field enclosed in double quotes.
For example, if my report name is Data Distribution, the text field will look like below;

Then follow the below steps;
1) Right Click on the text field and select Hyperlink.
2) You will notice the below dialog box;

3) Enter the fields as selected above.

Result:

Please be advised, I am using iReport designer and in case you are using Studio, I am pretty sure the setting may not be very different apart from the fact that hyperlink would be available in the side bar properties.
Also, The reason why I selected "Hyperlink Type" as "Reference" is because I wanted a curson pointer (not visible in the screenshot).

Regards,
KKriplani

August 18, 2016

Hi,
Firstly I would suggest you to recheck the query and make sure the result the is same on both the sql server and the report.
If that doesnt work, click on the table component and in the properties you will observe a property named "Print Repeated Values". Make sure that this property is unchecked.

Hope this helps,
KKriplani

August 18, 2016

Hi,
I guess you are not getting my point.

The $X{IN,<columnName>,<parameterName>} is a way to handle the multiple values in the query, but to fetch those multiple values into the query, you need to add a multi select Input control.

First lets get on the same page. Your motive is to get a drop down with options that would pass mult values into the report that you are fetching (example in the image below).
If so, you need to understand the use of Input Controls and as per your request, "Multi select query" or "Multi select list of values" Input control would be of your interest and would achieve the desired results.

In the example above, I am populating campaign names from the db using a multi-select Input control.

Regards,
KKriplani

August 17, 2016

Hi,
Yes this is very much possible. What you are looking for is a "single/multi select query* " input control.

1) Create an iput control with the same id as the name of the parameter to which it will pass the value to.
2) select a type and add the relevant details required.

*Single or multi depending upon your requirement.

Regards,
KKriplani

August 17, 2016

Hi,
You need to set the heap size of the tomcat.
are you using a windows server?

August 16, 2016

Hi,

Lets consider the field name to be $F{Test}

Using Ternary Statement,

$F{Test} == 3? "Minor" : $F{Test} == 4 ? "Moderate" : "Critcal"

Regards,
KKriplani

August 16, 2016

Hi,

The basic usage of $X{} is for IN or NOTIN in a query.

For example:
I have a query like below;

Select * from employeeDetails
where EmpID IN (p_Empid);

* EmpID is the column name in the table
** p_Empid is the parameter in the report

This query will look like below in ireport;

Select * from employeeDetails
where $X{IN,EmpID,p_Empid};

The format is as below;

$X{IN,<columnName>,<parameterName>}

Hope this helps;
KKriplani

August 16, 2016

Hi,
Are you refering to "Single Select " Input control to drop down?

Basically the start date and end date will be calendar Input controls while Role parameter will be a Single select Query type of Input control. Please read about the highlighted feartures above just so that we are on the same page and I will assist you further.

Regards,
KKriplani

August 11, 2016

Hi,
Yes, this is very easily possible. You need to read about "Print when condition" and use it.
Pallete Components have a print when condition which decides when the component will print and passed on what parameters. Get the value of the input control (A,B or C) into a parameter and decide which to print when.

Also note, you will need a multi-select list of values type of Input control.

Hope this helps,
KKriplani

August 10, 2016

Hi,
I guess you need to perform jasperserver tuning. To do so, you need to keep some additional points in mind;
1) Go for JNDI connection rather than JDBC connection as it allows you to configure an entire connection pool that resides within the container.
2) You will have to perform a few basic tuning operations as mentioned in this links mentioned below.

Links:
1) Jasperserver Performance Tips and tricks
2) Compressing HTTP response
3) Enabling Cache filter

Hope this helps,
KKriplani

August 9, 2016

Hi,
There are a few basic requirements of publishing a report to jasper server, namely:
1) Creating a datasource, i.e, connectivity for database to the jasper server
2) Creating input controls that would fetch the value into the query from the user

To publish the report from jasper studio, follow the below points:
1) In the repository, create the connectivity with the jasperserver you want to publiush the report to
2) At the folder where you want to publish, Right click, left click on new and select report unit.
3) fill in the details and give the repository location or Local resource location of the report.
4) Click next and also create the datasource (New or existing one)
5) Input controls must be made individually.

Hope this help,
KKriplani

August 9, 2016

Hi,
Did you check the logs?

August 9, 2016

Hi,
Here is the error that I found.

Thanks in advance.
KKriplani

August 9, 2016

2016-08-08 11:30:03,598 ERROR JNDIResourceProvider,localhost-startStop-2:75 - error closing context

javax.naming.OperationNotSupportedException: Context is read only

at org.apache.naming.NamingContext.checkWritable(NamingContext.java:960)

at org.apache.naming.NamingContext.close(NamingContext.java:760)

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.(ResourcesFactory.java:92)

at com.tonbeller.tbutils.res.ResourcesFactory.(ResourcesFactory.java:89)

at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1071)

at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1721)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2016-08-08 11:30:12,256 ERROR DbcpDataSourceFactory,JasperServerMaintenanceScheduler_Worker-1:59 - java.lang.ClassNotFoundException: com.mapr.drill.jdbc41.Driver

java.lang.ClassNotFoundException: com.mapr.drill.jdbc41.Driver

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1293)

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.jaspersoft.jasperserver.api.common.service.impl.JdbcDriverServiceImpl.loadDriverFromExistingClassLoaders(JdbcDriverServiceImpl.java:535)

at com.jaspersoft.jasperserver.api.common.service.impl.JdbcDriverServiceImpl.register(JdbcDriverServiceImpl.java:130)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)

at com.sun.proxy.$Proxy39.register(Unknown Source)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.registerDriver(DbcpDataSourceFactory.java:57)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.createPooledDataSource(DbcpDataSourceFactory.java:50)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory.getPoolDataSource(JdbcReportDataSourceServiceFactory.java:159)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory.createService(JdbcReportDataSourceServiceFactory.java:142)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:91)

at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributesResolverAspect.resolveDataSourceAttributes(ProfileAttributesResolverAspect.java:50)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy42.createService(Unknown Source)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:1940)

at com.jaspersoft.jasperserver.war.common.HeartbeatBean.createDatabaseInfoCache(HeartbeatBean.java:735)

at com.jaspersoft.jasperserver.war.common.HeartbeatBean.call(HeartbeatBean.java:480)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.JSMethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(JSMethodInvokingJobDetailFactoryBean.java:247)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.JSQuartzJobBean.execute(JSQuartzJobBean.java:51)

at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

2016-08-08 11:30:29,133 ERROR EncryptionFilter,http-apr-8081-exec-3:88 - Key pair was not read correctly from keystore.

java.lang.RuntimeException: Exception loading keystore and reading the keys.

at com.jaspersoft.jasperserver.api.security.encryption.EncryptionManager.generateKeys(EncryptionManager.java:158)

at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:85)

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 org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:618)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:277)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2403)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2392)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: java.io.EOFException

at java.io.DataInputStream.readInt(Unknown Source)

at sun.security.provider.JavaKeyStore.engineLoad(Unknown Source)

at sun.security.provider.JavaKeyStore$JKS.engineLoad(Unknown Source)

at java.security.KeyStore.load(Unknown Source)

at com.jaspersoft.jasperserver.api.security.encryption.EncryptionManager.generateKeys(EncryptionManager.java:127)

... 45 more

2016-08-08 11:30:29,172 ERROR EncryptionFilter,http-apr-8081-exec-7:88 - Key pair was not read correctly from keystore.