One other possible solution would be to modify LTXHWM to a larger value,
but this could cause other problems, and does require a bounce of the
engine. Your best bet is to add some logical logs. This would be both the
easiest and safest way, without modifying code.
--
Regards,
Robert
Len Charest <len@cogent.net> wrote in article <36143424.6C2A@cogent.net>...
> Hi-
>
> Is it possible to avoid the dreaded "458: Long transaction aborted."
> error without taking either of the actions recomended by the finderr
> docs, namely "replan [the app] so that it modifies fewer rows per
> transaction" or increase number/size of logical logs?
>
> Can LOCK TABLE inside of a transaction be of help?
>
> Thanks,
> --
> Len Charest len@cogent.net
> Senior Software Engineer 888-4-COGENT
> Cogent Software, Inc. http://www.cogent.net/
>