Post reply

'Transaction cannot start while in firehose mode'

  • July 24, 2003 at 4:28 pm

    #80915

    I get the above error in Enterprise Manager when I try to change data in my database. I have found away around it by writing the SQL statements myself and then executing them, but it would still be nice to know whats going on here for future reference.

    Anyone had any experience with this problem?

  • July 25, 2003 at 2:10 am

    #466984

    I suppose you're table is pretty big. What happens is that while EM retrieves all your records it puts the table in so-called firehose mode. This means that you already see the first records but EM is still busy to get the rest of them. You have to wait until all records are loaded before you can execute any transactions.

    Workarounds are either using QA or retrieving only a few records in EM using the TOP clause.

    M

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply