Hi,

i have issues creating a backup file within JIRA. I'm using JIRA 4.4 with Firebird 2.1.3.

This is the error message i'm getting:

com.atlassian.core.AtlassianCoreException: Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, VOTES, TIMESTAMP FROM votehistory (GDS Exception. 335544569. Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 38

FROM)

at com.atlassian.jira.service.services.export.ExportService.performBackup(ExportService.java:139)

at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:121)

at com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:60)

at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:47)

at org.quartz.core.JobRunShell.run(JobRunShell.java:195)

at com.atlassian.multitenant.quartz.MultiTenantThreadPool$MultiTenantRunnable.run(MultiTenantThreadPool.java:72)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

The answer from Atlassian is as follows:

Is there any way to get the export working again by changing settings within firebird? I need to export the current data to a new PostgreSQL database.

Best regards

Artur