Team Calendar ORA-01427 Error

Question

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?

Jason Brady · Answer

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.

AnnWorley · Answer

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.