Details
-
Bug
-
Resolution: Fixed
-
Medium
-
1.0.618
-
Severity 3 - Minor
-
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
- relates to
-
CONFCLOUD-47922 DatabaseNameHelper failing in Oracle
- Closed