SQL Prompt just stopped working as before

jenV

Hi,
I have a new license for SQLPrompt and was on version 8.1.0.2354. Suddenly, the editor tools stopped working as they had, e.g. suggestions not working, when I was going through an insert statement and highlighting a field, the corresponding field in the select statement wasn't highlighted as before etc. I am on SSMS 2017, SQLServer 2012

I looked in the log and saw this error a lot:
DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection

after checking the forum I saw similar errors were supposed to be fixed in the newest release. I downloaded the latest (8.2.5.2924) and also restarted my PC for good measure. The suggestions have partially come back, but individual sql files are still flaky, and the insert highlighter still isn't working.

I am still seeing errors like this in the log:
07 Nov 2017 14:10:27,071 [5] DEBUG RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database DW
07 Nov 2017 14:10:37,090 [5] DEBUG RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database DW
07 Nov 2017 14:10:47,112 [5] DEBUG RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database DW
07 Nov 2017 14:10:57,129 [5] DEBUG RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database DW
07 Nov 2017 14:10:59,832 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
07 Nov 2017 14:10:59,833 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 423632588
07 Nov 2017 14:11:02,142 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
07 Nov 2017 14:11:02,145 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
07 Nov 2017 14:11:02,146 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
07 Nov 2017 14:11:02,146 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 423632588
07 Nov 2017 14:11:02,147 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
07 Nov 2017 14:11:07,146 [5] DEBUG RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database DW
07 Nov 2017 14:11:10,295 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection

Michael Clark

Hi @jenV,

We've done a number of releases since then, so the latest version may work better for you.

Would it be possible to update to the latest version SQL Prompt 9.0.6?

Download SQL Prompt 9.0.6

Please let us know if the issues persist and will try to investigate further.

Best wishes,

Michael