Invalid column name 'idx'

dcoyledcoyle Posts: 6
edited December 21, 2016 9:23AM in SQL Monitor 6
After update of SQL Monitor to version 6.0.15 from 6.0.1 when I am redirected back to the SQL Monitor website I now get the error:

Unable to connect to the data repository
Invalid column name 'idx'

Any thoughts regarding why this is occurring and how to resolve?
· Share on Twitter

Comments

  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi dcoyle,

    This is due to a having a Case Sensitive Collation (CS or BIN) on the SQL Server housing the SQL Monitor data repository. I have found and fixed the issue (one of the update scripts has 'idx' instead of 'Idx') and it will be out in the next release.

    In the meantime please roll back to your previous version until this is available!.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • dcoyledcoyle Posts: 6
    Thanks Alex. Fantastic work. Look forward to next hotfix.
    · Share on Twitter
  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi dcoyle,

    SQL Monitor 6.0.16 has been released and you should be able to get this by going to Configuration > About and clicking on "get latest version" next to where it indicates the current version.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.