Zen reports - Error rendering Excel output

TrakCare, Caché

Hi,

We maintain a few Zen reports that output in Excel format.

Recently we started to observe that some reports fail and return the following error.

CSP error occurred
Error: Error rendering: OS code =1Use $log=1 to check
ErrorNo: 5001

I have extracted the exception details from the log file

java.lang.OutOfMemoryError: Java heap space
at com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.createElementNS(Unknown Source)
at com.sun.org.apache.xalan.internal.xsltc.trax.SAX2DOM.startElement(Unknown Source)
at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.closeStartTag(Unknown Source)
  at com.sun.org.apache.xml.internal.serializer.ToSAXHandler.flushPending(Unknown Source)
  at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.startElement(Unknown Source)
  at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.startElement(Unknown Source)
  at GregorSamsa.urn$colon$schemas$dash$microsoft$dash$com$colon$office$colon$spreadsheet$colon$template$dot$4()
  at GregorSamsa.applyTemplates1()
  at GregorSamsa.urn$colon$schemas$dash$microsoft$dash$com$colon$office$colon$spreadsheet$colon$template$dot$2()
  at GregorSamsa.applyTemplates1()
  at GregorSamsa.urn$colon$schemas$dash$microsoft$dash$com$colon$office$colon$spreadsheet$colon$template$dot$1()
  at GregorSamsa.applyTemplates1()
  at GregorSamsa.urn$colon$schemas$dash$microsoft$dash$com$colon$office$colon$spreadsheet$colon$template$dot$0()
  at GregorSamsa.applyTemplates()
  at GregorSamsa.transform()
  at com.sun.org.apache.xalan.internal.xsltc.runtime.AbstractTranslet.transform(Unknown Source)
  at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(Unknown Source)
  at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(Unknown Source)
  at com.intersys.excel.ExportAsExcel.go(ExportAsExcel.java:117)
  at com.intersys.excel.ExportAsExcel.run(ExportAsExcel.java:265)
  at com.intersys.excel.ExportAsExcel.main(ExportAsExcel.java:271)
  at com.intersys.excel.ExportWithoutServer.main(ExportWithoutServer.java:24)

Has anyone seen this exception rendering Zen Reports?

Regards,

Rui
 

  • 0
  • 0
  • 159
  • 0
  • 1

Answers

JVM is probably out of memory. Try this.

1. Define Excel server at SMP > System > Configuration > Zen Report Excel Servers > Zen Report Excel Server, let's say at port 44444

2. Start it. Copy OS command. Should be something like:

C:\InterSystems\Ensemble\lib\ExcelExporter\runserver.bat -port 44444 -numthreads 5 -loglevel 3 -maxlogfilesize 32000 -logrotationcount 100 -numpingthreads 5 -pingport 44445 2>&1

3. Stop Excel server

4. Execute the command from 2 in OS terminal, but set JVM heap size. See how.

5. In your ZEN report add:

Parameter EXCELSERVER = 44444;

to use your excel server.

6. Recompile report and try to run it again.