[CLOSED] Out of memory issue while rendering graph

March 20, 2012, 01:42 PM

I am trying to test Graph component using following code. But Iam getting Out of memory error when I try to run my .fex file. I have increased the heapsize to 1024M, but still getting the same error. Please help.

-* File graphtest.fex
ENGINE SQLORA SET DEFAULT_CONNECTION WAND
SQL SQLORA PREPARE SQLOUT FOR
SELECT DISTINCT REQ_STATUS AS STATUS, COUNT(REQUISITION_ID) OVER (PARTITION BY REQ_STATUS) AS REQ_COUNT FROM REQUISITION_VIEW WHERE REQ_CLIENTID = 33
END
TABLE FILE SQLOUT
PRINT
STATUS
COMPUTE REQCOUNT/I11 = REQ_COUNT;
ON TABLE HOLD AS TEMPHOLD
END
TABLE FILE TEMPHOLD
PRINT
TEMPHOLD.TEMPHOLD.STATUS
TEMPHOLD.TEMPHOLD.REQCOUNT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
GRAPH FILE TEMPHOLD
SUM TEMPHOLD.TEMPHOLD.REQCOUNT
ACROSS TEMPHOLD.TEMPHOLD.STATUS
HEADING
"REQUISITION STATUS GRAPH FOR GENENTECH"
FOOTING
"PREPARED ON <+0>&DATEtrMDYY <+0> "
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBIBeveledOnTan.txt");
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
$
TYPE=REPORT,
BACKCOLOR='NONE',
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BACKCOLOR='SILVER',
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='COMIC SANS MS',
SIZE=14,
COLOR='BLACK',
STYLE=BOLD+UNDERLINE,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='COMIC SANS MS',
SIZE=8,
COLOR='MAROON',
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
FONT='COMIC SANS MS',
SIZE=8,
COLOR='MAROON',
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
FONT='COMIC SANS MS',
SIZE=8,
COLOR='MAROON',
STYLE=BOLD,
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,

March 20, 2012, 01:44 PM

venk

This is the error I get.

javax.servlet.ServletException: Servlet execution threw an exception
com.ibi.custom.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:253)
com.ibi.filters.PKIFilter.doFilter(PKIFilter.java:94)
com.ibi.monitor.URLFilter.doFilter(URLFilter.java:80)

root cause

java.lang.OutOfMemoryError: Java heap space
java.lang.Class.getDeclaredMethods0(Native Method)
java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
java.lang.Class.privateGetPublicMethods(Class.java:2547)
java.lang.Class.privateGetPublicMethods(Class.java:2563)
java.lang.Class.privateGetPublicMethods(Class.java:2563)
java.lang.Class.getMethods(Class.java:1410)
com.tdg.TDGProperties.growMethodsTree(TDGProperties.java:1462)
com.tdg.Perspective.deSerializationInit(Perspective.java:5385)
com.tdg.Perspective.(Perspective.java:4024)
com.tdg.Perspective.(Perspective.java:3933)
ibi.srv.graph.IBIPerspectiveObjectNew.(IBIPerspectiveObjectNew.java:384)
ibi.srv.graph.PerspectivePool.createPoolElement(PerspectivePool.java:25)
ibi.util.Pool.createPool(Pool.java:37)
ibi.srv.graph.GraphPersistentState.createPool(GraphPersistentState.java:187)
ibi.srv.graph.GraphPersistentState.initialize(GraphPersistentState.java:107)
ibi.srv.graph.WFServletGraphGenerator.(WFServletGraphGenerator.java:96)
ibi.webfoc.wfapi.IBICreateCGIGif.(IBICreateCGIGif.java:591)
ibi.webfoc.wfapi.WFReport.convertGraphAppletIntoSSG(WFReport.java:4189)
ibi.webfoc.wfapi.WFReport.fetchReportData(WFReport.java:1779)
ibi.webfoc.wfapi.WFReport.(WFReport.java:1000)
ibi.webfoc.wfapi.WFPresentation.addReport(WFPresentation.java:740)
ibi.webfoc.wfapi.WFPresentation.(WFPresentation.java:621)
ibi.webfoc.wfapi.WFSession.getPresentation(WFSession.java:1021)
ibi.webfoc.WFRequestWorker.processRequest(WFRequestWorker.java:1032)
ibi.webfoc.WFRequestWorker.processRequest(WFRequestWorker.java:567)
ibi.webfoc.WFWorkerUtil.processRequest(WFWorkerUtil.java:414)
ibi.webfoc.WFServlet.processRequest(WFServlet.java:821)
ibi.webfoc.WFServlet.processRequest(WFServlet.java:793)
ibi.webfoc.WFServlet.doPost(WFServlet.java:774)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
ibi.srv.util.IBIHttpServlet.service(IBIHttpServlet.java:121)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.20 logs.