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
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,338 views 2 13
Read article

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