Re: INFORMIX ACE error
> In article <3meo2j$nqv@Venus.mcs.com> dlm@MCS.COM "David Lee Makowsky" > > writes: > > > In article <3memil$pn5@mercury.mcs.com>, David Lee Makowsky > > <dlm@MCS.COMwrote:> > # Configuration: > > > > # Online 5.0 > > # SQL: 4.11 > > # OS: SCO 3.2v4.2 > > > > # Question: > > > > # I get an error message which says "long transaction aborted" > > # when I run an ACE report with an Online server. The error message > > # number is -458. Why does this happen only when I am running a > > report, > > # and not when I am inserting or updating any data? > > > > Clarification: > > > > In my last sentence I meant to write "I am not inserting or > > updating any data. The only thing I am doing is running an ACE > > report. Why is this happening?". > > > > Although ACE doesn't in itself alter the database, it can cause temporary > table to be created which are treated as a single transaction. therefore > I suspect that the ACE report is creating a vast temporary table for an > 'ORDER BY' or join. If you are selecting into temp tables in the Ace report, try using the WITH NO LOG clause. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England