Vlad Khorsun wrote:

>
> > Hello,
> >
> > We are getting a strange error on one of our customer's databases. This
> > code base is run on about 20 different customer databases, but is only
> > giving an error on 1 of them...
> >
> > I have searched the newsgroups (and googled) for the "message length
> > error" and the 2 reasons that I have seen for it are 1) client to

server

> > version mismatch and 2) calling execute on a stored procedure that

has a

> > suspend. We are getting "Error: message length error (encountered 36,
> > expected 32)" every time we run a specific stored procedure. We have
> > tried running it from isql directly on the server, IBEpxert from a
> > windows client, IBPerl from a different linux client, and java from yet
> > another linux client. All of them are using the correct client
> > libraries from what I can tell. We are calling the procedure as a
> > select statement (it does have a suspend at the end of it).
>
> Does this procedure selects from another procedures ?

Yes it does. And it updates tables which will fire triggers which will
select from other procedures...

>
> > We have even run IBFirstAid on the physical database file and it tells
> > us that there is no corruption with the database. Does anyone know what
> > this particular "message length" error means?
> >
> > The database does a backup and restore without any errors.
>
> Does restored database produced same error ?

Yes the restored database will still produce the same error.

Thanks,
Steve