Ok, we recompiled all triggers and all procedures using IBExpert. The
error message still occurs....

Any other tips?

Thanks,
Steve

Steve Wiser wrote:

>
> Thanks Vlad,
>
> We used IBExpert to recompile all procedures. We are now recompiling
> all triggers since we do have some make calls to stored procedures. We
> will run our 5 hour test and let you know if it works or not!
>
> Thanks,
> Steve
>
> Vlad Khorsun wrote:
> >
> > > We recompiled the procedures using IBExpert. It still fails with the
> > > same error message. Any other suggestions?
> >
> > This error means that you changed input or output parameters in some
> > procedure
> > but another procedure (which calls changed one) was not recompiled
> > after and have wrong
> > references in its BLR.
> >
> > In your case "bad" procedure expected to receive (or tried to send)
> > message of 32 bytes
> > but real length of all output (input) params is 36 bytes. I.e. you
> > added some params or extend
> > type of some of them (for ex. int -> bigint, varchar(n) ->
> > varchar(n+4)). To resolve the issue all
> > you need is to recompile "bad" procedure.
> >
> > Suggestion - look better ;) It is not necessary the procedure which
> > client called - it may be
> > any procedure called or trigger fired during execution of top-level
> > procedure\statement.
> >
> > Regards,
> > Vlad
> >
> > PS IBE have ability to recompile all procedures\triggers
> >
> >
>
>