Skip to main content
O
OkTulsa
Participant
August 19, 2008
Question

Pesky Error Executing Database Query

  • August 19, 2008
  • 1 reply
  • 292 views
About three times a week, we get a ton of errors for "Error Executing Database Query", all at once. That is about as descriptive as it gets. It does tell us the line and the exact SQL statement it tried to run, but when we copy and paste the SQL into a query browser it runs fine. It's almost like there is a connection failure somewhere between CF and the db that is causing this "error"? Has anyone experienced anything like this? Thanks for any help.
This topic has been closed for replies.

1 reply

S
SafariTECH
Inspiring
August 19, 2008
We sometimes get that when a table has been corrupted on the SQL server, or the DTS service is having issues. The error just says there is a database execution error and says the error was at xyz, just like yours.

Generally restarting the SQL server fixes the issue because when it restarts, SQL server rebuilds the tables as a kind of repair.

Our problem seems to relate to issues with the drive. Just lately we saw a note in the Event Viewer that indicated that one drive had a bad block. It is possible that during the "repair" SQL moved the data off that block, similar to how defrag would.

Basically, if you are seeing it semi-regularly and it works fine after restarting the data server, you may want to schedule a maintenance downtime and run a full disk check and defrag, possibly even replacing the drive.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices