Post reply

Invalid switch value

  • October 4, 2005 at 8:42 am

    #110418

    When I run a delete on a big table (approximately 280 million records) I get this error message:

    SQL Server Assertion: File: , line = 499

    Failed Assertion = 'FALSE' Invalid switch value.

    Anyone who has any idea what that could be causing this?

    Kindest Regards,

    Morten

  • October 4, 2005 at 9:03 am

    #594878

    I haven't seen this before but I would like to ask whether you are deleting all rows from the table or just a selection of them?

    If it's all then you should probably consider just truncating the table, if it's a selection then change your delete statement to do it in batches of 10000, which should cut down on the time taken to do the delete.

  • October 5, 2005 at 12:36 am

    #595067

    That's an internal SQL error - you should send it to MS.  Or do a quick google search on it.

  • October 6, 2005 at 2:12 am

    #595353

    I removed the indexes on the table and ran the deletion again. It worked fine and took 1/3 of the time.

    Kindest Regards,

    Morten

  • October 6, 2005 at 11:50 am

    #595591

    You might want to perform a few 'due diligence' things (even though your deletion worked).

    • recycle your SQL Server (yes reboot it)
    • look for *.DMP files
    • look for exception files
    • the dump and exception files can probably be deleted (unless you want to send them to MS PSS)

    I say this because you probably generated an exception and dump via the error mentioned. These activities are just 'normal' cleanup.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 5 posts - 1 through 4 (of 4 total)

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