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

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

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,

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

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.

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.