8 Replies Latest reply on Nov 17, 2015 6:09 AM by cwinning

    Refresh files problem- stuck at Updating the database

    PaulFreedman Apprentice

      We have ran into another problem with 9.2 today; when selecting to refresh files it seems that the whole database is being updated. The screen stops at Updating the database with the latest definitions.... and then time outs?

       

       

      Is this a known issue? Is there anyway to resolve this? Our monthly patch cycle starts tomorrow so need to have the latest patches ready to go!

        • 1. Re: Refresh files problem- stuck at Updating the database
          cwinning CommunityTeam

          Hello,

           

          The Content Team may have made changes in the content that warranted these changes, this will happen from time to time.  To eliminate the timeout, you could increase the database timeout setting:  How To Increase The Database Timeout Period For Protect

           

          Thanks,

          Charles

          • 2. Re: Refresh files problem- stuck at Updating the database
            Rookie

            Actually it doesn't timeout, it crashes.

             

            We now can't do anything. Scans get stuck at stage 2 Import new definitions. It gets as far as "All engines and definitions are up to date" then gets stuck.

             

            Log file from the last attempt to refresh files which crashed after about 90 minutes

             

            2015-11-16T13:43:11.3039790Z 0022 V FileSetDownload.cs:521|Completed 'Global\StandardFileSet{FEDAE04D-2862-414d-A356-DE04A7569885}'.

            2015-11-16T13:43:11.3039790Z 0011 V FileSetDownload.cs:415|Released mutex 'Global\StandardFileSet{FEDAE04D-2862-414d-A356-DE04A7569885}'.

            2015-11-16T13:43:11.3039790Z 0022 V FileSetDownload.cs:231|Canceling remaining items in the set.

            2015-11-16T13:43:11.3039790Z 0022 I WorkItemController.cs:410|Download patch definitions ended with status: 'Completed'

            2015-11-16T13:43:11.3039790Z 0022 I WorkItemController.cs:395|Patch import starting

            2015-11-16T13:43:11.5384092Z 0006 V WindowsPatchData.cs:366|Package version: 2.0.1.5882.

            2015-11-16T13:43:19.1026245Z 0011 S CatalogImportOperation.cs:68|ImportAsync|Entering.

            2015-11-16T13:43:22.4627653Z 0027 V DbCatalogUpdateRepository.cs:205|Creating index on temp patch product definitions. 111253 total definitions.

            2015-11-16T14:15:23.0575750Z 0026 W AttemptTransaction.cs:262|Attempting to recover transaction in doubt. Attempt: 1, error: System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout

               --- End of inner exception stack trace ---

               at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)

               at System.Transactions.CommittableTransaction.BeginCommit(AsyncCallback asyncCallback, Object asyncState)

               at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl(Func`3 beginMethod, Func`2 endFunction, Action`1 endAction, Object state, TaskCreationOptions creationOptions)

               at ST.Data.CommittableTransactionExtensions.CommitAsync(CommittableTransaction transaction)

               at ST.Data.CatalogData.Patch.DbCatalogUpdateRepository.<InternalAddOrUpdateAsync>d__2d.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.DbAccessLayer.AttemptTransaction.<TryAsync>d__4`1.MoveNext().

            2015-11-16T14:15:25.9481919Z 0018 V DbCatalogUpdateRepository.cs:205|Creating index on temp patch product definitions. 111253 total definitions.

            2015-11-16T14:49:47.5654968Z 0013 W AttemptTransaction.cs:262|Attempting to recover transaction in doubt. Attempt: 2, error: System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout

               --- End of inner exception stack trace ---

               at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)

               at System.Transactions.CommittableTransaction.BeginCommit(AsyncCallback asyncCallback, Object asyncState)

               at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl(Func`3 beginMethod, Func`2 endFunction, Action`1 endAction, Object state, TaskCreationOptions creationOptions)

               at ST.Data.CommittableTransactionExtensions.CommitAsync(CommittableTransaction transaction)

               at ST.Data.CatalogData.Patch.DbCatalogUpdateRepository.<InternalAddOrUpdateAsync>d__2d.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.DbAccessLayer.AttemptTransaction.<TryAsync>d__4`1.MoveNext().

            2015-11-16T14:49:50.2217085Z 0015 V DbCatalogUpdateRepository.cs:205|Creating index on temp patch product definitions. 111253 total definitions.

            2015-11-16T15:24:18.2238504Z 0007 S CatalogImportOperation.cs:68|ImportAsync|Leaving.

            2015-11-16T15:24:18.2863523Z 0007 E WorkItemCatalogDataImport.cs:176|System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout

               --- End of inner exception stack trace ---

               at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)

               at System.Transactions.CommittableTransaction.BeginCommit(AsyncCallback asyncCallback, Object asyncState)

               at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl(Func`3 beginMethod, Func`2 endFunction, Action`1 endAction, Object state, TaskCreationOptions creationOptions)

               at ST.Data.CommittableTransactionExtensions.CommitAsync(CommittableTransaction transaction)

               at ST.Data.CatalogData.Patch.DbCatalogUpdateRepository.<InternalAddOrUpdateAsync>d__2d.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.DbAccessLayer.AttemptTransaction.<TryAsync>d__4`1.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.CatalogData.WindowsPatchDataImportAdapter.<PersistModelAsync>d__0.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.CatalogData.CatalogDataFileImporter.<ExecuteCatalogImportAsync>d__b.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.Data.CatalogData.CatalogDataFileImporter.<ImportAsync>d__0.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.BusinessObjects.FileDownload.CatalogImportOperation.<ImportAsync>d__8.MoveNext()

            --- End of stack trace from previous location where exception was thrown ---

               at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

               at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

               at ST.UI.Controllers.Tasks.WorkItemCatalogDataImport.<RunAsync>d__0.MoveNext()

            2015-11-16T15:24:18.5051188Z 0001 C Launcher.cs:177|System.InvalidOperationException: Crash from main UI thread ---> System.InvalidOperationException: Crash from main UI thread ---> System.TimeoutException: Transaction Timeout

               --- End of inner exception stack trace ---

               at ST.Protect.Launcher.ApplicationThreadException(Object sender, ThreadExceptionEventArgs e)

               at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

               at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

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

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

               --- End of inner exception stack trace ---

               at ST.Protect.Launcher.ApplicationThreadException(Object sender, ThreadExceptionEventArgs e)

               at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

               at System.Windows.Forms.Control.WndProcException(Exception e)

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

               at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

               at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

               at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

               at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

               at ST.Protect.Launcher.ExecuteMain()

               at ST.Protect.Launcher.ExecuteInMutex(Action action, String mutexName)

               at ST.Protect.Launcher.Main(String[] args)

            2015-11-16T15:42:31.9185766Z 0001 I Launcher.cs:348|'C:\Program Files\LANDesk\Shavlik Protect\ST.Protect.exe' is starting, version: 9.2.4918.0, full name: ST.Protect, Version=9.2.0.0, Culture=neutral, PublicKeyToken=19306d7375e33918.

            2015-11-16T15:42:32.0592044Z 0001 I Launcher.cs:461|Starting console 'CDLPATCH01 / CDLPatch01.cheshdatasys.co.uk' on Microsoft Windows NT 6.3.9600.0 (time zone: GMT Standard Time, UTC offset: 00:00:00)...

            2015-11-16T15:42:32.1686200Z 0001 I Launcher.cs:468|Database info:

            Server name: 'CDLSQL01\GENERAL'

            Database name: 'ShavlikScans'

            Command timeout '30' seconds

            Server version: '11.00.5058'

            • 3. Re: Refresh files problem- stuck at Updating the database
              Rookie

              Please see reply I just posted. We can't scan.

              Will the database timeout fix that too?

              • 4. Re: Refresh files problem- stuck at Updating the database
                cwinning CommunityTeam

                Hello,

                 

                It looks like we are updating the data format in Protect 9.2, this should only happen once after it finishes.  This is a major data change to the database,  This will cause the initial import to take a long time to get this done the first time, subsequent updates won't take so long.

                 

                You should increase the database timeout and let the update run without clicking on the screen.  This will take a long time to get this done the first time, subsequent updates won't take so long.  (this normally won't cause database timeouts, but environments vary)

                 

                Also, it is VERY important you upgrade to the latest version of Protect 9.2 before continuing.  The latest version is Protect 9.2.4988, you can see this in Help > About.

                 

                Let me know if you have questions.

                 

                Thanks,

                Charles

                1 of 1 people found this helpful
                • 5. Re: Refresh files problem- stuck at Updating the database
                  Rookie

                  Thanks for the response. I've updated the timeout but we're not on the latest version. I'll have to get a change control put through to update it tomorrow.

                  • 6. Re: Refresh files problem- stuck at Updating the database
                    cwinning CommunityTeam

                    Good, there are a good number of very important fixes in the latest version of Protect 9.2 that will benefit you.

                     

                    Let me know if you have any issues.

                     

                    Thanks,

                    Charles.

                    • 7. Re: Refresh files problem- stuck at Updating the database
                      Rookie

                      Hi Charles

                       

                      The upgrade has fixed the issue. I left the extended timeout in place but the refresh files completed in a couple of minutes so I don't think that was the issue.

                      The bug fixes were required it seems.

                       

                      Thanks for the help

                      Martin

                      • 8. Re: Refresh files problem- stuck at Updating the database
                        cwinning CommunityTeam

                        Hello Martin,

                         

                        Glad to see the upgrade corrected the issue, thanks for taking the time to let us know.

                         

                        Thanks,

                        Charles