Re: Error 244 Fetch Error
Posted in 1995
> > Error 244 (Could not do a physical order read to fetch next row) has been occurring more frequently in our application. It comes up during a fetch next row call. When we get the error, that particular query is incomplete; however subsequent queries work fine. We are even able to repeat the same query and it work fine on the second try. > [snip] > Any ideas what could be causing the problem? > Are you using SACEGO? As I understand it, there's a BUG in SACEGO. It won't do DIRTY READs. Thus when someone has a row locked, your query burps. -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 If it weren't for my ignorance, Your brilliance would be of no use.