Does anyone know where to find documentation on this Err Numbers in the Webconsole?

Whenever I run this procedure it seems to run for about 14-15min, and then it aborts for me automatically without any status report. And I when I check the webconsole, it gives me the description of Last ErrNum 920.

I found reference to it on tech support -- the error occurs when you hit the FOCSORT limit. Is there heavy duty sorting going on in the fex?

Yes there is alot of sorting, but this problem never occurred previously.

Did something change? Are the tables involved large and growing rapidly? Any changes in the
fex? Any changes in table indexes?

If you are accessing a relational table has the code been optimized?

There is a command you can use to give the detail on an error message which may or may not help, but for the life of me I can't find my example and it's not one I memorized.

Anyone recall?

Can anyone actually point us to the documentation on the tech support site regarding the LAST ERRNUM column in the console? Is there a listing as to what each error number means?

Thanks,

Will

The command

? 920

Gives you:

0(FOC920) FOCSORT HAS REACHED ITS PAGE LIMIT
A severe error was encountered in writing to FOCSORT FOCTEMP.
FOCUS will not be able to recover from this error, and will return
to the host environment.



Perhaps this is the problem?

You can try the following link:
http://techsupport.informationbuilders.com/tech/ibm/ibm_dia_errors_toc.html

It basically gives you the same information as ? xxx (where xx represents the error number)