Subject | Error on restore db "sort record size of 65640 bytes is too big" |
---|---|
Author | Rick Roen |
Post date | 2006-03-06T21:01:56Z |
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
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