Long transaction problem

Hello out there, we are running I-Online 5.0 on a HP9000/867 (HP-UX 9.0). The database (with unbufferd logging) contains 2 tables eworte 255000 rows and a rowsize of 518 ewstamm 225000 rows and a rowsize of 312. Via ISQL or R4GL we have tried the following SQL-Statement select count(*) from eworte where e_asyl > 0 and e_ord_stamm in ( select s_ord from ewstamm where s_staat_1 > 0 and s_hwnw < 3 ) into temp tmp_eworte This statement ends with the error message -458 (Long transaction aborted). Why do we get this message???? There are no rows updated or inserted by the statement and there is no BEGIN WORK given before. Can anybody explain this to me???? Are there any workarounds (we don't want to increase the log buffer)??? Do an exclusive open on the database help (I can't try this, because there are 40 users working with it)???? Any comments are appreciated. Thanks in advance... Dirch -- +----------------------------------------------------------------------------+ | Dirch Scheer email: scheer@stadt-mh.de | | Amt 10-3 Tel. : +49 208 455 1006 | | Stadtverwaltung (snail-)Mail : Ruhrstr. 32 | | Muelheim an der Ruhr D-45468 Muelheim an der Ruhr | |----------------------------------------------------------------------------| | Inspiration gave them the motivation to move on out their isolation | +----------------------------------------------------------------------------+