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

DatabaseNameHelper failing in Oracle

    XMLWordPrintable

Details

    Description

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

      DatabaseNameHelper will fail in Oracle with error ORA-01424: missing or illegal character following the escape character when there is some table with special characters in their name.

      Caused by: org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; ORA-01424: missing or illegal character following the escape character
      ; nested exception is java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character
      
      	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:78)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349)
      	at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:103)
      	at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:96)
      	at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:109)
      	at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveName(DatabaseNameHelperImpl.java:85)
      	at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveTableName(DatabaseNameHelperImpl.java:64)
      	at com.atlassian.confluence.plugins.questions.repository.querydsl.AbstractRelationalPathBase.<init>(AbstractRelationalPathBase.java:14)
      	at com.atlassian.confluence.plugins.questions.repository.querydsl.ContentTable.<init>(ContentTable.java:28)
      	at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:69)
      	at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:65)
      	at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper.getMapping(QueryDSLMapper.java:50)
      	at com.atlassian.confluence.plugins.questions.internal.upgrade.DuplicatedAcceptedAnswersRemover.deleteDuplicatedAcceptedAnswers(DuplicatedAcceptedAnswersRemover.java:40)
      	at com.atlassian.confluence.plugins.questions.internal.upgrade.AnswerAcceptanceMigrationToAoUpgradeTask.upgrade(AnswerAcceptanceMigrationToAoUpgradeTask.java:66)
      

      Workaround:

      Uninstall version 1.0.618 and then install version 1.0.469, available here.

      Attachments

        Issue Links

          Activity

            People

              jhoarau Julien Michel Hoarau (Inactive)
              jhoarau Julien Michel Hoarau (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: