How can we help you today? How can we help you today?

Just installed SQL Prompt and the app now shows "No Suggestions" for even the simplest of queries

I Installed version 10.0.8.13383.  Everything was working before the upgrade

Microsoft SQL Server Management Studio versions I tried
  • v18.4
  • 12.0.5223.
Not sure if any of this log is helpful:
16 Jan 2020 19:10:35,809 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 60841100
16 Jan 2020 19:10:35,820 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,825 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,832 [1] DEBUG RedGate.SQLQueryKeeper.TabWatcher - Activation changed from Object Explorer to SQLQuery1.sql - localhost.EnstepDev (ACROTEQ\bmeyers (57))
16 Jan 2020 19:10:35,834 [1] DEBUG RedGate.SQLQueryKeeper.TabWatcher - Document losing focus
16 Jan 2020 19:10:35,836 [1] DEBUG RedGate.SQLQueryKeeper.TabWatcher - Document gaining focus
16 Jan 2020 19:10:35,846 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,850 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,852 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 60841100
16 Jan 2020 19:10:35,855 [1] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [7792] Started task 'Code analysis task <SQLQuery1.sql - localhost.EnstepDev (mydomain\bmeyers (57))>'.
16 Jan 2020 19:10:35,914 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,930 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,932 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 60841100
16 Jan 2020 19:10:35,935 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:35,968 [44] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<AlwaysSkipWorkInput, IList<AnalysisIssue>> - [7792] Run 'Code analysis task <SQLQuery1.sql - localhost.EnstepDev (ACROTEQ\bmeyers (57))>' completion handler!
16 Jan 2020 19:10:35,973 [44] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [7792] Successfully finishing current task 'Code analysis task <SQLQuery1.sql - localhost.EnstepDev (ACROTEQ\bmeyers (57))>'.
16 Jan 2020 19:10:36,063 [BatchingUsageApiClient] DEBUG RedGate.SQLPrompt.UsageReporting.UsageData.Reporting.UsageReporter - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
  Number of submitted usage events = 3
  HTTP status code = 204 NoContent
  Response body =
16 Jan 2020 19:10:42,664 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Jan 2020 19:10:42,667 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 60841100
16 Jan 2020 19:10:42,690 [37] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:\Users\bmeyers\AppData\Local\Red Gate\SQL Prompt 10\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)...
16 Jan 2020 19:10:42,694 [37] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions
16 Jan 2020 19:10:42,701 [44] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:\Users\bmeyers\AppData\Local\Red Gate\SQL Prompt 10\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)...
16 Jan 2020 19:10:42,704 [44] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions

bmeyers
0

Comments

9 comments

Sort by
  • gug
    I have the exact same issue. When I tried refreshing suggestions, it refreshes the master database regardless of the database I'm using. Even with that, there are no suggestions for even the master database.
    gug
    0
  • gug
    I found a fix that worked for me. Somehow, an options setting default seems to have been changed with this update. I changed it (back) to Options > Connections >Load Suggestions for all Databases and Schemas.
    gug
    0
  • bmeyers
    That was my exact problem.  Thank you!  It is now working for me.
    bmeyers
    0
  • Steve_77777
    Same problem here and that solution worked for me.  I had also contacted support and they provided the same solution.
    Steve_77777
    0
  • ebridges
    Yikes!  I'm going to start checking here before taking future updates.  Luckily this solution worked for me!
    ebridges
    0
  • Jeff_L
    I found the same thing fixes it.  When it first happened I noticed it was set to Only load suggestions for certain databases/schemas, as I had set it, but my list of databases & schemas was cleared out.  I re-entered them and then the next day they were gone again.  This is a bug that needs to be fixed.
    Jeff_L
    0
  • TomW
    Hi @Jeff_L

    So sorry to hear you're having issues with SQL Prompt. Which version are you currently running? We know we accidentally introduced a bug that removed the filtering settings, but it should be fixed in 10.0.10.

    Please let me know if you have any further issues.

    Tom
    Team Prompt
    TomW
    0
  • bmeyers
    @TomW, thank you for your reply.  This problem was first created when 10.0.8.13383 was released.  I confirmed that it is also working in 10.0.10.   But I am not sure if that is because of the settings I changed with the help of gug, or if this newer version fixed the original issue.  But anyway, it is working for me.
    bmeyers
    0
  • Jeff_L
    TomW said:
    Hi @Jeff_L

    So sorry to hear you're having issues with SQL Prompt. Which version are you currently running? We know we accidentally introduced a bug that removed the filtering settings, but it should be fixed in 10.0.10.

    Please let me know if you have any further issues.

    Tom
    Team Prompt
    @TomW, yes 10.0.10 fixed the issue.  Thanks.
    Jeff_L
    0

Add comment

Please sign in to leave a comment.