Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-20303

MS SQL: Wrong collation check on startup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 6.13.1
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None

      Description

      When starting Artifactory, a log message appears

      2019-10-09 07:08:32,319 [art-init] [ERROR] (o.a.s.d.v.GeneralValidator:45) - DATABASE SCHEME BAD COLLATION -> latin1_general_ci_as
      

       

      This log message is wrong, because the database collation is correct:

       

      SELECT CONVERT (varchar(256), DATABASEPROPERTYEX('artifactory','collation'));
      
      Result: Latin1_General_CS_AI

       

      Did you query the sql server's default collation?

      SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));
      
      Result: Latin1_General_CI_AS

       

      Please change that check, because such a logging is highly confusing.

       

       

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            steffel Stefan Felkel
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: