---In firebird-support@yahoogroups.com, <firebird-support@yahoogroups.com> wrote:

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:

 

It is due to the TIMESTAMP which is a reserved word for Firebird database but in JIRA it is actually a column name therefore JIRA failed to export the required data.

　

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