I am attempting to create our very first graph and get the following error on submitting the fex:
"An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. The application server log contains information on why this error has occurred. Contact your WebFOCUS Administrator or Information Builders Customer Support Services for further assistance."
Can someone tell me how I can view the application server log? Are we missing a component?
This is a simple piece of code I put together to try and test the graph:
-* File newfex.fex TABLE FILE SALES SUM UNIT_SOLD BY CITY WHERE RECORDLIMIT EQ 200 ON TABLE HOLD AS H_SALES END -RUN
GRAPH FILE H_SALES SUM UNIT_SOLD ACROSS CITY ON GRAPH SET LOOKGRAPH VBAR 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 SET GRAPHSTYLE * setMarkerDisplay(true); setConnectLineMarkers(false); setConnectScatterMarkers(false); setO1LabelDisplay(true); setO1AxisSide(0); setO1MajorGridDisplay(true); setO1MajorGridStyle(0); setO1MinorGridDisplay(false); setAxisAssignment(0,0); setSeriesType(0,1); 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); setPlace(true); ENDSTYLE ON GRAPH SET STYLE * PAGESIZE='Letter', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000, TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, BACKCOLOR='NONE', STYLE=NORMAL, $ ENDSTYLE END
Perhaps someone can try and run this for me and see if it works for you?
Many thanks
Mark.
WebFocus 765. iSeries v5r4
April 11, 2007, 09:48 AM
Tom Flynn
Mark,
Works fine on my local 7.6 machine. Is your Graphics Package enabled? That is the usual error when graphics is not enabled...
Can you tell me how / where I can check if the graphics are enabled?
WebFocus 765. iSeries v5r4
April 11, 2007, 10:04 AM
Tom Flynn
Mark,
Look on the web console, not the reporting server. There will be a GRAPHICS selection under Configuration(for 7.6). Don't recall 5.3.5, S/B the same...This message has been edited. Last edited by: Tom Flynn,
I have just found the Web Console (we are in some real need of some technical training here!) and I have located the Graph under Client Settings. The first setting, ENABLE_SSG was set to NO. Could this be it? I have set it to YES but I still get the same error. Do you think we would have to restart the software for the setting to take effect?
Thanks for you help!
Mark
WebFocus 765. iSeries v5r4
April 11, 2007, 10:29 AM
Tom Flynn
Mark,
Good, learning a bit as well..
ENABLE_SSG: YES IBIF_graphengine: Select GRAPH53 button IBIF_graphservurl: &URL_PROTOCOL://&SERVER_NAME:&SERVER_PORT&IBIF_webapp/IBIGraphServlet IBIF_graphAgents: I have 10, pick a number > 1 SSG_EXTERNAL: Select NO button IBIJAVACMD: java <---- type in lowercase
Click SAVE on bottom of form.
I don't think you need to recycle, but, if it doesn't work, recycle the server...This message has been edited. Last edited by: Tom Flynn,
Because SSG are produced using java, you also must make sure that you have java enabled (got to cover all the bases here) and that you have the correct settings for your implementation (process-based vs. thread-based, CGI vs. servlet) and your platform (unix/linux has some additional settings such as $DISPLAY). This is all documented in the Installation guide-Enabling and Verifying Server Side Graphics.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat