An error occurred while executing the command definition

[Bret Miller]

I noticed this morning that my avast! BP console was down. The service wasn't started, so I tried to start it, but it just starts then stops. It gives me this error in the log: "An error occurred while executing the command definition." Now I have no idea what that means or how to solve it. I attached the entire service log in case that's helpful. What now?
 

[soaked]

Restart the SQL Server(SQLEXPRESS) service and try again.

[Bret Miller]

Before posting, I tried restarting the whole server. That didn't work. Just to be sure, I just restarted SQL Express and then tried starting the admin console. Still the same error. 

[soaked]

OK, let's check if connections and queries to the database are even possible.

Please follow the instructions below:
1. Open Command Prompt with elevated privileges.
2. Type the following command there - sqlcmd -S (local)\SQLEXPRESS
3. If connection has been made, you will see "1>" into the console.
4. If the server accepted connection, type the following SQL query:

Code: [Select]

USE avast_sbc_db
GO
SELECT top(1) Version FROM VpsVersions WHERE Version != '0-0'
GO
5. Paste the output of the query here.

Regards,
Dmitriy

[Bret Miller]

Version
--------------------
110824-1

(1 rows affected)

[Bret Miller]

No ideas? OK... well, I'm working on finding and older copy of the database to restore since it seems to be database-related. Perhaps that will solve it.

If someone can think of another solution before then, it would be helpful. I can't see anything obvious wrong with the database, but BPC thinks there is...

[JBG]

No ideas? OK... well, I'm working on finding and older copy of the database to restore since it seems to be database-related. Perhaps that will solve it.

If someone can think of another solution before then, it would be helpful. I can't see anything obvious wrong with the database, but BPC thinks there is...

Hi Bret,
please notice there has been new version (mostly bugfix version) of the avast! Administration Console released a few days ago. Your issues seems to be a known bug with certain DB query timing out. This should be fixed in mentioned version, so please try to update to that version and let me know if that helped. Thanks. Jan.

[Bret Miller]

OK, the upgrade did get the admin console back running again. I'm still having issues with the mirror updating, but I'll give it some time before doing anything about it. Hopefully, it'll just catch up and start running soon.

Thanks.