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 PDF compound report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem with PDF compound report
 Login/Join
 
Mike Johnson
Gold member
posted
I'm having a problem with a compound PDF report. The report gives the following error when I try to execute it. ERROR: MR_UNKNOWN_ERROR -12: Pcb2.: java.net.SocketException: Connection reset

I've narrowed down the problem to a define field that creates a aplha field 4000 char long. The report returns the data correctly in HTML format which the actual length of the aphla field is 1523 char long. If I comment out the field the report runs fine. I've tried using style sheet commands to force the field to wrap. This has not worked. Does anyone have any ideas. Thanks
 
Posts: 84 | Location: Tallahassee, Fl. | Registered: December 02, 2005Report This Post
Carol Dobson
Guru
posted Hide Post
Mike,

You don't say what release of WF you're running?

We are on 5.2.8 and had a problem with alpha fields when more than 1064 characters are returned in the field. We're calling SQL with
ENGINE SQLMSS SET CONVERSION LONGCHAR ALPHA
Note: if the field is blank, it's not a problem, only when it's populated with more than 1064.


Our workaround was to use LONGCHAR TEXT and create a TX field.
ENGINE SQLMSS SET CONVERSION LONGCHAR TEXT

When we upgrade to 7.??? later this year, I've noticed that TX fields are not supported anymore but I'm hoping the LONGCHAR ALPHA problem is fixed.

Thanks,

Carol



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
Here's a sample stylesheet command to wrap a field in Alpha format;

TYPE=REPORT, COLUMN=Recommendation, WRAP=7.5, SIZE=6,$


Using TEXT, just put the number of characters you want to see on each line

PRINT Recommendation/TX155

Hope this helps!
Carol

This message has been edited. Last edited by: Carol Dobson,



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Mike Johnson
Gold member
posted Hide Post
Carol, I'm using version 5.2.7 Will have version 7.3 soon. I'm not familar with the command you suggested. I sent it up to IT. I'll respond back as soon as I hear from them. Thanks
 
Posts: 84 | Location: Tallahassee, Fl. | Registered: December 02, 2005Report This Post
RickW
Platinum Member
posted Hide Post
Mike, the issue you're having was a showstopper for me for one of my projects as Carol D. mentions. They did come up with a 5.2.9 patch which I *think* fixed it but our priorities changed and we had to backburner the project until our 7.x upgrade.

For now you'll have to use the TEXT format or break apart your field.


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
 
Posts: 125 | Location: New England | Registered: February 20, 2007Report This Post
Mike Johnson
Gold member
posted Hide Post
Thanks for the input. I'm still waiting on IT. They are saying they might have a fix. I'll let you know what they say as soon as they get back to me.
 
Posts: 84 | Location: Tallahassee, Fl. | Registered: December 02, 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 PDF compound report

Copyright © 1996-2020 Information Builders