Re: [firebird-support] update Firebird 2.1 to 2.5

Wed, 01 Apr 2015 01:54:07 -0700 

At 09:28 p.m. 1/04/2015, [email protected] [firebird-support] wrote:


>Hi,
>I have to update my FB 2.1 to 2.5. (32 bit, win xp sp3).
>So, I did it. 
>Now I have some problems with metadata update, any ideas how to resolve this, 
>please.
>
>Invalid modify request.
>unsuccessful metadata update
>DEFINE FUNCTION failed
>attempt to store duplicate value (visible to active transactions) in uniqu
>General SQL error.
>index "RDB$INDEX_9"
>Problematic key value is ("RDB$FUNCTION_NAME" = 'F_BLOBMAXSEGMENTLENGTH') 
>  (9996): Invalid modify request. 
>  (13059): unsuccessful metadata update
>DEFINE FUNCTION failed
>attempt to store duplicate value (visible to active transactions) in uniqu 
>  (13059): index "RDB$INDEX_9"
>Problematic key value is ("RDB$FUNCTION_NAME" = 'F_BLOBMAXSEGMENTLENGTH')

RDB$INDEX_9 is a unique index on RDB$FUNCTIONS.RDB$FUNCTION_NAME. It seems you 
are trying to declare a UDF that already exists in RDB$FUNCTIONS.


>(klasa błędu: EDBEngineError)
>Wystąpił błąd:
>General SQL error.
>invalid request BLR at offset 1225
>function F_LTRIM is not defined
>module name or entrypoint could not be found 
>  (13059): General SQL error. 
>  (13059): invalid request BLR at offset 1225
>function F_LTRIM is not defined
>module name or entrypoint could not be found

It seems you have a missing third-party UDF library module, or the library 
module is in a directory other than /UDF/ which in not configured.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________

Reply via email to