Subject Re: [firebird-support] cant create new stored proc
Author Martijn Tonies

> >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
> in a database's accounting.
> You will have to back up and restore the database, to reset all of the
> version counters.

Could be me ... but I thought the limit was 255 ... and why does this
fire when creating a procedure?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!