Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Problems with Active Object while exporting and importing

IT-Administration
IT-Administration
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
March 14, 2012

The following things were done recently:

# migration from JIRA 4.3.4 to 4.4.4 (with an upgrade)

# renaming of all (JIRA-internal) users to fit the company standard (using the build-in script from the groovy-runner plugin)

# setting the company LDAP server as primary authentication method

Now all Restore System tries fail with all previous backups (very recent ones as well as very old ones). The Error Message is:

Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with :

•Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin="">:

----

the LogFile show:

2012-03-15 17:42:18,133 JiraImportTaskExecutionThread-1 ERROR admin 1062x347x1 tl9lqn 172.21.22.221 /secure/admin/XmlRestore.jspa jira.bc.dataimport.DefaultDataImportService Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin="">:

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin="">:

at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:32)

at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.onSqlException(ActiveObjectsDatabaseCleaner.java:104)

at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:78)

at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)

at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:170)

at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:719)

at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:465)

at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:214)

at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)

at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)

at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)

at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: org.postgresql.util.PSQLException: FEHLER: Funktion public.ao_60db71_sprint_cl1004036686() existiert nicht

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)

at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)

at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:74)

... 18 more

Answer
Watch
Like Deleted user likes this
499 views

2 answers

5 votes
Ruchi Tandon
Ruchi Tandon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 15, 2012

Hi Sulzer,

I investigated the logs and I see the following error in the logs :

Caused by: org.postgresql.util.PSQLException: FEHLER: Funktion public.ao_60db71_sprint_cl1004036686() existiert nicht

	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

This error is complaining about a function from Greenhopper that it cannot find. 

2012-03-15 13:28:38,167 IssueIndexer:thread-1 ERROR admin 768x85x1 zn0msp 172.21.22.221 /secure/admin/XmlRestore.jspa [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'com.pyxis.greenhopper.jira:gh-sprint'. Is the plugin present and enabled?

I noticed that Greenhopper is currently disabled on your instance. 

2012-03-15 13:28:20,774 JiraImportTaskExecutionThread-1 INFO admin 768x85x1 zn0msp 172.21.22.221 /secure/admin/XmlRestore.jspa [atlassian.plugin.loaders.ScanningPluginLoader] Plugin Unit: /opt/jira/plugins/.bundled-plugins/jira-greenhopper-plugin-5.7.4-disabled.jar (1329329356000) created

So basically, the import file contains Greenhopper related data. When you are trying to insert data into the new system, then Jira cannot find the classes related to Greenhopper as its disabled on the instance.

Could you please enable Greenhopper and then try to import the backup. Let em know how you go.

Regards,

Ruchi

View More Comments
Jeffrey Toce
Jeffrey Toce March 16, 2012

Ruchi- you are awesome! I was having the same problem importing existing data during the setup wizard. I kept getting an error about ActiveObjects. You were right- I needed to install Greenhopper first and then do the import.

Thanks!

Like
Ellen Feaheny [
Ellen Feaheny [AppFusions]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
March 16, 2012

Nice nugget!

Like
Reply
0 votes
Jeffrey Toce
Jeffrey Toce March 16, 2012

Ruchi- you are awesome! I was having the same problem importing existing data during the setup wizard. I kept getting an error about ActiveObjects. You were right- I needed to install Greenhopper first and then do the import.

Thanks!

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events