Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problem with the simplest GRAPH

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem with the simplest GRAPH
 Login/Join
 
Francis Mariani
Expert
posted
This works:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY CAR
END

This works:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY

ON GRAPH HOLD AS FM4 FORMAT GIF
END


This does not work:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY CAR

ON GRAPH HOLD AS FM4 FORMAT GIF
END


In self-service or MRE, I get this error:

An error has been detected during server to client data transfer. 
ERROR: -12: Pcb2.: java.net.SocketException: Connection reset


I am trying to create a graph as a GIF to be included in a PDF report.

Thanks,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
susannah
Expert
posted Hide Post
quote:
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY CAR

ON GRAPH HOLD AS FM4 FORMAT GIF
END

i know it's no help, pf, but it works in 762
0 NUMBER OF RECORDS IN GRAPH= 18 PLOT POINTS= 5
GIF FILE SAVED ...



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
linus
Platinum Member
posted Hide Post
I had problems saving graphs as .gif files and was advised to save them as .svg Maybe try this and see if it resolves the issue.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
I'm placing the graph in a PDF report using styling - I imagine I can't use an svg file in this way.

Thanks,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
jodye
Platinum Member
posted Hide Post
Hi

I think the problem is that your BY CAR is producing multiple graphs. So you cannot hold them with one name like that.

I don't know why you are getting a socketexception. But if you try your code with
ON GRAPH SET GRMERGE ON does it work?

ex:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY CAR
ON GRAPH SET GRMERGE ON
ON GRAPH HOLD AS FM4 FORMAT SVG
END

TABLE FILE CAR
SUM SALES
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=FM4.svg, POSITION=(0.2 0.9), SIZE=(6.5 3.9), $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

If I try that without the GRMERGE I get bad value in stylesheet.

HTH


WF 8.0.0.5M
 
Posts: 246 | Location: Montreal, QC, Canada | Registered: October 01, 2003Report This Post
Francis Mariani
Expert
posted Hide Post
Jodye, thanks. I did realize that. I should have amended my code:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY CAR
ON GRAPH SET GRMERGE ON
ON GRAPH HOLD AS FM4 FORMAT GIF
END
still gives me the error.

Unfortunately svg is not supported on my 5.3.2 server.
Regards,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
jodye
Platinum Member
posted Hide Post
Hi Francis

I had a feeling that that was too obvious a solution.

Well, you could create a loop and save each graph one by one without the BY CAR and use WHERE CAR EQ 'X' for each graph. But that means you will end up with a bunch of graphs instead of just one. Also, talk about a long way to fix a simple problem.

Good luck.


WF 8.0.0.5M
 
Posts: 246 | Location: Montreal, QC, Canada | Registered: October 01, 2003Report This Post
Francis Mariani
Expert
posted Hide Post
Jodye, actually I do want only one graph, so in my real code I have the GRMERGE setting. I can't understand why something this simple would cause an error.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
On one AIX server, I actually get a WebFOCUS error:
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 500

On another AIX server, I get a different WebFOCUS error:
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: 404

On my local Windows server the tscom3.exe crashes and gives me this error:
An error has been detected during server to client data transfer. 
ERROR: -12: Pcb2.: java.net.SocketException: Connection reset

If I run the code in Dev Studio, it works:
 0 NUMBER OF RECORDS IN GRAPH=       18  PLOT POINTS=      5
 FILE  FM4.GIF          SAVED TO APP C:\ibi\srv53\wfs\edatemp\ts000011;


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
FrankDutch
Virtuoso
posted Hide Post
Francis

I would never save the graph as a gif.
the quality is beyond what you can get.

The SVG format is much better and yes you can use it in a PDF report.
Zoomimg in and out will keep a quality graph.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Frank,

I can't use SVG in 5.3.2 - it's not supported. I don't know if this has to do with the IBIF_graphengine set to GRAPH32.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
FrankDutch
Virtuoso
posted Hide Post
as far as I know SVG is supported since 5.3
this might be an other problem




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Prarie
Virtuoso
posted Hide Post
What if you SET GRAPHENGINE = NEW

This message has been edited. Last edited by: Prarie,


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
I think we had some Java issues with setting the graph engine to new. I'll have to test and make sure I don't break something else.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problem with the simplest GRAPH

Copyright © 1996-2020 Information Builders