Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-95870

Bug in the analytics user counting on MSSQL

XMLWordPrintable

      The below error message appears in the application logs:

      2024-05-17 04:00:12,223 ERROR [pool-9-thread-1] [plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier] getNumberOfDarkThemeUsers Error getting number of dark theme users
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
. . .
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'os_propertyentry'.

      The table name on the MSSQL server is upper case.
      I created a Confluence 8.9.0 by using the MSSQL 2019 database and it seems the Publish Daily Statistics is calling this table by using the lowercase table name. The database collation setting shows that the setting is case sensitive as we are expecting;

      confluence	SQL_Latin1_General_CP1_CS_AS

            [CONFSERVER-95870] Bug in the analytics user counting on MSSQL

            James Whitehead added a comment -

            A fix for this issue is available in Confluence Data Center 9.0.1.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Whitehead added a comment - A fix for this issue is available in Confluence Data Center 9.0.1. Upgrade now or check out the Release Notes to see what other issues are resolved.

            Jordan Anslow added a comment -

            A fix for this issue is available in Confluence Server and Data Center 8.9.2.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Jordan Anslow added a comment - A fix for this issue is available in Confluence Server and Data Center 8.9.2. Upgrade now or check out the Release Notes to see what other issues are resolved.

              9af32a41284c Jake Lyell
              jhronik Jiri Hronik
              Affected customers:
              1 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: