To fix the error we will need to:
1. Verify the database collation is set to UTF-8. You can do so by running this SQL query:
If the collation is not set to UTF-8, please set it to UTF-8 before moving forward.
2. Reindex all indexes in the Artifactory database
3. Truncate the access_db_check table
1. Verify the database collation is set to UTF-8. You can do so by running this SQL query:
SELECT datname, datcollate FROM pg_database;
If the collation is not set to UTF-8, please set it to UTF-8 before moving forward.
2. Reindex all indexes in the Artifactory database
3. Truncate the access_db_check table
TRUNCATE TABLE access_db_check;4. Restart Artifactory