Update console

Avast Business Avast Endpoint Protection
1

Hello,

I’am trying to update the console from version 1.0.888.19 to 1.1.132.15.
It can not achieve to install the new service.

Here are the error messages
02-27 16:07:33,693 DatabaseInstaller - Checking the database version.
02-27 16:09:31,272 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-27 16:09:31,288 SbcDatabase - Database upgraded to version 1207
02-27 16:11:28,934 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-27 16:11:28,934 SbcDatabase - Database upgraded to version 1245
02-27 16:13:26,411 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-27 16:13:26,411 SbcDatabase - Database upgraded to version 1273
02-27 16:15:27,146 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-27 16:15:27,146 SbcDatabase - Database upgraded to version 1277
02-27 16:20:32,268 DatabaseInstaller - Unable to check/update database to required version.
02-27 16:20:32,268 SbcServiceInstaller - Unable to install the service.
Avast.Sbc.Service.Database.DatabaseException: Unable to update DB structure. —> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Avast.Sbc.Service.Database.SbcDatabase.updateStructure(Int32 lastVersion)
— End of inner exception stack trace —
at Avast.Sbc.Service.Database.SbcDatabase.updateStructure(Int32 lastVersion)
at Avast.Sbc.Service.Database.SbcDatabase.RunUpgrade(Int32 lastVersion)
at Avast.Sbc.Service.Database.SbcDatabase.RunUpgrade()
at Avast.Sbc.Service.Installer.DatabaseInstaller.VerifyDatabaseVersion()
at Avast.Sbc.Service.Installer.DatabaseInstaller.Install()
at Avast.Sbc.Service.SbcServiceInstaller.Install(IDictionary stateSaver)

2

Hi,
have you tried to reboot the server prior to install over the new version?
If you have already tried after the reboot, try to unistall the old version prior to install the new one…

3

I tried after reboot, it did not work
I did not try after uninstall as i don’t want to loose the database.

4

Samething after uninstall

[Header - Application started at 28-Feb-2012 15:34:42,553 local/15:34:42,553 UTC]
02-28 16:34:42,600 SbcServiceInstaller - avast! Administration Console service installer (version: 1.1.132.15).
02-28 16:34:43,147 SbcServiceInstaller - Installing main avast! Administration Console service.
02-28 16:34:43,241 NetworkAdapterBinding - Invalid MAC address! (An invalid physical address was specified.).
02-28 16:34:43,241 ConnectionStringFactory - Using default connection string (Data Source=.\SQLEXPRESS;Initial Catalog=avast_sbc_db;Integrated Security=SSPI;)
02-28 16:34:43,241 SbcServiceInstaller - Setting up impersonation context.
02-28 16:34:43,319 SystemCulture - Setting system culture to en-US.
02-28 16:34:43,538 ConnectionStringFactory - Connection string loaded from input stream (Data Source=(local)\SQLEXPRESS;Initial Catalog=avast_sbc_db;Integrated Security=True;MultipleActiveResultSets=True;Connect Timeout=60).
02-28 16:34:43,553 DatabaseInstaller - Performing initial DB checks/installation.
02-28 16:34:43,553 DatabaseInstaller - Using existing DB avast_sbc_db managed by 3rd party.
02-28 16:34:47,037 DatabaseInstaller - Checking the database version.
02-28 16:36:37,844 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-28 16:36:37,876 SbcDatabase - Database upgraded to version 1207
02-28 16:38:24,926 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-28 16:38:24,926 SbcDatabase - Database upgraded to version 1245
02-28 16:40:12,392 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-28 16:40:12,392 SbcDatabase - Database upgraded to version 1273
02-28 16:41:57,544 SbcDatabase - Reseting database name on this connection back to the initial value (avast_sbc_db)
02-28 16:41:57,544 SbcDatabase - Database upgraded to version 1277
02-28 16:47:02,822 DatabaseInstaller - Unable to check/update database to required version.
02-28 16:47:02,822 SbcServiceInstaller - Unable to install the service.
Avast.Sbc.Service.Database.DatabaseException: Unable to update DB structure. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Avast.Sbc.Service.Database.SbcDatabase.updateStructure(Int32 lastVersion)
   --- End of inner exception stack trace ---
   at Avast.Sbc.Service.Database.SbcDatabase.updateStructure(Int32 lastVersion)
   at Avast.Sbc.Service.Database.SbcDatabase.RunUpgrade(Int32 lastVersion)
   at Avast.Sbc.Service.Database.SbcDatabase.RunUpgrade()
   at Avast.Sbc.Service.Installer.DatabaseInstaller.VerifyDatabaseVersion()
   at Avast.Sbc.Service.Installer.DatabaseInstaller.Install()
   at Avast.Sbc.Service.SbcServiceInstaller.Install(IDictionary stateSaver)
02-28 16:47:05,150 SbcServiceInstaller - Rolling back the installation
02-28 16:47:05,900 NetworkAdapterBinding - Trying to resolve fully qualified domain name.
02-28 16:47:06,150 NetworkAdapterBinding - Found preferred IP address 10.119.62.93.
02-28 16:47:06,150 NetworkAdapterBinding - Using IP address 10.119.62.93.
02-28 16:47:06,197 NetworkAdapterBinding - Resolved DNS name ldapar93vm.lda.fr, trying to verify reachability.
02-28 16:47:06,447 NetworkAdapterBinding - Target successfully reached using ldapar93vm.lda.fr.
02-28 16:47:06,462 NetworkAdapterBinding - DNS name resolved to ldapar93vm.lda.fr.
02-28 16:47:06,462 HttpAclInstaller - Removing reservation: http://ldapar93vm.lda.fr:8731/
02-28 16:47:09,009 HttpAclInstaller - Unable to remove URL ACL reservation http://ldapar93vm.lda.fr:8731/
02-28 16:47:09,024 HttpAclInstaller - Removing reservation: https://ldapar93vm.lda.fr:8732/
02-28 16:47:09,024 HttpAclInstaller - Unable to remove URL ACL reservation https://ldapar93vm.lda.fr:8732/
02-28 16:47:09,024 HttpAclInstaller - Removing reservation: http://+:8731/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
02-28 16:47:09,024 HttpAclInstaller - Unable to remove URL ACL reservation http://+:8731/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
02-28 16:47:09,055 HttpAclInstaller - Removing reservation: https://+:8732/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
02-28 16:47:09,055 HttpAclInstaller - Unable to remove URL ACL reservation https://+:8732/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
02-28 16:47:09,055 HttpAclInstaller - Removing reservation: http://+:8731/
02-28 16:47:09,055 HttpAclInstaller - Unable to remove URL ACL reservation http://+:8731/
02-28 16:47:09,055 HttpAclInstaller - Removing reservation: https://+:8732/
02-28 16:47:09,055 HttpAclInstaller - Unable to remove URL ACL reservation https://+:8732/
[Footer]