MaxH Honored Contributor.
Honored Contributor.
179 views

Multiple Report Filter Parameters

We have a developed report that contains one (1) filter parameter.  Need to know how to add a second filter parameter to the report.  The parameters should be able to be use either or.  When we attempted to do this, we get the following error:

Running report/web/knta/drv/rpt/DcpdsPiaStatus.jsp
Posting report request tohttp://172.26.228.153:8080/itg/servlet/RunJspReport
Post data= 'REPORT_JSP=%2Fweb%2Fknta%2Fdrv%2Frpt%2FDcpdsPiaStatus.jsp&OUT_BASEFILE=rep_36594&USER_ID=100693&REPORT_ID=36594&SUBMISSION_LANGUAGE=AMERICAN&KEYID=37101&KEY=85816409'
Writing report file/opt/ppm/PPM/reports/rep_36594.html
Error running report.
(Cleaning up any partial report output...)
HTTP response:500 - java.lang.NullPointerException

java.lang.NullPointerException at org.apache.jsp.web.knta.drv.rpt.DcpdsPiaStatus_jsp.getPias(DcpdsPiaStatus_jsp.java:166) at org.apache.jsp.web.knta.drv.rpt.DcpdsPiaStatus_jsp._jspService(DcpdsPiaStatus_jsp.java:635) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.kintana.rpt.web.servlet.RunJspReport.doPost(RunJspReport.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.BrowserCompatibilityFilter.applyFilter(BrowserCompatibilityFilter.java:123) at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115) at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:217) at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:81) at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:974) at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1648) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.SchemeBasedRedirectFilter.doFilter(SchemeBasedRedirectFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:56) at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

 

0 Likes
4 Replies
Natalia_R_PPM Absent Member.
Absent Member.

Re: Multiple Report Filter Parameters

Hello Max,

Could you please let us know which steps you take to add the second filter?

Also you can enable the debug lines for reports

Loggin.conf

 

1) For Reports (shows if any reports are being run )

com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.rpt.system, DEBUG

com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.rpt.tag, DEBUG

 

Thanks

Natalia 

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
MaxH Honored Contributor.
Honored Contributor.

Re: Multiple Report Filter Parameters

Natalia,

Attached is the log (after enabling debug lines for reports) and two (2) screenshots.  The screenshots represent the report parameters and the .jsp file where the code is inserted.  The steps to create the second filter were as follows:

1.  Open existing report configurations

2.  Add the second filter by creating a new one using an existing validation for the PEP_Year (ScreenShot001.png)

3.  Adding the data to the .jsp report file (ScreenShot002.png)

Thanks.

Max

0 Likes
MaxH Honored Contributor.
Honored Contributor.

Re: Multiple Report Filter Parameters

Natalia, any update for me?

0 Likes
MaxH Honored Contributor.
Honored Contributor.

Re: Multiple Report Filter Parameters

Turns out that we do not need multiple filter parameters since the cuswtomer changed the requirements.  Now, we have two filters on the report, but the 'Find' button will not work.  See screenshot.  any suggestions?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.