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

Wrong DB collation check for MSSQL, can fail startup in future version

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 7.0.0
    • Fix Version/s: None
    • Component/s: Database

      Description

      Artifactory requires case sensitive check, and this protection and check has been added in RTFACT-9066 though not yet enabled (planned to be), instead, currently an error is reported.

      For MSSQL, the collation check is done per the database instance and not the application specific database:

      SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));
      

      and should be:

      SELECT collation_name
      FROM sys.databases
      WHERE name = 'Artifactory DB name'
      

      Steps to reproduce currently harmless error:

      1. Setup 6.13.0 with MSSQL
      2. Inspect startup log:

      2019-10-08 09:39:51,600 [art-init] [ERROR] (o.a.s.d.v.GeneralValidator:45) - DATABASE SCHEME BAD COLLATION -> sql_latin1_general_cp1_ci_as
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                barh Bar Haim
                Reporter:
                andreik Andrei Komarov
              • Votes:
                2 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: