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

bmeyersbmeyers Posts: 3 New member
edited January 16, 2020 7:13PM in SQL Prompt
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

Tagged:
· Share on Twitter

Best Answers

  • guggug Posts: 2 Bronze 2
    Answer ✓
    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.
    · Share on Twitter
  • guggug Posts: 2 Bronze 2
    Answer ✓
    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.
    · Share on Twitter

Answers

  • bmeyersbmeyers Posts: 3 New member
    That was my exact problem.  Thank you!  It is now working for me.
    · Share on Twitter
  • Steve_77777Steve_77777 Posts: 3 Bronze 1
    Same problem here and that solution worked for me.  I had also contacted support and they provided the same solution.
    · Share on Twitter
  • ebridgesebridges Posts: 3 Bronze 1
    Yikes!  I'm going to start checking here before taking future updates.  Luckily this solution worked for me!
    · Share on Twitter
  • Jeff_LJeff_L Posts: 2 New member
    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.
    · Share on Twitter
  • TomWTomW Posts: 108 Gold 1
    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
    Software Engineer for SQL Prompt
    Redgate Software
    · Share on Twitter
  • bmeyersbmeyers Posts: 3 New member
    @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.
    · Share on Twitter
  • Jeff_LJeff_L Posts: 2 New member
    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.
    · Share on Twitter
Sign In or Register to comment.