There was a SQL exception thrown by the Active Objects library:

[srinivasp]

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

[Rodrigo Girardi Adami]

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

[Andy Brook]

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...

[srinivasp]

Hi Atlassians, Any update please?