Hi,

I am trying to learn PDF layout Painter to Create a report and Graph and coordinate them.
Therefore I created a new procedure using the PDF layout painter and create a report and a graph based on data in the master file "short" located in the ibisamp directory.
When I tried to run the report i go the following error:

0 NUMBER OF RECORDS IN TABLE= 526 LINES= 15
0 NUMBER OF RECORDS IN GRAPH= 519 PLOT POINTS= 3
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 401
SVG FILE SAVED ...
(FOC3296) Error found in Coordinated Compound Report: At Component graph1
Compound Report is TERMINATING.....



The following is the code generated by the PDF layout painter:


-* File Compound
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=ON, ORIENTATION=LANDSCAPE, PAGESIZE=A4, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='0^0.5^0^0.5', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.625 0.625), DIMENSION=(6.458 2.292), METADATA='Z-INDEX: 100; LEFT: 0.625in; WIDTH: 6.458in; POSITION: absolute; TOP: 0.625in; HEIGHT: 2.292in', $
COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(0.625 3.021), DIMENSION=(6.458 1.875), METADATA='Z-INDEX: 100; LEFT: 0.625in; WIDTH: 6.458in; POSITION: absolute; TOP: 3.021in; HEIGHT: 1.875in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE SHORT
SUM
PROJECTED_RETURN
BY CONTINENT
BY COUNTRY
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
END
SET COMPONENT='graph1'
-*component_type graph
GRAPH FILE SHORT
PRINT PROJECTED_RETURN
ACROSS CONTINENT
BY COUNTRY
HEADING
"WHERE PROJECTED_RETURN NE 0;
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 VAXIS 1.875
ON GRAPH SET HAXIS 6.458
ON GRAPH SET UNITS INCHES
ON GRAPH SET GRWIDTH 0
ON GRAPH HOLD AS HOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(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);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
$
ENDSTYLE
END
-RUN
-RUN
-RUN
-RUN
TABLE FILE SHORT
" "
SUM
COMPUTE CNTR/I4 = CNTR + 1; NOPRINT
COMPUTE CNTR2/A4 = IF &FOCGRAPHCNT EQ 1 THEN ' ' ELSE FTOA(CNTR-1,'(F4)','A4'); NOPRINT
COMPUTE IMG/A16 = 'HOLD'||LJUST(4,CNTR2,'A4')|| '.svg';NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=(IMG), position=(0 0), $
END
COMPOUND END


Any idea about what could be wrong will be very helpfull.

Regards.

This message has been edited. Last edited by: <Kathryn Henning>,

WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server

Majid,

I think what I recommended in a different post was that you create a separate graph and a separate report program.

The graph program should have in it:

ON GRAPH HOLD FORMAT SVG

or if you are going to have more than one graph:

ON GRAPH HOLD AS GRF1 FORMAT SVG and
ON GRAPH HOLD AS GRF2 FORMAT SVG in the second graph.

After you have these programs written and tested, then create the PDF Layout Painter program.

When you set up the properties for the report widget, use the 'reference existing procedure' and point to your report program. Likewise for the graph.

I have 762 as well and have a couple of cases open on this tool, so:

1. Do not use chaining. That will screw up your re-edit.
2. If you are going to use 2 graphs, put the second graph in its own page layout.

If you follow these simple steps, you should be successful.

Hi Ginny,

I did what you recomended and I am still getting the same error:

Report1 is:

GRAPH FILE SHORT
SUM PROJECTED_RETURN
ACROSS CONTINENT
BY CONTINENT
HEADING
"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 GRWIDTH 0
ON GRAPH HOLD AS HOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(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);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
$
ENDSTYLE
END

Report2 is:

TABLE FILE SHORT
SUM
PROJECTED_RETURN
BY CONTINENT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
RIGHTGAP=0.125000,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

Report3 is this one

-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='0^0.5^0^0.5', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.500), DIMENSION=(3.870 2.083), METADATA='Z-INDEX: 1; LEFT: 0.5in; WIDTH: 3.87in; POSITION: absolute; TOP: 0.5in; HEIGHT: 2.083in', $
COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(0.624 2.912), DIMENSION=(4.683 2.083), METADATA='Z-INDEX: 2; LEFT: 0.624in; WIDTH: 4.683in; POSITION: absolute; TOP: 2.912in; HEIGHT: 2.083in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE report2
SET COMPONENT='graph1'
-*component_type graph
-INCLUDE report1
-RUN
TABLE FILE SHORT
" "
SUM
COMPUTE CNTR/I4 = CNTR + 1; NOPRINT
COMPUTE CNTR2/A4 = IF &FOCGRAPHCNT EQ 1 THEN ' ' ELSE FTOA(CNTR-1,'(F4)','A4'); NOPRINT
COMPUTE IMG/A16 = 'HOLD'||LJUST(4,CNTR2,'A4')|| '.svg';NOPRINT
BY CONTINENT NOPRINT
ON CONTINENT PAGE-BREAK
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=(IMG), position=(0 0), $
END
COMPOUND END


But I am not able to make this work.

Majid.

Regards.

WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server

It looks like you customized the last TABLE.

Here is the end of one of mine that is working using the technique that I explained above.

SET COMPONENT='report1'
-*component_type report
-INCLUDE censales_rpt
SET COMPONENT='graph1'
-*component_type graph
-INCLUDE centsales_graph1
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=GRF1.svg, position=(0 0), $
TYPE=REPORT,PAGE-LOCATION=OFF,$
END
COMPOUND END  

Try doing this without any customization and see if you can get it to run. You shouldn't have to do any of that compute stuff you are doing.

If that doesn't work, then I would recommend that you open a case with IBI.

Hi Ginny,

Janice from this forum suggested the following:


Here's the solution on the case.

Solution Section
The JSCOM3 processes on the reporting server are configured with REFRESH=50 and
NUMBER_READY=2, IBI_CLASSPATH has no additional entries and IBIJAVAPATH is not
configured.

The client settings changed were to clear IBIF_graphservurl and set
IBI_USE_JSCOM3=YES (this had to be added manually to the cgivars.wfs file - see
excerpt below).

< !WFConsole begin Graph>
ENABLE_SSG =YES
IBIF_graphengine =GRAPH53
IBIF_graphservurl
IBIF_graphservurl =

IBIF_graphAgents =10
SSG_EXTERNAL =NO
IBI_USE_JSCOM3 =YES
< !WFConsole end Graph>

FEXs need to be in the apps directory rather than basedir in order to run.

I did it and it fixes my problem without changing my code.

Thanks a lot for your help.

Regards

WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server

Hi Majid,

Can you please elaborate on the Steps that you actually took to get this resolved?
I am facing a similar problem.

Kindly let me know if any Server Setting needs to be changed, or can this be handled in the Web Developer Studio itself?

Thanks,
Ved

can you post your code, so that it will be easy to debug ??

The problem is a server configuration setting, not a code issue. There are a couple of ways to set up the server to properly create graphs. They are all described in the installation manuals. Basically you need to set up java paths correctly so the JSCOM3 service can start and run and then the IBI_USE_JSCOM3 setting tells the server to use that same java environment for preparing the graphs.

I have the same problem and just want to put this topic up. If anyone solved it, could you please share your solution?

Hello hainguyen,

If you've reviewed your Reporting Server configuration settings as Darin described above and are still experiencing this issue, please open a case on InfoResponse Online so that we can look into this further.

Thanks and regards,

Kathryn