Subject Re: [firebird-support] Error: message length error (encountered 36, expected 32)
Author Vlad Khorsun
> 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 ?

> 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 ?

Regards,
Vlad