Focal Point
Unable to create a graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2601088222

April 11, 2007, 09:45 AM
mark66
Unable to create a graph
Hi all,

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...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 11, 2007, 09:59 AM
mark66
Thanks Tom,

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,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 11, 2007, 10:21 AM
mark66
Thanks Tom,

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,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 11, 2007, 11:23 AM
Darin Lee
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