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

The Usage Statistics doesn't show up in Questions when Confluence is installed in Oracle 11g

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      If Confluence question is installed on a Confluence in conjunction with Oracle 11g the statistics page will not display anything:

      If you check the atlassian-confluence logs you will see the following error:

      015-03-16 19:19:14,703 ERROR [http-bio-8090-exec-2950] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: StatementCallback; uncategorized SQLException for SQL [select count("tmp"."creator")
      from ((select "CONTENT"."CREATOR" "creator"
      from "CONTENT" "CONTENT"
      where "CONTENT"."PLUGINKEY" in ('com.atlassian.confluence.plugins.confluence-questions:question', 'com.atlassian.confluence.plugins.confluence-questions:answer', 'com.atlassian.confluence.plugins.confluence-questions:comment') and "CONTENT"."PREVVER" is null)
      union
      (select "AO_B1DBB9_VOTE"."USER_KEY"
      from "AO_B1DBB9_VOTE" "AO_B1DBB9_VOTE")) "tmp"]; SQL state [72000]; error code [12704]; ORA-12704: character set mismatch
      ; nested exception is java.sql.SQLException: ORA-12704: character set mismatch
      
       -- url: /confluence/rest/questions/1.0/statistics | userName: a4078 | referer: https://poc.amberroad.com/confluence/questions/stats
      org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select count("tmp"."creator")
      from ((select "CONTENT"."CREATOR" "creator"
      from "CONTENT" "CONTENT"
      where "CONTENT"."PLUGINKEY" in ('com.atlassian.confluence.plugins.confluence-questions:question', 'com.atlassian.confluence.plugins.confluence-questions:answer', 'com.atlassian.confluence.plugins.confluence-questions:comment') and "CONTENT"."PREVVER" is null)
      union
      (select "AO_B1DBB9_VOTE"."USER_KEY"
      from "AO_B1DBB9_VOTE" "AO_B1DBB9_VOTE")) "tmp"]; SQL state [72000]; error code [12704]; ORA-12704: character set mismatch
      ; nested exception is java.sql.SQLException: ORA-12704: character set mismatch
      
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
      	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
      	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
      	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:474)
      	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:479)
      	at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:488)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.ContentTypeStatisticRepository.countUnion(ContentTypeStatisticRepository.java:154)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.ContentTypeStatisticRepository.getTotalContributors(ContentTypeStatisticRepository.java:111)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.ContentTypeStatisticRepository.getTotalContributors(ContentTypeStatisticRepository.java:97)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.CacheStatisticRepository$2.get(CacheStatisticRepository.java:76)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.CacheStatisticRepository$2.get(CacheStatisticRepository.java:72)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.CacheStatisticRepository.getFromCache(CacheStatisticRepository.java:201)
      	at com.atlassian.confluence.plugins.questions.contenttype.repository.CacheStatisticRepository.getTotalContributors(CacheStatisticRepository.java:71)
      	at com.atlassian.confluence.plugins.questions.service.StatisticServiceImpl$GetTotalContributersDTO.apply(StatisticServiceImpl.java:146)
      	at com.atlassian.confluence.plugins.questions.service.StatisticServiceImpl$GetTotalContributersDTO.apply(StatisticServiceImpl.java:140)
      	at com.atlassian.confluence.plugins.questions.service.StatisticServiceImpl.getStatistics(StatisticServiceImpl.java:74)
      	at com.atlassian.confluence.plugins.questions.service.StatisticServiceImpl.getGlobalStatistics(StatisticServiceImpl.java:58)
      	....
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
      	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
      	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: ORA-12704: character set mismatch
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	...
      	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
      	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:443)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
      	... 272 more
      

      Attachments

        Issue Links

          Activity

            People

              vvo Vu Truong Vo (Inactive)
              81f8f6d85510 carolyn french
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: