I am getting the below error .....when i fetch the data from table.....
Any suggestions for coming out of this ..i am using webfocus5.2.5

An error has been detected during server to client data transfer.
ERROR: -12: Pcb2.: java.io.EOFException

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

There should be a number of posts on this topic. Try searching for -12.

Generally, this means to are trying to return too many rows to the client. Try reducing the size of the answer set to see if your problem goes away.

Yes your answer is perfect...I am trying to return too many rows to the client and i am not in a position to reduce the size.As we need all rows.....Any suggestions/answers i tried searching -12 but yet problem exists.

Are you bringing them to a browser? Try a hold file instead.

Split up the query so that you get the data in pieces.

Ginny,

We both are on same track now....
Yes we are bringing it to a browser by using a hold file ONLY.
I divided/Split up the query into two parts PART-A and PART-B.
PART-A has more data then PART-B,,, so now it is giving problem for PART-A.
Now i cant divide data futher ...Any suggestions pleaseeeee.......

SIM....

Nope. Why do you need all of this data for a web application? No one can process that much data at one sitting.

No No....Actually we have two list box on the browser there these data has to load before user makes any choice for selecting particular record.This is how the application is...it was working fine before 3 months back...suddenly now it started giving error....any suggestionssss...Thank You for ur patience......

Any suggestions/solutions...yet problem persists.....

quote:

WEBFOCUS 5.2.5

First thing I would look at doing is upgrading.

The 5.2 series was functionally stabilized end of May 2007 so any chance of a solution from IBI
other than recommendations (assuming you still have maintenance is 0).

If your data volumes have changed that much you only have one option which is to change the way it works.

Instead of pulling all the data at once, populate the first selection then populate the second based on that.

There are quite a number of examples posted on the forum using either javascript or what would be better in
your case WebFOCUS using re-entrant code.

Any suggestions/solutions...yet problem persists.....