Focal Point
[CLOSED] ReportCaster not Printing Graphs

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

July 31, 2018, 10:15 AM
BLang
[CLOSED] ReportCaster not Printing Graphs
Hello everyone,

I am trying to use the ReportCaster to distribute a jschart to a printer. However when I run the schedule I get the following message in the schedule log:

0 NUMBER OF RECORDS IN GRAPH= 63048 PLOT POINTS= 135
(FOC1522) java.lang.reflect.InvocationTargetException, caused by
(FOC1522) java.lang.NegativeArraySizeException. CPJAVA: Error in processing
(FOC1522) EXECUTE command for Class ibi.jsgraph.IBIRunJSCOMGraph
0 HOLDING PS FILE ON PC DISK ...
Task error: IBFSException 6000: Error executing procedure Cht_CPG_YOY.fex
No report to distribute.

I am not really sure what to make of this error. I'm not well versed in JS nor do I have access to app studio. I've already tried changing the format of my fex to PDF and PS but got the same error both times. Does anyone have any familiarity with this error and could point me in the right direction for resolving? I haven't been able to find anything on here or in the documentation. Thanks in advance

See below for fex code:


ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE transmetric/VWFUELMETRICSSUMMARY
-* Created by Info Assist for Graph
SUM COMPUTE CostPerGal;
BY Year
BY WeekNumber
WHERE VWFUELMETRICSSUMMARY.VWFUELMETRICSSUMMARY.PERIODENDING GE '01022016';
HEADING
"Cost per Gallon Year Over Year"
"(Click 'Show Filters' button to select dimensions)"
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET HAXIS 770.0
ON GRAPH SET VAXIS 405.0
ON GRAPH SET LOOKGRAPH LINE
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setUseSeriesShapes(true);
setCurveFitEquationDisplay(false);

*END
INCLUDE=IBFS:/WFC/Repository/NFI_Dedicated/Hidden_Content/Themes/Detail_Reports.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, CHART-COLOR-MEASURES=ON, $
TYPE=HEADING, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=14, COLOR=RGB(34 77 124), STYLE=BOLD, $
TYPE=HEADING, LINE=2, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=14, COLOR=RGB(34 77 124), STYLE=BOLD, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
*GRAPH_SCRIPT

setMarkerSizeDefault(50);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setCurveFitType(1,1);
setColorMode(1);
setFillColor(getSeries(0),new Color(0,177,0));
setFillColor (getSeries(2),new Color(200,0,0));
setScaleMustIncludeZero(getY1Axis(),false);
setFontSizeAbsolute(getLegendText(),true);
setAutofit(getLegendText(),false);
setFontSizeInPoints(getLegendText(),16);
setPlaceResize(getLegendText(),0);
setFontSizeAbsolute(getY1Title(), true);
setFontSizeInPoints(getY1Title(), 16);
setPlaceResize(getY1Title(), 0);
setFontSizeAbsolute(getO1Title(), true);
setFontSizeInPoints(getO1Title(), 16);
setPlaceResize(getO1Title(), 0);
setFontSizeAbsolute(getY1Label(), true);
setFontSizeInPoints(getY1Label(), 12);
setPlaceResize(getY1Label(), 0);
setTextFormatPreset(getY1Label(),5);
*GRAPH_JS_FINAL
"xaxis": {
"labels": {
"font": "12pt Sans-Serif"
}
},
"introAnimation": {
"enabled": true
},
"blaProperties": {
"seriesLayout": "absolute"
},
"agnosticSettings": {
"chartTypeFullName": "Line_Absolute"
}

*END
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2.01M
Windows, All Outputs
July 31, 2018, 12:39 PM
Balakrishnan Palanisamy
Might be bcoz of the COMPUTE fld, it should be like- COMPUTE fld [/format]= expression;


WebFOCUS 7x and 8x
Windows, All Outputs
July 31, 2018, 04:59 PM
TobyMills
Hey Blang,

Please try to run this directly off the reporting server console if possible.

It is quite possible it will fail there too, thus we can eliminate caster as any concern.

Or maybe you can run it from your WebFOCUS Client (/ibi_apps) web browser?

Do other graphs currently work for you that use this same reporting server (default EDASERVE)?

Is 8201m your correct release?

Thanks
Toby