Article - CS380347

Unable to execute Jasper reports when Windchill is configured with SSL on alias name

Modified: 13-Jun-2023   


Applies To

  • Windchill PDMLink 12.0.2.5 to 12.0.2.11

Description

  • Running Jasper Reports with https configuration and Windchill configured with an Alias hostname gives an error below:
2022-05-23 14:55:57,456 ERROR [Thread-32] com.ptc.wbr.core.execution.JasperReportExecutor wcadmin - getJasperPrint(): Error While executing Jasper report net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new net.sf.jasperreports.engine.data.JRXmlDataSource($P{WINDCHILL_URL}+"?proc=com_ptc_windchill_enterprise_report_ReportTask%23ChangeNoticeSummaryHeader&contextOid="+$P{contextOid}+"&isDraft=" + $P{isDraft} +"&uid="+$P{USERNAME}+"&locale="+$P{LOCALE},"/dataset/data/row")
	at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:294)
	at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:328)
	at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:673)
	at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:641)
	at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1173)
	at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:529)
	at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateSubreport(FillTableSubreport.java:112)
	at net.sf.jasperreports.components.table.fill.FillTable.evaluate(FillTable.java:134)
	at net.sf.jasperreports.engine.fill.JRFillComponentElement.evaluate(JRFillComponentElement.java:110)
	at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383)
	at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:548)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2600)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:825)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:266)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:621)
	at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:433)
	at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:162)
	at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:651)
	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:1020)
	at com.ptc.wbr.core.execution.JasperReportExecutor.getJasperPrint(JasperReportExecutor.java:406)
	at com.ptc.wbr.client.ReportClientHelper$1.run(ReportClientHelper.java:203)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: https://<actualtruehostname>:443/Windchill/servlet/ReportServlet?proc=com_ptc_windchill_enterprise_report_ReportTask%23ChangeNoticeSummaryHeader&contextOid=VR:wt.change2.WTChangeOrder2:633623051&isDraft=0&uid=Administrator&locale=en_US.
	at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:139)
	at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:51)
	at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:196)
	at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:195)
	at net.sf.jasperreports.repo.RepositoryUtil.getInputStreamFromLocation(RepositoryUtil.java:172)
	at net.sf.jasperreports.engine.data.JRXmlDataSource.<init>(JRXmlDataSource.java:333)
	at net.sf.jasperreports.engine.data.JRXmlDataSource.<init>(JRXmlDataSource.java:321)
	at net.sf.jasperreports.engine.data.JRXmlDataSource.<init>(JRXmlDataSource.java:350)
	at net.sf.jasperreports.engine.data.JRXmlDataSource.<init>(JRXmlDataSource.java:345)
	at Change32Notice32Summary32Report_1649391812022_566337.evaluate(Change32Notice32Summary32Report_1649391812022_566337:96)
	at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:313)
	... 21 more

 
This is a printer-friendly version of Article 380347 and may be out of date. For the latest version click CS380347