Re: Error in Enterprise Replication

On 02/05/07, Navaid Arif <navaid.arif@access.net.pk> wrote: > > Hi All, > I am using IDS 10 UC5 and during testing of Enterprise Replication > facing following problem: Anyone have any idea about it? > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit > Modify the current SQL statements using the SQL editor. > > ----------------------- dbname@srvtest -------- Press CTRL-W for Help > -------- > > load from loghisttbl.dmp insert into loghisttbl> > > > 458: Long transaction aborted. 12204: RSAM error: Long transaction > detected. > 847: Error in load file line 5825.> > Regards, > > > > Navaid Arif > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > Navaid This is not directly related to ER, you have simply started a transaction that has exceeded the LTX limits in you onconfig file. Either add more logs space, split the file into smaller lumps and load each as a separate transaction, craete the table as RAW, load the data and then change the table to standard or turn logging off on the database, load the data then turn loging back on. Keith