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,

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.

WebFOCUS 7.6
Windows, All Outputs

Hi venk,

If you have not done so, please open a case with Customer Support Services, so that there will be an assigned person to look into the log files and help you with the issue. The phone number is 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry