Subject Error on restore db "sort record size of 65640 bytes is too big"
Author Rick Roen
I just backed up and restored a 1.5 DB.

On the restore, using DBWorkbench, I get an error "sort record size
of 65640 bytes is too big".

This happens at the end of recreating some FK's, possibly on the
first procedure to be recreated.

I saw a post in this ng, however it was related to a very, very
large select which involved 30 + tables.

The only thing I can think of is a UDF that I recently changed and
use in several procedures. The udf is for escaping HTML code
produced within a procedure, and is declared like this:

DECLARE EXTERNAL FUNCTION F_ENCODE_HTML
CSTRING(32767)
RETURNS CSTRING(32767) FREE_IT
ENTRY_POINT 'Str_EncodeHTML' MODULE_NAME 'Primavera_UDF';

I might call this function several times in a select statement like:
Select F_Encode_HTML( Name ), F_Encode_HTML( City ) ... from <table>

Could this be the problem and is there any way to restore from this
backup?

Rick