1 Reply Latest reply on May 19, 2015 2:39 PM by adamg23

    Database installation Error

    Rookie

      Hi Guys,

       

      Our Shavlik Protect 9.0 is refusing  to launch indicating that SQL query failed to execute( I didn't record the message)  After a little digging. I verified database were intact and did test connections to verify sql services were running and also check the integrity of the database.

       

      I decided to relaunch the database setup tool to see if I can relink the database. It did indicate it has linked but when I tried to finish the installation it produces the error that :

      Failed to commit or save the database installation

       

      and the freezes the tool. After which it produces a database installtion error  shavlikdb.jpg

       

      I have shrinked the database size and cleared logs and tried again but nothing was different. I have recorded the logs after those actions and here is what i got.

       

      Any thoughts on how I can proceed or should I just call phone support to have someone look further. Thanks David

       

       

      2015-05-19T16:30:29.3895623Z 0001 I Program.Main|'E:\Program Files\LANDesk\Shavlik Protect\ST.DatabaseConfiguration.exe' is starting, version: 9.0.1106.0, full name: ST.DatabaseConfiguration, Version=9.0.0.0, Culture=neutral, PublicKeyToken=19306d7375e33918.

      2015-05-19T16:30:29.4051693Z 0001 S Program.Main|Database installation wizard started.

      2015-05-19T16:30:29.4208006Z 0001 S Program.InstallInteractive|Entering.

      2015-05-19T16:30:33.8583892Z 0001 S InstallWizard.PrepareConfigureSqlState|Entering.

      2015-05-19T16:30:33.8739881Z 0001 S InstallWizard.PrepareConfigureSqlState|Leaving.

      2015-05-19T16:30:42.7647493Z 0001 S InstallWizard.GetDatabaseConnectionState|Entering.

      2015-05-19T16:30:42.7959925Z 0001 S ConnectionValidator.QueryConnectionState|Entering.

      2015-05-19T16:30:42.8897566Z 0001 S ConnectionValidator.QueryConnectionState|Leaving.

      2015-05-19T16:30:42.9053782Z 0001 S PermissionManager.cs:158|HasPermission|Entering.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Leaving.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Entering.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Leaving.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Entering.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Leaving.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Entering.

      2015-05-19T16:30:42.9678710Z 0001 S PermissionManager.cs:158|HasPermission|Leaving.

      2015-05-19T16:30:43.0772505Z 0001 S PermissionManager.cs:158|HasPermission|Entering.

      2015-05-19T16:30:43.0928894Z 0001 S PermissionManager.cs:158|HasPermission|Leaving.

      2015-05-19T16:30:43.0928894Z 0001 S RoleManager.cs:28|IsInRole|Entering.

      2015-05-19T16:30:43.0928894Z 0001 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:28|IsInRole|Leaving.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:28|IsInRole|Entering.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:28|IsInRole|Leaving.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:28|IsInRole|Entering.

      2015-05-19T16:30:43.1553893Z 0001 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.1709970Z 0001 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.1709970Z 0001 S RoleManager.cs:28|IsInRole|Leaving.

      2015-05-19T16:30:43.1709970Z 0001 S RoleManager.cs:28|IsInRole|Entering.

      2015-05-19T16:30:43.1709970Z 0001 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.1866230Z 0001 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.1866230Z 0001 S RoleManager.cs:28|IsInRole|Leaving.

      2015-05-19T16:30:43.2178736Z 0001 S InstallWizard.GetDatabaseConnectionState|Leaving.

      2015-05-19T16:30:43.4678838Z 0006 S DatabaseInstallerController.ExecuteInstall|Entering.

      2015-05-19T16:30:43.4835104Z 0006 S DatabaseInstaller.cs:167|Install|Entering.

      2015-05-19T16:30:43.4835104Z 0006 S DatabaseInstaller.cs:290|GetIntelligentTimeout|Entering.

      2015-05-19T16:30:43.4835104Z 0006 S DatabaseInstaller.cs:290|GetIntelligentTimeout|Leaving.

      2015-05-19T16:30:43.4835104Z 0006 S DatabaseInstaller.cs:737|SetupRolesAndUsers|Entering.

      2015-05-19T16:30:43.4991284Z 0006 I DatabaseInstaller.cs:412|Changed database context to 'SH01TBVWI'.

      2015-05-19T16:30:43.5147586Z 0006 S SqlPrincipalManager.cs:225|GetCreateServiceAccountLogin|Entering.

      2015-05-19T16:30:43.5147586Z 0006 S SqlPrincipalManager.cs:366|GetCreateAccountLogin|Entering.

      2015-05-19T16:30:43.5147586Z 0006 S SqlPrincipalManager.cs:366|GetCreateAccountLogin|Leaving.

      2015-05-19T16:30:43.5147586Z 0006 S SqlPrincipalManager.cs:225|GetCreateServiceAccountLogin|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Entering.

      2015-05-19T16:30:43.5460117Z 0006 S RoleManager.cs:256|IsInRole|Leaving.

      2015-05-19T16:30:43.5460117Z 0006 S DatabaseInstaller.cs:737|SetupRolesAndUsers|Leaving.

      2015-05-19T16:30:43.5616342Z 0006 I DatabaseInstaller.cs:354|Commit started.

      2015-05-19T16:30:43.5772586Z 0006 I DatabaseInstaller.cs:412|Linking console

      2015-05-19T16:30:43.6086004Z 0006 I DatabaseInstaller.cs:364|Console linked to existing database.

      2015-05-19T16:30:43.6086004Z 0006 I DatabaseInstaller.cs:909|Completed install transaction scope.

      2015-05-19T16:30:43.6086004Z 0006 S RoleManager.cs:160|CleanupDbExecutorRole|Entering.

      2015-05-19T16:30:43.6086004Z 0006 I RoleManager.cs:167|Removing db_executor role.

      2015-05-19T16:30:43.6397674Z 0006 S RoleManager.cs:160|CleanupDbExecutorRole|Leaving.

      2015-05-19T16:30:43.6397674Z 0006 S RoleManager.cs:219|GrantRolePrivleges|Entering.

      2015-05-19T16:30:43.6397674Z 0006 I DatabaseInstaller.cs:412|Changed database context to 'SH01TBVWI'.

      2015-05-19T16:30:43.8741529Z 0006 S RoleManager.cs:219|GrantRolePrivleges|Leaving.

      2015-05-19T16:30:43.8741529Z 0006 S DatabaseInstaller.cs:167|Install|Leaving.

      2015-05-19T16:30:43.8741529Z 0006 S DatabaseInstallerController.ExecuteInstall|Leaving.

      2015-05-19T16:30:47.6398263Z 0001 I CredentialController.cs:292|Upgrading credentials...

      2015-05-19T16:31:17.7027556Z 0001 E InstallWizard.WizardFinishClick|Failed to commit or save the database installation.: A SQL Server query operation timed out. Consider increasing the command timeout in the configuration file.

      SqlError message: 'Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.', source: '.Net SqlClient Data Provider', server: '(local)\SQLEXPRESS', number: -2, state: 0, procedure: '', line number: 0.

      SqlError message: 'The statement has been terminated.', source: '.Net SqlClient Data Provider', server: '(local)\SQLEXPRESS', number: 3621, state: 0, procedure: '', line number: 1.

         at ST.Data.DbAccessLayer.PersistManagerBase.AttemptExecuteCommand[T](Func`1 command)

         at ST.Data.DbAccessLayer.PersistManagerBase.ExecuteNonQuery(SqlCommand command, Boolean mustAffectRows)

         at ST.Data.Services.Credentials.UserCredentialUsagePersistManager.DeleteInvalidUsages()

         at ST.Data.Services.Credentials.DbUserCredentialRepository.Upgrade()

         at ST.UI.Controllers.Credentials.CredentialController.UpgradeCredentials()

         at ST.DatabaseConfiguration.DatabaseInstallerController.Commit(String userSqlConnection, String serviceSqlConnection)

         at ST.DatabaseConfiguration.InstallWizard.WizardFinishClick(Object sender, CancelEventArgs e)

      2015-05-19T16:31:23.9060062Z 0001 I Program.DbInstallWizard_Canceled|The user has canceled the database installation.

      2015-05-19T16:31:23.9528724Z 0001 E Program.ApplicationThreadException|A SQL Server query operation timed out. Consider increasing the command timeout in the configuration file.

      SqlError message: 'Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.', source: '.Net SqlClient Data Provider', server: '(local)\SQLEXPRESS', number: -2, state: 0, procedure: '', line number: 0.

      SqlError message: 'The statement has been terminated.', source: '.Net SqlClient Data Provider', server: '(local)\SQLEXPRESS', number: 3621, state: 0, procedure: '', line number: 1.

         at ST.Data.DbAccessLayer.PersistManagerBase.AttemptExecuteCommand[T](Func`1 command)

         at ST.Data.DbAccessLayer.PersistManagerBase.ExecuteNonQuery(SqlCommand command, Boolean mustAffectRows)

         at ST.Data.Services.Credentials.UserCredentialUsagePersistManager.DeleteInvalidUsages()

         at ST.Data.Services.Credentials.DbUserCredentialRepository.Upgrade()

         at ST.UI.Controllers.Credentials.CredentialController.UpgradeCredentials()

         at ST.DatabaseConfiguration.DatabaseInstallerController.Commit(String userSqlConnection, String serviceSqlConnection)

         at ST.DatabaseConfiguration.InstallWizard.WizardFinishClick(Object sender, CancelEventArgs e)

         at DevExpress.XtraWizard.WizardControl.RaiseFinishClick()

         at DevExpress.XtraWizard.WizardControl.OnFinishButtonClick(Object sender, EventArgs e)

         at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)

         at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

         at System.Windows.Forms.Control.WndProc(Message& m)

         at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)

         at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)

         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

      2015-05-19T16:31:23.9684809Z 0001 S Program.InstallInteractive|Leaving.

      2015-05-19T16:31:23.9684809Z 0001 S Program.Main|Database installation complete.