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?
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.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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!
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