How can we help you today? How can we help you today?
marekprz
Activity overview Badges (0) Posts (1) Comments (9)

Activity overview

Latest activity by marekprz

Hi Eddie, Yes, that did the trick. Looks like it's fixed. Thanks. Marek / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Hi Eddie,Yes, that did the trick. Looks like it's fixed. Thanks.Marek
0 votes
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; Re...
0 votes
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; Re...
0 votes
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; Re...
0 votes
log snippet: 26 Nov 2018 15:10:39,776 [1] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'. 26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 26 Nov 2018 15:10:40,104 [33] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler! 26 Nov 2018 15:10:40,104 [33] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'. 26 Nov 2018 15:10:42,026 [49] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. 26 Nov 2018 15:10:42,151 [53] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler! 26 Nov 2018 15:10:42,151 [53] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. 26 Nov 2018 15:10:42,698 [58] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. 26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False 26 Nov 2018 15:10:42,698 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go 26 Nov 2018 15:10:42,698 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll 26 Nov 2018 15:10:42,714 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False 26 Nov 2018 15:10:42,714 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go 26 Nov 2018 15:10:42,714 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll 26 Nov 2018 15:10:42,714 [37] INFO  RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 26 Nov 2018 15:10:43,011 [37] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler! 26 Nov 2018 15:10:43,011 [37] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
log snippet: 26 Nov 2018 15:10:39,776 [1] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (...
0 votes
Looks like some dependencies aren't loading, right? This should be from several clicks on the code above. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? This should be from several clicks on the code above. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [...
0 votes
Looks like some dependencies aren't loading, right? Maybe that's MY problem (and not redgate's)? This log should be from several attempts. And it looks like it doesn't actually get hung up indefinitely, just longer than expected. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? Maybe that's MY problem (and not redgate's)? This log should be from several attempts. And it looks like it doesn't actually get hung up indefin...
0 votes
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.</div>26 Nov 2018 15:10:40,088 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6117] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>' completion handler!<br>26 Nov 2018 15:10:40,104 [33] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6117] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))>'.<br>26 Nov 2018 15:10:42,026 [49] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6186] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:42,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6186] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [58] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:42,698 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,698 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:42,714 [37] DEBUG RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.TfsExtendedClientDllLoader - looking in Dependencies\TFS\ExtendedClient folder: installPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6, relativeAssemblyPath: Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, workingDir: C:\WINDOWS\system32, assemblyPath: C:\Program Files (x86)\Red Gate\SQL Source Control 6\Dependencies\TFS\ExtendedClient\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll, exists: False<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91, let's have a go<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\Microsoft.SqlServer.TransactSql.ScriptDom.resources.dll<br>26 Nov 2018 15:10:42,714 [37] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly Microsoft.SqlServer.TransactSql.ScriptDom.resources, Version=14.0.0.0, Culture=en-US, PublicKeyToken=89845dcd8080cc91<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6231] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:43,011 [37] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6231] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,026 [50] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6272] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:10:44,151 [53] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6272] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:10:51,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,315 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:07,331 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:07,331 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [6541] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:07,659 [42] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [6541] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:08,784 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en-US, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.Honeycomb.Wpf.resources.dll<br>26 Nov 2018 15:11:08,800 [1] INFO&nbsp; RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.Honeycomb.Wpf.resources, Version=3.2.1.220, Culture=en, PublicKeyToken=7f465a1c156d4d57<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:11,394 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:13,310 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:13,310 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [8910] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:13,669 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [8910] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:15,856 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,091 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:19,091 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:19,247 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9040] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:19,263 [18] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9040] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:21,966 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,045 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,060 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 50557452<br>26 Nov 2018 15:11:23,060 [1] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Started task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'.<br>26 Nov 2018 15:11:23,232 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [9121] Run 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>' completion handler!<br>26 Nov 2018 15:11:23,263 [19] INFO&nbsp; RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [9121] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - <SERVERNAME>.master (<AD USER> (59))*>'. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Looks like some dependencies aren't loading, right? This should be from several attempts. Looks like it doesn't actually get hung up indefinitely. <div>26 Nov 2018 15:10:39,776 [1] INFO&nbsp; Re...
0 votes
Thanks for looking into this. I'm having a difficult time posting a response with log file rows. It says it accepts my post, but my post returns as a draft. It looks like this might be similar to https://forum.red-gate.com/discussion/84356, so I'll follow that one for info. / comments
  1. Community
  2. SQL Prompt
  3. SSMS Hangs with certain INSERT statement
Thanks for looking into this. I'm having a difficult time posting a response with log file rows. It says it accepts my post, but my post returns as a draft. It looks like this might be similar to...
0 votes
SSMS Hangs with certain INSERT statement
  1. Community
  2. SQL Prompt
Hi,I'm encountering a hanging SSMS when SQL Prompt tries to analyze this query in a query window:INSERT INTO [ABC_ALL] SELECT * FROM [ABC_1] UNION ALL SELECT * FROM [ABC_2]If I turn off Code Analys...
2 followers 12 comments 0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1