Error Message: Transaction cannot start while in firehose mode

Hi,
I am dealing with an application where the back-end is SqlServer2000. There
is a master table where one filed is empty that needs to be filled in with
correct value. As I am trying to add the value to this field on a particular
row, I am getting the following message: Transaction cannot start while in
firehose mode. Now I am planning to send a update command to the particular
row to fill in the blank value for the field concerned. However, before I do
that I just want to know, why I am getting the above error. Any help is
appreciated. Thanks.> As I am trying to add the value to this field on a particular row
How are you "trying to add the value"? An update statement, a stored
procedure call, pasting into Enterprise Manager's "Open Table" view, ...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||I was trying to add the blank field value from Enterprise Manager, by right
clicking and opening the table and choosing all row option and then going to
the right record and the blank field to fill it up. At this point, I got the
above message. I would like to know why I am getting such message and is it
safe to run a update query to update the blank field in one record via Query
Analyzer. Thanks
"Aaron [SQL Server MVP]" wrote:
> > As I am trying to add the value to this field on a particular row
> How are you "trying to add the value"? An update statement, a stored
> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||If your table has a primary key (or a unique way to identify a single row),
then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
Manager has its purposes, but data manipulation is not one of them. Please
have a look through this article: http://www.aspfaq.com/2455
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> I was trying to add the blank field value from Enterprise Manager, by
right
> clicking and opening the table and choosing all row option and then going
to
> the right record and the blank field to fill it up. At this point, I got
the
> above message. I would like to know why I am getting such message and is
it
> safe to run a update query to update the blank field in one record via
Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
> > > As I am trying to add the value to this field on a particular row
> >
> > How are you "trying to add the value"? An update statement, a stored
> > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >|||Thanks for the help Aaron. I appreciate it.
"Aaron [SQL Server MVP]" wrote:
> If your table has a primary key (or a unique way to identify a single row),
> then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
> Manager has its purposes, but data manipulation is not one of them. Please
> have a look through this article: http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> > I was trying to add the blank field value from Enterprise Manager, by
> right
> > clicking and opening the table and choosing all row option and then going
> to
> > the right record and the blank field to fill it up. At this point, I got
> the
> > above message. I would like to know why I am getting such message and is
> it
> > safe to run a update query to update the blank field in one record via
> Query
> > Analyzer. Thanks
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > > As I am trying to add the value to this field on a particular row
> > >
> > > How are you "trying to add the value"? An update statement, a stored
> > > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
>
>|||Chances are the table does not have a valid PK and is causing the error.
--
Andrew J. Kelly SQL MVP
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
>I was trying to add the blank field value from Enterprise Manager, by right
> clicking and opening the table and choosing all row option and then going
> to
> the right record and the blank field to fill it up. At this point, I got
> the
> above message. I would like to know why I am getting such message and is
> it
> safe to run a update query to update the blank field in one record via
> Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
>> > As I am trying to add the value to this field on a particular row
>> How are you "trying to add the value"? An update statement, a stored
>> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>

Error Message

We are using ADO2.6,VB6.0, and SQLServer2000. There is a error message "Not
enough storage is available to complete this operation" when we try to
update a single row in a big table (more than 80 million records). We have
only see this message twice. Does anybody know what this error mean? At what
condition it could happen?
Thanks,
LijunHi Lijun
Is the transaction log full?
Cheers, David
>--Original Message--
>We are using ADO2.6,VB6.0, and SQLServer2000. There is a
error message "Not
>enough storage is available to complete this operation"
when we try to
>update a single row in a big table (more than 80 million
records). We have
>only see this message twice. Does anybody know what this
error mean? At what
>condition it could happen?
>Thanks,
>Lijun
>
>.
>|||David,
The transaction log is not full. I have allocated 30GB transaction log space
and the transaction log backup size is 70MB after the error message.
Lijun
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:020c01c3b84f$4853e250$a501280a@.phx.gbl...
> Hi Lijun
> Is the transaction log full?
> Cheers, David
> >--Original Message--
> >We are using ADO2.6,VB6.0, and SQLServer2000. There is a
> error message "Not
> >enough storage is available to complete this operation"
> when we try to
> >update a single row in a big table (more than 80 million
> records). We have
> >only see this message twice. Does anybody know what this
> error mean? At what
> >condition it could happen?
> >
> >Thanks,
> >Lijun
> >
> >
> >.
> >|||Lijun, I don't know why this is happening - sorry. David.
>--Original Message--
>David,
>The transaction log is not full. I have allocated 30GB
transaction log space
>and the transaction log backup size is 70MB after the
error message.
>Lijun
>"David" <anonymous@.discussions.microsoft.com> wrote in
message
>news:020c01c3b84f$4853e250$a501280a@.phx.gbl...
>> Hi Lijun
>> Is the transaction log full?
>> Cheers, David
>> >--Original Message--
>> >We are using ADO2.6,VB6.0, and SQLServer2000. There is
a
>> error message "Not
>> >enough storage is available to complete this operation"
>> when we try to
>> >update a single row in a big table (more than 80
million
>> records). We have
>> >only see this message twice. Does anybody know what
this
>> error mean? At what
>> >condition it could happen?
>> >
>> >Thanks,
>> >Lijun
>> >
>> >
>> >.
>> >
>
>.
>|||Hi Lijun,
Thanks for your post. According to your description, it seems that this
error message does not occur regularly. This kind of randomly occurring
issue is not easy to troubleshoot, and is one whose root cause is difficult
to find out. Please check the suggestions in the following articles and see
if they address your problem.
182423 FIX: Error "Not Enough Storage Is Available" with ADO
http://support.microsoft.com/?id=182423
166840 Err Msg: Not Enough Storage to Complete Operation
http://support.microsoft.com/?id=166840
Please try to install the latest version of MDAC on your computer. You will
find the download link below.
Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 Refresh
http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-
b0f3-ae36c570ade8&DisplayLang=en
When you update the table using Query Analyzer, does the error message
occur?
In addition, based on my experience, this issue is probably related to the
ado programming. It is best to discuss this issue in the
microsoft.public.vb.database.dao newsgroup. The
microsoft.public.vb.database.dao newsgroup is primarily for issues
involving ado programming. The reason why we recommend posting
appropriately is because you will then get the most qualified pool of
respondents, also, other partners who regularly read the newsgroups
regularly can either share their knowledge, or learn from your interaction
with us.
Thanks for using MSDN newsgroup. If you have any questions, please do not
hesitate to let me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.