<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [DUG] Object was open</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18999"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>Hi all,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>Finally I found the problem. I asked
infrastructure support team to compare the 2 servers, and it turns out that the
server having problem is short of memory, due to a rogue service from virus
checker taking up 1GB memory after running for a few months. After
rebooted the server, it all runs fine now.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>I just didn't check the obvious memory problem at the
first instance.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>Thanks anyone who show interest and offered
help.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>Regards,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=970004306-24022011>Edward</SPAN></FONT></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> delphi-bounces@delphi.org.nz
[mailto:delphi-bounces@delphi.org.nz] <B>On Behalf Of </B>Kyley
Harris<BR><B>Sent:</B> Wednesday, 23 February 2011 5:31 p.m.<BR><B>To:</B> NZ
Borland Developers Group - Delphi List<BR><B>Subject:</B> Re: [DUG] Object was
open<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Have you compared the ado dll version numbers on each
computer.<BR>Perhaps a dll upgrade is the issue<BR><BR>On Wednesday, February
23, 2011, <edwardh@slingshot.co.nz> wrote:<BR>> Thanks for the
suggestion.<BR>><BR>> I'm using TADOQuery, and have nothing to do with
TClientDataSet, so what John<BR>> suggested doesn't apply to me at
all.<BR>><BR>> I do expect that it's Windows Update related, but I can't
pinpoint which one.<BR>> I have confirmed that the same application works on
my another Win2003 server,<BR>> when connected to the same database. So
it's definately something to do with<BR>> the server. What I need to
know is "what" caused it. Unfortunately, I can't<BR>> change/swap the
server.<BR>><BR>> I don't think rollback transaction before start is a
valid option, as<BR>> ADOConnection would simply fail it.<BR>><BR>>
Edward<BR>><BR>> Quoting Rohit Gupta
<rohit@cfl.co.nz>:<BR>><BR>>> Edward,<BR>>><BR>>> I
have something similar at only one site. They get transaction
already<BR>>> started error. And only they do. I have gone
through the code several<BR>>> times - every query is try/finally
and try/except bracketed and all<BR>>> transaction
starts/commits/rollbacks are correct.<BR>>><BR>>> It just occurs to
me that if the sql server uses tcpip (which firebird<BR>>> does and I am
using firebird) then it could be windows dropping the<BR>>> tcpip
transactions. I know it is stupid in many other situations
where<BR>>> it clears the stack. I suppose this could also happen
due to window<BR>>> updates.<BR>>><BR>>> As John says, closing
the query prior to use may be the answer. I dont<BR>>> like the idea
myself, but I may have to do rollback before start
:-(<BR>>><BR>>><BR>>><BR>>><BR>>> On
21/02/2011 8:54 p.m., Edward Huang wrote:<BR>>>> Hi,<BR>>>>
I'm having a strange error recently. We have a program that
has<BR>>>> been running on a Win2003 server for a long time, and
suddenly from<BR>>>> last week it comes up 'Object was open'
errors.<BR>>>> Typically, the program uses 2 TADOQuery, one will
select/Edit/Post,<BR>>>> another one with an 'Insert into xxx' query,
both pointing to a same<BR>>>> SQL Server 2005 table. The pattern
appears on many places.<BR>>>> Disregard the nicety of the logic, it
has been done that way for<BR>>>> over 5 years, first on Win 2000
server with SQL Server 2000, and<BR>>>> later on Win 2003 server with
SQL Server 2005, and was all fine,<BR>>>> until about a week
ago.<BR>>>> I have tried Google, but couldn't really find any useful
link to my<BR>>>> situation, although there are lots of link to the
same error. I'm<BR>>>> suspecting some kind of OS patch or such
which changed behaviour of<BR>>>> ADO or MDAC or SQL
Server.<BR>>>> Anyone has a suggestion to my situation? I'm not
keen on changing<BR>>>> all the code to use different logic, as it
would require fair amount<BR>>>> of coding and testing.<BR>>>>
Thanks,<BR>>>>
Edward<BR>>>><BR>>>><BR></FONT></P></BODY></HTML>