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

This widget could not be displayed.
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 Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

602 views 8 6
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