Subject Re: [firebird-support] cant create new stored proc
Author Helen Borrie
At 10:20 AM 4/10/2005 +0000, you wrote:
>running on FB 1.5 i already have about 10 SPs in db
>and i need to create one more.
>
>here is the error message:
>
>Invalid token.
>Invalid request BLR at offset XXXXX.
>Too many contexts of relation/procedure/views. Maximum allowed is
>127...
>
>Any ideas?

Yes, you have an object in your database - either table, procedure or view
- that has been changed 127 times without a backup and restore being
done. That is the maximum number of versions of an object that can be held
in a database's accounting.

You will have to back up and restore the database, to reset all of the
version counters.

./heLen