Team Calendar ORA-01427 Error

Freshly installed Confluence with Team Calendars but every time I try to create a calendar I geta ConnectionCallback: bad SQL grammar []; nested exception is java.sql.SQLException: ORA-01427: single-row subquery returns more than one row, error. What am I missing, any one else experince this issue?

1 answer

0 votes
Ann Worley Atlassian Team May 31, 2017

I understand your Oracle database is returning a ORA-01427 error when you try to create a Team Calendar. Since it is a new installation it is hard to believe that there is a duplicate value in the database as described in this article. I suspect that the database was not set up exactly as recommended in Database Setup for Oracle. We have run into issues in the past when Oracle users have the ability to see tables in multiple schemas.

Since it is a new installation, please consider reinstalling if the issue persists.

Thank you for the response. I have uninstalled and reinstall multiple times. I have also double checked my database to make sure it matches the setup described in the documentation. I still received the same ORA-01427 when attempting to use team calendars. Everything else in confluence is functions properly. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

69 views 3 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you