SQL Search not returning any results

• 
  I got the same exact problems...I've carried out a general update on the Redgate SQL Toolbelt and since then SQL Search doesnot returen any results anymore. Please provide a solution for that!
  

  christophgm March 18, 2019 08:02

  - 0 +
• 
  We're investigating this behaviour, I'll update this when we have a solution.

  Russell D March 18, 2019 15:58

  - 0 +
• 
  Thanks for looking into it! Same issue here and this makes search entirely useless.

  ejenkins March 19, 2019 19:03

  - 0 +
• 
  Thanks. Same problem here, and right when I really needed it.
  

  EricT March 19, 2019 23:39

  - 0 +
• 
  Same issue here. SQL Search effectively useless while this problem exists.

  TheoL March 20, 2019 10:16

  - 0 +
• 
  Just wanted to add: I have the same problem.
  

  soadie March 20, 2019 10:29

  - 0 +
• 
  Also would like to report that I'm experiencing this issue. If I manage to find a work around I'll post it here.

  JackTomlinson March 20, 2019 11:19

  - 0 +
• 
  I was having this same issue.
  
  I resolved it by replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL Prompt 9 folder, C:\Program Files (x86)\Red Gate\SQL Prompt 9). 
  
  It looks like it's likely due to the multiple versions of SQLite being used and the x64/x86 versions not being published appropriately for the new version (1.0.110.0)
  
  BTW, this did not work when I replaced it with 1.0.109.0 - my guess it has to do with the changes to the library pre-loader introduced in 1.0.91.0.
  
  I now know that this happens because SQL Prompt uses version 1.0.85.0 and Search uses 1.0.110.0, but tries to use the Prompt version of SQLite.Interop.DLL. So as long as both Prompt and Search use the same version, it will work fine. 
  
  Looks like an integration testing problem! Prompt and Search both work fine alone, but if you install both of them then Search breaks.

  Vivan March 20, 2019 12:23

  - 0 +
• 
  Vivans response has fixed my issue and I advise anyone else facing the same issue to do the same.
  
  Thanks Vivan

  JackTomlinson March 20, 2019 12:43

  - 0 +
• 
  I agree with JackTomlinson. Vivians response has also fixed it on my side.
  

  soadie March 20, 2019 12:47

  - 0 +
• 
  Glad I could help - the 2 hours I spent messing around with this were not in vain!

  Vivan March 20, 2019 13:30

  - 0 +
• 
  Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.

  ejenkins March 20, 2019 14:19

  - 0 +
• 

  ejenkins said:

  Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.

  It's C:\ProgramData\Red Gate\SQL Search\Source not C:\Program Files (x86)\Red Gate\SQL Search 3

  Vivan March 20, 2019 14:20

  - 0 +
• 
  Ah I missed "ProgramData"... Thanks!!

  ejenkins March 20, 2019 14:21

  - 0 +
• 
  Vivan's solution worked for me.

  dqbrown March 20, 2019 14:55

  - 0 +
• 
  Yeah its the latest release that uses different dependency version that breaks this. If you dont need Prompt uninstalling that will also work (rather than the entire rest of the toolbelt). Its only an issue affecting Prompt and Search when both are installed.

  Russell D March 20, 2019 15:07

  - 0 +
• 

  ejenkins said:

  Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.

  Same here. Please send an update for the extension.

  evanfantr March 20, 2019 18:03

  - 0 +
• 

  evanfantr said:

  ejenkins said:

  Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.

  Same here. Please send an update for the extension.

  See my above message.

  Vivan March 20, 2019 18:42

  - 0 +
• 
  ...And an update is already out to fix the issue https://update.red-gate.com/updatecontrols/details.aspx?etc=575538536&guid=ca71d7aa-92da-44c7-a27e-b7ba34945d44&update=2695. Thanks Red Gate and kudos again to Vivan for finding the exact problem!

  ejenkins March 20, 2019 18:43

  - 0 +
• 
  Yes thanks for the link @ejenkins - this is now fixed in 9.4.14.
  

  Russell D March 21, 2019 09:28

  - 0 +
• 
  @Russell D and @ejenkins the link does not take me to a fix.  It goes to SQL Prompt page and then a place to download a trial edition.  i have a license to the toolbelt and need an update for my purchased product.  thanks
  

  swade June 13, 2019 17:22

  - 0 +
• 
  @swade it was just the release notes for a past update that fixed the issue. As long as you update your RedGate products, particularly SQL Prompt and SQL Source Control this specific issue shouldn't occur.

  ejenkins June 13, 2019 18:17

  - 0 +
• 

  Vivan said:

  I was having this same issue.
  
  I resolved it by replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL Prompt 9 folder, C:\Program Files (x86)\Red Gate\SQL Prompt 9). 
  
  It looks like it's likely due to the multiple versions of SQLite being used and the x64/x86 versions not being published appropriately for the new version (1.0.110.0)
  
  BTW, this did not work when I replaced it with 1.0.109.0 - my guess it has to do with the changes to the library pre-loader introduced in 1.0.91.0.
  
  I now know that this happens because SQL Prompt uses version 1.0.85.0 and Search uses 1.0.110.0, but tries to use the Prompt version of SQLite.Interop.DLL. So as long as both Prompt and Search use the same version, it will work fine. 
  
  Looks like an integration testing problem! Prompt and Search both work fine alone, but if you install both of them then Search breaks.

  Very nice solution, thanks full
  La solucion consiste en copiar el archivo System.Data.SQLite.dll de la ruta "C:\Program Files (x86)\Red Gate\SQL Prompt 6"  ( esta ruta es en la que tienen instalado el SQL Prompt) y pasarla a la ruta "C:\Program Files (x86)\Red Gate\SQL Search" ( esta ruta es en la que tienen instalado el SQL Search) y reinician los servicios del sql server o reinician la pc.

  JArmando October 02, 2019 16:23

  - 0 +
• 
  I had to do some more work.
  
  Infact, Vivan help it eliminated the log error concerning the System.data.SQlite.dll but all the same, indexing was too much fast and Sql Search was still not returning any result.
  
  Eventually I looked for indexes files created by Sql Search while indexing each database, I found them inside C:\Users\yourusername\AppData\Local\Red Gate\SQLSearch 3\Indexes folder, I deleted them since they had an old "Date modified", I got back to Sql Search in SSMS and I pressed Reindex (Ctrl-Alt-D)
  
  I observed that my indexes file were recreated and Sql Search finally worked.
  
  Ettore
  
  

  Ettore February 07, 2020 12:45

  - 0 +

Add comment

Please sign in to leave a comment.