Jump to content
We've recently updated our Privacy Statement, available here ×

rpozsgai

Members
  • Posts

    13
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by rpozsgai

  1. With no suggestions, I finally resorted to changing the image url to a simple folder path on the server itself. fyi
  2. My report uses a parameter for the path to the image file. I can paste the path into my browser and the image will show. However, when I run my report, the image does not get generated. <parameter name="imagePath" class="java.lang.String" isForPrompting="false"> <parameterDescription><![CDATA[image Path or URL]]></parameterDescription> <defaultValueExpression><![CDATA["C:\JaspersoftWorkspace\POpdf\formlogo.png"]]></defaultValueExpression> </parameter>[/code]This parameter worked fine for several years, but my customer recently changed their domain from http to https so now my image file no longer gets generated in my report. The image parameter that gets generated for the report points to an Image Resource in a Domino database on the server. For example: https://localhost/test/MN/webfrmpo.nsf/formlogo.png?OpenImageResource[/code] Can someone direct me to a debugging method that will help to show where the problem is?
  3. I have a Jasper report that runs fine at many of my customers. However, with my latest new customer, I get this error. If I remove the subdataset, then the error goes away. But, the subdataset simply returns two comment fields, so I'm very confused as to how that is generating the error. Again, this is working at my other customers. I was able to determine that the dataset is the problem because I eliminated fields band by band until I had a completely empty form with nothing but the dataset and subdataset. The jrxml is attached. Can someone point me in the right direction as to how to resolve this issue?
  4. I have a Jasper report that queries data from an iSeries. This Jasper report is in place at several of my customers and is running successfully. However, I'm now in the process of setting up a new customer with this report and it isn't working because of this error. I understand that this error would normally point to a problem with a field or parameter or expression formula on the report, but since we have it working elsewhere, I don't necessarily believe it. Is it possible that this error is really due to a different problem somewhere? I've used 3 different versions of the JT400.jar file, but they all result in the same error. Can someone point me to what else may be generating this error? The jrxml source is attached for reference. Edit Jan 13, 2021 I'm just now getting back to this and just as I suspected, this error has nothing to do with the report design. I stripped out all the form definitions and changed all the BigDecimal fields to java.lang.Double and I still get the same error. Surely SOMEBODY has run into this before, right? Any ideas?
  5. This was strangest error - because, as I mentioned. The original formula of isEmpty() worked when the data came from a query. But, the formula did not work when I switched to using Java passing beans instead. After a week of trial and error, I was finally able to get my report to work and it solved this error, too. The solution for me, was a small tech note I found about using Jasper Reports with nested sub-reports. I had to use the jasperreports-javaflow and commons-javaflow jars. Additionally, the jasperreports jar must removed in this case. I applied these jars, restarted the server and voila - it all works. I can't explain it any more than that, but that's what I did.
  6. I'm converting a Jasper Report that was originally designed with a data query as the data source. Now, I'm passing in the field values directly with Java. The error I'm getting is from the Print When Expression on one of my Detail Bands. This formula worked fine when the data came from the query, but not now. What is the proper way to test for a blank field value??? I tried !$F{group3}.equals(null) !($F{group3}.equals("")) LEN($F{group3})>0 Arrays.asList($F{group3}.split(" ")).size()>0 None of these work - I get the same error each time. Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: !$F{group3}.isEmpty() at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:291) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:618) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:586) at net.sf.jasperreports.engine.fill.JRFillDataset.evaluateExpression(JRFillDataset.java:1832) at net.sf.jasperreports.engine.fill.BaseReportFiller.evaluateExpression(BaseReportFiller.java:666) at net.sf.jasperreports.engine.fill.JRFillBand.evaluatePrintWhenExpression(JRFillBand.java:350) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:259) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:746) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.lang.Thread.run(Thread.java:785) Caused by: java.lang.IllegalStateException: NotesContext not initialized for the thread at com.ibm.domino.xsp.module.nsf.NotesContext.getCurrent(NotesContext.java:123) at com.ibm.domino.xsp.module.nsf.ModuleClassLoader$DynamicClassLoader.loadClass(ModuleClassLoader.java:416) at java.lang.ClassLoader.loadClass(ClassLoader.java:809) The "NotesContext not initialized for the thread" error has been a thorn in my side many times... it seems the report will run right past it, and I've never been able to determine what causes it. [1B14:0010-1274] 10/18/2018 08:37:38 AM HTTP JVM: Error in CreatePDF: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: !$F{group3}.isEmpty(), cause: net.sf.jasperreports.engine.fill.JRExpressionEval evaluating expression for source t [1B14:0010-1274] 10/18/2018 08:37:38 AM HTTP JVM: xt: !$F{group3}.isEmpty() [1B14:0010-1274] 10/18/2018 08:37:38 AM HTTP JVM: Root cause: service com.ibm.domino.xsp.bridge.http.engine.XspCmdManager [1B14:0010-1274] 10/18/2018 08:37:38 AM HTTP JVM: Penultimate cause: method=service class=com.ibm.designer.runtime.domino.adapter.LCDEnvironment line=313 <band height="15" splitType="Prevent"> <printWhenExpression><![CDATA[!$F{qnotes3}.isEmpty()]]></printWhenExpression> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToBandHeight" x="42" y="0" width="356" height="15" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true" uuid="214f58ed-995e-4a86-826c-21700f1bc5ca"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{qnotes3}]]></textFieldExpression> </textField> </band> Can someone point me in the right direction to get this resolved?
  7. After serveral days with no response here, I again began scouring the web for any possible hints at a solution. I stumbled across this post https://stackoverflow.com/questions/2746561/how-to-show-an-image-on-jasper-report It led me to my problem because I had the company logo image hard coded in Jasper. Problem solved. I hope this post helps someone else.
  8. My java code generates a Jasper PDF fine on my laptop, but when I put it on the customer server, I get this error. I'm testing with the exact same data in both cases. Here is the stack trace: 1/23/18 8:51 PM: Exception Thrown Context Path: /webapps/test/webecm.nsf Page Name: /Quote.xsp Control id: link24 Property: onclick Script interpreter error, line=10, col=5: Error calling method 'reportToFile(string)' on java class 'com.nhkseating.jasper.CreatePDF' 8: //pdf.reportToFile(docnum,testing); 9: print("calling reporttofile for "+docnum) -> 10: pdf.reportToFile(docnum); 11: 12: print("PDF complete, creating preview doc...") javax.faces.FacesException: Error while executing JavaScript action expression at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:102) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:210) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:96) at com.ibm.xsp.controller.FacesControllerImpl.execute(FacesControllerImpl.java:256) at com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:228) at com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:157) at com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:160) at com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:138) at com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:103) at com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:576) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:1335) at com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:853) at com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:796) at com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:565) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:1319) at com.ibm.domino.xsp.module.nsf.NSFService.doServiceInternal(NSFService.java:662) at com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:482) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:357) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:313) at com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:272) Caused by: com.ibm.xsp.exception.EvaluationExceptionEx: Error while executing JavaScript action expression at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:126) at com.ibm.xsp.actions.ExecuteScriptAction.invoke(ExecuteScriptAction.java:78) at com.ibm.xsp.actions.ActionGroup.invoke(ActionGroup.java:135) at com.ibm.xsp.application.ActionListenerImpl.processAction(ActionListenerImpl.java:60) at javax.faces.component.UICommand.broadcast(UICommand.java:324) at com.ibm.xsp.component.UIEventHandler.broadcast(UIEventHandler.java:366) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIViewRootEx.broadcast(UIViewRootEx.java:1535) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:307) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:428) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:94) ... 19 more Caused by: com.ibm.jscript.InterpretException: Script interpreter error, line=10, col=5: Error calling method 'reportToFile(string)' on java class 'com.nhkseating.jasper.CreatePDF' at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:334) at com.ibm.jscript.types.FBSObject.call(FBSObject.java:161) at com.ibm.jscript.ASTTree.ASTCall.interpret(ASTCall.java:197) at com.ibm.jscript.ASTTree.ASTProgram.interpret(ASTProgram.java:119) at com.ibm.jscript.ASTTree.ASTProgram.interpretEx(ASTProgram.java:139) at com.ibm.jscript.JSExpression._interpretExpression(JSExpression.java:435) at com.ibm.jscript.JSExpression.access$1(JSExpression.java:424) at com.ibm.jscript.JSExpression$2.run(JSExpression.java:414) at java.security.AccessController.doPrivileged(AccessController.java:362) at com.ibm.jscript.JSExpression.interpretExpression(JSExpression.java:410) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:251) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:234) at com.ibm.xsp.javascript.JavaScriptInterpreter.interpret(JavaScriptInterpreter.java:222) at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:111) ... 35 more Caused by: java.lang.RuntimeException: error in CreatePDF: at com.nhkseating.jasper.CreatePDF.reportToFile(CreatePDF.java:100) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:321) ... 48 more Caused by: java.lang.IllegalArgumentException: name at sun.misc.URLClassPath$Loader.findResource(URLClassPath.java:689) at sun.misc.URLClassPath.findResource(URLClassPath.java:266) at java.net.URLClassLoader$4.run(URLClassLoader.java:763) at java.security.AccessController.doPrivileged(AccessController.java:298) at java.net.URLClassLoader.findResource(URLClassLoader.java:760) at com.ibm.domino.xsp.module.nsf.ModuleClassLoader$DynamicClassLoader.findResource(ModuleClassLoader.java:519) at java.lang.ClassLoader.getResource(ClassLoader.java:456) at com.ibm.domino.xsp.module.nsf.ModuleClassLoader.getResource(ModuleClassLoader.java:202) at net.sf.jasperreports.engine.util.JRResourcesUtil.findClassLoaderResource(JRResourcesUtil.java:569) at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:110) at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:47) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:159) at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:190) at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:206) at net.sf.jasperreports.engine.RenderableUtil.getRenderable(RenderableUtil.java:122) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:584) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:520) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:281) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:504) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:431) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:392) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:253) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:122) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:583) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:929) at com.nhkseating.jasper.CreatePDF.reportToFile(CreatePDF.java:78) ... 53 more Here is my main code: package com.nhkseating.jasper; import java.io.Serializable; import java.util.HashMap; import java.util.Map; import java.util.ArrayList; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; public class CreatePDF implements Serializable { private static final long serialVersionUID = 1L; public CreatePDF(){ //for managed bean } // public static void main(String[] args) throws JRException, IOException { public void reportToFile(String docnum) { try { System.out.println("CreatePDF passing parameters to Jasper..."); String jasperReport = ""; String subReportItems = ""; String subReportTools = ""; String subReportNotes = ""; String destReport = ""; jasperReport = "D://JReports/NHK_Quote_Java.jasper"; subReportItems = "D://JReports/NHK_Items_Java.jasper"; subReportTools = "D://JReports/NHK_Tools_Java.jasper"; subReportNotes = "D://JReports/NHK_Notes_Java.jasper"; destReport = "D://JReports/"+docnum+".pdf"; System.out.println("setting parameters"); // Parameters for report, pass the file paths to the subreports as parameters on the main report Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("SubReportItems", subReportItems); parameters.put("SubReportTools", subReportTools); parameters.put("SubReportNotes", subReportNotes); // DataSource System.out.println("setting beancol datasrc"); DataBeanList DataBeanList = new DataBeanList(); ArrayList<DataBean> dataList = DataBeanList.getDataBeanList(docnum); JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(dataList); System.out.println("calling jasperfillmgr"); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,beanColDataSource); //System.out.println("calling exporttopdf"); // Export to PDF. JasperExportManager.exportReportToPdfFile(jasperPrint,destReport); System.out.println("CreatePDF Complete"); } catch (Exception e) { System.out.println("Error in CreatePDF: " + e); throw new RuntimeException("error in CreatePDF: ", e); } } } The server console shows where the error occurs, on the fillReport line: [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: calling reporttofile for Q00039 [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: CreatePDF passing parameters to Jasper... [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: setting parameters [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: setting beancol datasrc [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: calling jasperfillmgr [0B04:000A-0F74] 01/23/2018 08:51:50 PM HTTP JVM: Error in CreatePDF: java.lang.IllegalArgumentException: name Can someone point me in the right direction as to what may be wrong here? Remember, I can output this same document fine on my laptop, so I'm sure it isn't a 'bad data' issue.
  9. This error occurs while using an IBM XWork server and Java to populate a Jasper Report. (using Windows Server 2008) I created a java.pol add on policy file that includes permission java.lang.RuntimePermission "getProtectionDomain"; So, why do I get Access Denied and how do I resolve it? 1/18/18 8:24 PM: Exception Thrown Context Path: /webapps/test/webecm.nsf Page Name: /Quote.xsp Control id: link24 Property: onclick Script interpreter error, line=10, col=5: Error calling method 'reportToFile(string)' on java class 'com.nhkseating.jasper.CreatePDF' 8: //pdf.reportToFile(docnum,testing); 9: print("calling reporttofile for "+docnum) -> 10: pdf.reportToFile(docnum); 11: 12: print("PDF complete, creating preview doc...") javax.faces.FacesException: Error while executing JavaScript action expression at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:102) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:210) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:96) at com.ibm.xsp.controller.FacesControllerImpl.execute(FacesControllerImpl.java:256) at com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:228) at com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:157) at com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:160) at com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:138) at com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:103) at com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:576) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:1335) at com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:853) at com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:796) at com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:565) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:1319) at com.ibm.domino.xsp.module.nsf.NSFService.doServiceInternal(NSFService.java:662) at com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:482) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:357) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:313) at com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:272) Caused by: com.ibm.xsp.exception.EvaluationExceptionEx: Error while executing JavaScript action expression at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:126) at com.ibm.xsp.actions.ExecuteScriptAction.invoke(ExecuteScriptAction.java:78) at com.ibm.xsp.actions.ActionGroup.invoke(ActionGroup.java:135) at com.ibm.xsp.application.ActionListenerImpl.processAction(ActionListenerImpl.java:60) at javax.faces.component.UICommand.broadcast(UICommand.java:324) at com.ibm.xsp.component.UIEventHandler.broadcast(UIEventHandler.java:366) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIViewRootEx.broadcast(UIViewRootEx.java:1535) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:307) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:428) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:94) ... 19 more Caused by: com.ibm.jscript.InterpretException: Script interpreter error, line=10, col=5: Error calling method 'reportToFile(string)' on java class 'com.nhkseating.jasper.CreatePDF' at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:334) at com.ibm.jscript.types.FBSObject.call(FBSObject.java:161) at com.ibm.jscript.ASTTree.ASTCall.interpret(ASTCall.java:197) at com.ibm.jscript.ASTTree.ASTProgram.interpret(ASTProgram.java:119) at com.ibm.jscript.ASTTree.ASTProgram.interpretEx(ASTProgram.java:139) at com.ibm.jscript.JSExpression._interpretExpression(JSExpression.java:435) at com.ibm.jscript.JSExpression.access$1(JSExpression.java:424) at com.ibm.jscript.JSExpression$2.run(JSExpression.java:414) at java.security.AccessController.doPrivileged(AccessController.java:362) at com.ibm.jscript.JSExpression.interpretExpression(JSExpression.java:410) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:251) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:234) at com.ibm.xsp.javascript.JavaScriptInterpreter.interpret(JavaScriptInterpreter.java:222) at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:111) ... 35 more Caused by: java.lang.RuntimeException: error in CreatePDF: at com.nhkseating.jasper.CreatePDF.reportToFile(CreatePDF.java:100) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:321) ... 48 more Caused by: net.sf.jasperreports.engine.JRException: Error loading expression class: NHK_Quote_Java32_1516309149450_945174. at net.sf.jasperreports.engine.design.JRAbstractJavaCompiler.loadEvaluator(JRAbstractJavaCompiler.java:118) at net.sf.jasperreports.engine.design.JRAbstractCompiler.loadEvaluator(JRAbstractCompiler.java:358) at net.sf.jasperreports.engine.JasperCompileManager.getEvaluator(JasperCompileManager.java:381) at net.sf.jasperreports.engine.fill.JRFillDataset.createCalculator(JRFillDataset.java:467) at net.sf.jasperreports.engine.fill.BaseReportFiller.<init>(BaseReportFiller.java:152) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:239) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:69) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:57) at net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:201) at net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:216) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:116) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:583) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:929) at com.nhkseating.jasper.CreatePDF.reportToFile(CreatePDF.java:78) ... 53 more Caused by: java.security.AccessControlException: Access denied (java.lang.RuntimePermission getProtectionDomain) at java.security.AccessController.throwACE(AccessController.java:100) at java.security.AccessController.checkPermission(AccessController.java:174) at java.lang.SecurityManager.checkPermission(SecurityManager.java:544) at java.lang.Class.getProtectionDomain(Class.java:1338) at net.sf.jasperreports.engine.util.JRClassLoader.getProtectionDomainFactory(JRClassLoader.java:45) at net.sf.jasperreports.engine.util.JRClassLoader.getProtectionDomain(JRClassLoader.java:325) at net.sf.jasperreports.engine.util.JRClassLoader.loadClass(JRClassLoader.java:337) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassFromBytes(JRClassLoader.java:238) at net.sf.jasperreports.engine.design.JRAbstractJavaCompiler.loadEvaluator(JRAbstractJavaCompiler.java:104) ... 66 more Where Line 78 reads JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,beanColDataSource);
  10. I'm still struggling to get this Java approach to work. But, I think I did figure out the error for NotesContext not initialized. For me, the problem was that I was using the field name directly as my Sub-Report Data Source Expression. However, the proper format for the Data Source Expression is actually... new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{subReportBeanList}) In my current project, I was finally able to get one subreport to work. But, in this new case, I have 3 subreports and the second one doesn't want to cooperate. Now, I get a field exception error for java.lang.Integer(1) - which is strange because all my fields are Strings. Hope this helps.
  11. I'm developing a set of Java beans to pass Notes/Domino data directly to a Jasper PDF report. I was successful creating a hard coded report with a sub-report, but when I tried to apply the same principles using Domino data, I received the above error. My actual report contains a sub-report and also a sub-subreport within that. During my debugging, I removed both the sub-report and the sub-subreport and then I was able to create the PDF with Domino data successfully. Feeling "smart", I put the first sub-report back in - no dice. Got the NotesContext error again. I then tried removing all the fields on the sub-report except for one - no difference. I then removed the last field on the sub-report. Nope, that didn't work either. So, I'm stumped and hoping someone here can direct me to what I'm missing. This is my managed bean: import java.io.Serializable; import java.util.HashMap; import java.util.Map; import java.util.ArrayList; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; public class CreatePDFNoSubs implements Serializable { private static final long serialVersionUID = 1L; public CreatePDFNoSubs(){ //for managed bean } public void reportToFileNoSubs(String docnum) { try { System.out.println("setting reportname"); String jasperReport = "C://Users/RPo/Documents/Bob/Jasper Reports/HSD/HSD_Quote_JavaNoSubs.jasper"; String subReportWS = "C://Users/RPo/Documents/Bob/Jasper Reports/HSD/HSD_QuoteWS_JavaNoMisc.jasper"; String subReportMisc = "C://Users/RPo/Documents/Bob/Jasper Reports/HSD/HSD_QuoteMisc_Java.jasper"; String destReport = "C://JReports//HSD//"+docnum+".pdf"; System.out.println("setting parameters"); // Parameters for report Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("SubReportWS", subReportWS); parameters.put("SubReportMisc", subReportMisc); // DataSource System.out.println("setting beancol datasrc"); DataBeanListNoSubs DataBeanList = new DataBeanListNoSubs(); ArrayList<DataBeanNoSubs> dataList = DataBeanList.getDataBeanListNoSubs(docnum); JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(dataList); System.out.println("calling jasperfillmgr"); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,beanColDataSource); System.out.println("calling exporttopdf"); // Export to PDF. JasperExportManager.exportReportToPdfFile(jasperPrint,destReport); } catch (Exception e) { System.out.println("Error in CreatePDF: " + e); throw new RuntimeException("error in CreatePDF: ", e); } } } All of the Domino data gathering is done in this bean, import java.util.*; import lotus.domino.*; import com.ibm.xsp.model.domino.DominoUtils; public class DataBeanListNoSubs { // *** no sub report bean collections *** public ArrayList<DataBeanNoSubs> getDataBeanListNoSubs(String docnum) { //create the array to return ArrayList<DataBeanNoSubs> dataBeanList = new ArrayList<DataBeanNoSubs>(); //this will be a single record array consisting of a series of fields and array of ws subreport //fields that contains another array of misc subsubreport fields try{ Session sess = DominoUtils.getCurrentSession(); Database db = sess.getCurrentDatabase(); View baseview = db.getView("QuoteLetterBase_Java"); View wsview = db.getView("QuoteLetterWS"); // View miscview = db.getView("QuoteLetterMisc"); System.out.println("setting base data"); //get the base data ViewEntry ventry = baseview.getEntryByKey(docnum,true); String repquote = ventry.getColumnValues().get(1).toString(); String custname = ventry.getColumnValues().get(2).toString(); String custnum = ventry.getColumnValues().get(3).toString(); String custadd_2 = ventry.getColumnValues().get(4).toString(); String custadd_3 = ventry.getColumnValues().get(5).toString(); String custadd_4 = ventry.getColumnValues().get(6).toString(); String custadd_5 = ventry.getColumnValues().get(7).toString(); String custadd_6 = ventry.getColumnValues().get(8).toString(); String contact = ventry.getColumnValues().get(9).toString(); String contactemail = ventry.getColumnValues().get(10).toString(); String contactphone = ventry.getColumnValues().get(11).toString(); String program = ventry.getColumnValues().get(12).toString(); String inqnum = ventry.getColumnValues().get(13).toString(); String fob = ventry.getColumnValues().get(14).toString(); String terms = ventry.getColumnValues().get(15).toString(); String estimator = ventry.getColumnValues().get(16).toString(); String saleseng = ventry.getColumnValues().get(17).toString(); String expires = ventry.getColumnValues().get(18).toString(); String qnotes = ventry.getColumnValues().get(19).toString(); String bottomterms = ventry.getColumnValues().get(20).toString(); String tmp = ventry.getColumnValues().get(21).toString(); Double totalquote = Double.parseDouble(tmp); String docnumoption = ventry.getColumnValues().get(22).toString(); String datesentoption = ventry.getColumnValues().get(23).toString(); String id = ventry.getColumnValues().get(24).toString(); String draft = ventry.getColumnValues().get(25).toString(); String contactscc = ventry.getColumnValues().get(26).toString(); //get the wsdata as an array ViewEntryCollection vecol = wsview.getAllEntriesByKey(docnum,true); ArrayList<SubReportBeanWSNoSubs> wssubRepList = new ArrayList<SubReportBeanWSNoSubs>(); if(vecol.getCount()>0){ ViewEntry wsventry = vecol.getFirstEntry(); while(wsventry!=null){ String line = wsventry.getColumnValues().get(2).toString(); System.out.println("setting wsdata for line "+line); String group1 = wsventry.getColumnValues().get(3).toString(); // String group2 = wsventry.getColumnValues().get(4).toString(); // String group3 = wsventry.getColumnValues().get(5).toString(); // String group4 = wsventry.getColumnValues().get(6).toString(); // String qnotes1 = wsventry.getColumnValues().get(8).toString(); // String qnotes2 = wsventry.getColumnValues().get(9).toString(); // String qnotes3 = wsventry.getColumnValues().get(10).toString(); // String qnotes4 = wsventry.getColumnValues().get(11).toString(); // String qnotes5 = wsventry.getColumnValues().get(12).toString(); // String qnotes6 = wsventry.getColumnValues().get(13).toString(); // String qnotes7 = wsventry.getColumnValues().get(14).toString(); // String qnotes8 = wsventry.getColumnValues().get(15).toString(); // String qnotes9 = wsventry.getColumnValues().get(16).toString(); // String qnotes10 = wsventry.getColumnValues().get(17).toString(); // String tmpws = wsventry.getColumnValues().get(18).toString(); // Double totalquotews = Double.parseDouble(tmpws); // String wsdocnum = wsventry.getColumnValues().get(19).toString(); /* System.out.println("- - - checking misc data"); //get the misc data list as an array ArrayList<SubReportBeanMisc> miscsubRepList = new ArrayList<SubReportBeanMisc>(); ViewEntryCollection miscvecol = miscview.getAllEntriesByKey(wsdocnum,true); if(miscvecol.getCount()>0){ ViewEntry miscventry = miscvecol.getFirstEntry(); while(miscventry!=null){ System.out.println("getting misc data for line "+line); String miscgroup1 = miscventry.getColumnValues().get(3).toString(); String tmpmisc = miscventry.getColumnValues().get(9).toString(); Double totalquotemisc = Double.parseDouble(tmpmisc); //create a misc bean to store in the misc array SubReportBeanMisc miscsubbean = new SubReportBeanMisc(); miscsubbean.setGroup1(miscgroup1); miscsubbean.setTotalquote(totalquotemisc); miscsubRepList.add(miscsubbean); ViewEntry tmpmiscve = miscvecol.getNextEntry(miscventry); miscventry.recycle(); miscventry = tmpmiscve; } } miscvecol.recycle(); */ System.out.println("setting subreportbeanws"); //create a ws bean to store in the base array SubReportBeanWSNoSubs wssubbean = new SubReportBeanWSNoSubs(); // wssubbean.setLine(line); // wssubbean.setGroup1(group1); /* wssubbean.setGroup2(group2); wssubbean.setGroup3(group3); wssubbean.setGroup4(group4); wssubbean.setQnotes1(qnotes1); wssubbean.setQnotes2(qnotes2); wssubbean.setQnotes3(qnotes3); wssubbean.setQnotes4(qnotes4); wssubbean.setQnotes5(qnotes5); wssubbean.setQnotes6(qnotes6); wssubbean.setQnotes7(qnotes7); wssubbean.setQnotes8(qnotes8); wssubbean.setQnotes9(qnotes9); wssubbean.setQnotes10(qnotes10); */ // wssubbean.setTotalquote(totalquotews); // wssubbean.setWsdocnum(wsdocnum); // wssubbean.setSubReportBeanMiscList(miscsubRepList); wssubRepList.add(wssubbean); ViewEntry tmpve = vecol.getNextEntry(wsventry); wsventry.recycle(); wsventry = tmpve; } vecol.recycle(); } System.out.println("setting databeanlist"); //create the base quote bean array dataBeanList.add(produce(docnum,repquote,custname,custnum,custadd_2,custadd_3,custadd_4,custadd_5,custadd_6,contact,contactemail,contactphone, program,inqnum,fob,terms,estimator,saleseng,expires,qnotes,bottomterms,totalquote,docnumoption,datesentoption,id,draft,contactscc,wssubRepList)); ventry.recycle(); baseview.recycle(); wsview.recycle(); // miscview.recycle(); } catch(NotesException e){ System.out.println("Error in DataBeanList: " + e); } return dataBeanList; } /** * This method returns a DataBean object, * with all the fields for the main report in it (and an array for the WS subreport * which contains an array for th misc subreport) */ private DataBeanNoSubs produce(String qnum, String repquote, String custname, String custnum, String custadd_2, String custadd_3, String custadd_4, String custadd_5, String custadd_6, String contact, String contactemail, String contactphone, String program, String inqnum, String fob, String terms, String estimator, String saleseng, String expires, String qnotes, String bottomterms, Double totalquote, String docnumoption, String datesentoption, String id, String draft, String contactscc, List<SubReportBeanWSNoSubs> subBean) { DataBeanNoSubs dataBean = new DataBeanNoSubs(); dataBean.setDocnum(qnum); dataBean.setRepquote(repquote); dataBean.setCustname(custname); dataBean.setCustnum(custnum); dataBean.setCustadd_2(custadd_2); dataBean.setCustadd_3(custadd_3); dataBean.setCustadd_4(custadd_4); dataBean.setCustadd_5(custadd_5); dataBean.setCustadd_6(custadd_6); dataBean.setContact(contact); dataBean.setContactemail(contactemail); dataBean.setContactphone(contactphone); dataBean.setProgram(program); dataBean.setInqnum(inqnum); dataBean.setFob(fob); dataBean.setTerms(terms); dataBean.setEstimator(estimator); dataBean.setSaleseng(saleseng); dataBean.setExpires(expires); dataBean.setQnotes(qnotes); dataBean.setBottomterms(bottomterms); dataBean.setTotalquote(totalquote); dataBean.setDocnumoption(docnumoption); dataBean.setDatesentoption(datesentoption); dataBean.setId(id); dataBean.setDraft(draft); dataBean.setContactscc(contactscc); dataBean.setSubReportBeanWSList(subBean); return dataBean; } } My output on the server log is as follows: 3: var pdf = new com.hsdomino.jasper.CreatePDFNoSubs; -> 4: pdf.reportToFileNoSubs(docnum) javax.faces.FacesException: Error while executing JavaScript action expression at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:102) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:210) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:96) at com.ibm.xsp.controller.FacesControllerImpl.execute(FacesControllerImpl.java:256) at com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:227) at com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:157) at com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:159) at com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:138) at com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:103) at com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:588) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:1335) at com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:865) at com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:808) at com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:577) at com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:1319) at com.ibm.domino.xsp.module.nsf.NSFService.doServiceInternal(NSFService.java:662) at com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:482) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:357) at com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:313) at com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:272) Caused by: com.ibm.xsp.exception.EvaluationExceptionEx: Error while executing JavaScript action expression at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:126) at com.ibm.xsp.actions.ExecuteScriptAction.invoke(ExecuteScriptAction.java:78) at com.ibm.xsp.application.ActionListenerImpl.processAction(ActionListenerImpl.java:60) at javax.faces.component.UICommand.broadcast(UICommand.java:324) at com.ibm.xsp.component.UIEventHandler.broadcast(UIEventHandler.java:366) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataIterator.broadcast(UIDataIterator.java:694) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIDataPanelBase.broadcast(UIDataPanelBase.java:400) at com.ibm.xsp.component.UIViewRootEx.broadcast(UIViewRootEx.java:1535) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:307) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:428) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:94) ... 19 more Caused by: com.ibm.jscript.InterpretException: Script interpreter error, line=4, col=5: Error calling method 'reportToFileNoSubs(string)' on java class 'com.hsdomino.jasper.CreatePDFNoSubs' at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:335) at com.ibm.jscript.types.FBSObject.call(FBSObject.java:161) at com.ibm.jscript.ASTTree.ASTCall.interpret(ASTCall.java:197) at com.ibm.jscript.ASTTree.ASTProgram.interpret(ASTProgram.java:119) at com.ibm.jscript.ASTTree.ASTProgram.interpretEx(ASTProgram.java:139) at com.ibm.jscript.JSExpression._interpretExpression(JSExpression.java:435) at com.ibm.jscript.JSExpression.access$1(JSExpression.java:424) at com.ibm.jscript.JSExpression$2.run(JSExpression.java:414) at java.security.AccessController.doPrivileged(AccessController.java:686) at com.ibm.jscript.JSExpression.interpretExpression(JSExpression.java:410) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:251) at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:234) at com.ibm.xsp.javascript.JavaScriptInterpreter.interpret(JavaScriptInterpreter.java:222) at com.ibm.xsp.binding.javascript.JavaScriptMethodBinding.invoke(JavaScriptMethodBinding.java:111) ... 35 more Caused by: java.lang.RuntimeException: error in CreatePDF: at com.hsdomino.jasper.CreatePDFNoSubs.reportToFileNoSubs(CreatePDFNoSubs.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:322) ... 48 more Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:874) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:536) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2024) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:121) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:583) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:929) at com.hsdomino.jasper.CreatePDFNoSubs.reportToFileNoSubs(CreatePDFNoSubs.java:59) ... 53 more Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:352) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:607) at net.sf.jasperreports.engine.fill.JRCalculator.estimateVariables(JRCalculator.java:208) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1276) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1250) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1056) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:736) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.lang.Thread.run(Thread.java:785) Caused by: java.lang.IllegalStateException: NotesContext not initialized for the thread at com.ibm.domino.xsp.module.nsf.NotesContext.getCurrent(NotesContext.java:123) at com.ibm.domino.xsp.module.nsf.ModuleClassLoader$DynamicClassLoader.loadClass(ModuleClassLoader.java:416) at java.lang.ClassLoader.loadClass(ClassLoader.java:809) at com.ibm.domino.xsp.module.nsf.ModuleClassLoader.loadClass(ModuleClassLoader.java:209) at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:842) at java.lang.ClassLoader.loadClass(ClassLoader.java:829) at java.lang.ClassLoader.loadClass(ClassLoader.java:809) at HSD_QuoteWS_Java_1494353558580_394739.evaluateEstimated(HSD_QuoteWS_Java_1494353558580_394739:295) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:338) HHere is the jrxml for the sub-report (now that all the fields have been removed)... <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.0 --> <!-- 2017-05-09T16:17:02 --> <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="HSD_QuoteWS_Java" pageWidth="612" pageHeight="792" columnWidth="612" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="8aaed2a5-8bac-4933-9304-27e8846d99e2"> <property name="ireport.zoom" value="2.0"/> <property name="ireport.x" value="307"/> <property name="ireport.y" value="0"/> <parameter name="SubReportMisc" class="java.lang.String" isForPrompting="false"/> <queryString language="SQL"> <![CDATA[]]> </queryString> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="31" splitType="Stretch"> <rectangle radius="5"> <reportElement mode="Transparent" x="0" y="5" width="562" height="20" uuid="0e552d18-c6c1-4227-9472-5daef19258fd"/> </rectangle> <staticText> <reportElement x="41" y="11" width="54" height="14" uuid="e36f55b6-dc75-4919-a1f3-4697be31d523"/> <textElement> <font size="8"/> </textElement> <text><![CDATA[Description]]></text> </staticText> <staticText> <reportElement x="445" y="11" width="37" height="14" uuid="e36f55b6-dc75-4919-a1f3-4697be31d523"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <text><![CDATA[Amount]]></text> </staticText> <staticText> <reportElement x="9" y="11" width="18" height="14" uuid="e36f55b6-dc75-4919-a1f3-4697be31d523"/> <textElement> <font size="8"/> </textElement> <text><![CDATA[Line]]></text> </staticText> </band> </columnHeader> <detail> <band height="26" splitType="Prevent"/> <band height="9"> <line> <reportElement positionType="Float" x="9" y="4" width="389" height="1" uuid="dd1009ff-efad-4dc1-991a-b8daff790e46"/> </line> </band> </detail> </jasperReport> This is the jrxml of the main report... <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.0 --> <!-- 2017-05-09T16:16:58 --> <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="HSD_Quote_JavaNoSubs" pageWidth="612" pageHeight="792" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e93f8f9b-eed3-4c03-ac1e-280ebc6ccd74"> <property name="ireport.zoom" value="2.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="131"/> <parameter name="SubReportMisc" class="java.lang.String" isForPrompting="false"/> <parameter name="SubReportWS" class="java.lang.String" isForPrompting="false"/> <queryString language="SQL"> <![CDATA[]]> </queryString> <field name="docnum" class="java.lang.String"/> <field name="repquote" class="java.lang.String"/> <field name="custname" class="java.lang.String"/> <field name="custnum" class="java.lang.String"/> <field name="custadd_2" class="java.lang.String"/> <field name="custadd_3" class="java.lang.String"/> <field name="custadd_4" class="java.lang.String"/> <field name="custadd_5" class="java.lang.String"/> <field name="custadd_6" class="java.lang.String"/> <field name="contact" class="java.lang.String"/> <field name="contactemail" class="java.lang.String"/> <field name="contactphone" class="java.lang.String"/> <field name="program" class="java.lang.String"/> <field name="inqnum" class="java.lang.String"/> <field name="fob" class="java.lang.String"/> <field name="terms" class="java.lang.String"/> <field name="estimator" class="java.lang.String"/> <field name="saleseng" class="java.lang.String"/> <field name="expires" class="java.lang.String"/> <field name="qnotes" class="java.lang.String"/> <field name="bottomterms" class="java.lang.String"/> <field name="totalquote" class="java.lang.Double"/> <field name="docnumoption" class="java.lang.String"/> <field name="datesentoption" class="java.lang.String"/> <field name="id" class="java.lang.String"/> <field name="draft" class="java.lang.String"/> <field name="contactscc" class="java.lang.String"/> <field name="subReportBeanWSList" class="java.util.List"/> <background> <band height="752" splitType="Stretch"> <image> <reportElement x="26" y="212" width="552" height="406" uuid="617c85fa-8d1b-4a12-b022-832a6dd83a5c"> <printWhenExpression><![CDATA[$F{draft}.equals( "Y" )]]></printWhenExpression> </reportElement> <imageExpression><![CDATA["C:\JReports\draft.gif"]]></imageExpression> </image> </band> </background> <pageHeader> <band height="215" splitType="Stretch"> <staticText> <reportElement x="391" y="18" width="178" height="31" forecolor="#003399" uuid="7587b061-1376-42ce-93d0-a5b6ba2ae6ae"/> <textElement textAlignment="Right"> <font size="20" isBold="true"/> </textElement> <text><![CDATA[QUOTATION]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="79" y="198" width="204" height="15" isRemoveLineWhenBlank="true" uuid="0e1186fe-aa6e-4f17-b0e8-8090cfa65b11"> <printWhenExpression><![CDATA[$V{PAGE_NUMBER}.equals( 1 )]]></printWhenExpression> </reportElement> <textElement> <font size="8" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{program}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="79" y="154" width="204" height="15" isRemoveLineWhenBlank="true" uuid="d485138e-b5fc-4134-81c2-55b872c8cdbe"> <printWhenExpression><![CDATA[$V{PAGE_NUMBER}.equals( 1 )]]></printWhenExpression> </reportElement> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{contactemail}]]></textFieldExpression> </textField> <staticText> <reportElement x="144" y="12" width="100" height="15" uuid="5c931d7d-4a48-4a55-b788-ab4a86a9805b"/> <textElement> <font size="8"/> </textElement> <text><![CDATA[O-222 Lake Michigan Drive]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="388" y="147" width="170" height="34" isRemoveLineWhenBlank="true" uuid="51e655c6-d0ac-4bbe-9db4-851667a042c4"> <printWhenExpression><![CDATA[$V{PAGE_NUMBER}.equals( 1 )]]></printWhenExpression> </reportElement> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{terms}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="79" y="143" width="204" height="15" isRemoveLineWhenBlank="true" uuid="eec703a9-d16e-4c3e-82d4-cb93ca92a498"> <printWhenExpression><![CDATA[$V{PAGE_NUMBER}.equals( 1 )]]></printWhenExpression> </reportElement> <textElement> <font size="8" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{contact}]]></textFieldExpression> </textField> <textField pattern=""> <reportElement x="468" y="49" width="100" height="20" uuid="c084dfb9-6d66-4946-839d-2536fda9120c"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$F{datesentoption}==null?new java.util.Date().toString():$F{datesentoption}]]></textFieldExpression> </textField> <staticText> <reportElement x="304" y="78" width="76" height="20" uuid="5b8a4ff6-824b-43e9-ae1c-527fedba034b"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <text><![CDATA
×
×
  • Create New...