I am developing a plugin for JIRA using Active Objects.. I need to modify some of the columns in the plugin AO table so I modified the JAVA AO object and removed the plugin AO table and restarted the application. When I upload this plugin jar and access the new feature, I am getting SQL exception. How to resolve this issue?
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options - minor version:2 - major version:11 Driver: - name:Oracle JDBC driver - version:11.2.0.2.0 java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options - minor version:2 - major version:11 Driver: - name:Oracle JDBC driver - version:11.2.0.2.0 java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
Community moderators have prevented the ability to post new answers.
Hi team,
Is this Oracle instance being used by other Atlassian apps? I ask that since they can throw this error of existing objects.
In this case, you will need to create a view for the user running Confluence and the others as well.
Check this KB for further details.
Cheers,
Rodrigo
Check your entity annotations for duplicate table names. If you turn up SQL logging, specifically for AO, it will help you understand why this happens...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Atlassians, Any update please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Community moderators have prevented the ability to post new answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.