SQL Exception on Oracle Due to JIRA Charting Plugin
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When using the JIRA charting plugin, an SQL exception is thrown:
2008-02-25 15:32:40,623 http-8080-Processor24 ERROR [plugin.report.timecharts.TimeChart] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select changegroup.CREATED, jiraissue.pkey, changeitem.FIELD, changeitem.OLDVALUE, changeitem.OLDSTRING, changeitem.NEWVALUE, changeitem.NEWSTRING, changeitem.FIELDTYPE from changegroup, changeitem, jiraissue where changegroup.ID=changeitem.groupid and changegroup.issueid=jiraissue.ID and changegroup.CREATED > '2008-01-26 00:00:00' and changeitem.FIELD in ('status','Project','resolution','Fix Version') order by changegroup.CREATED desc (ORA-01861: literal does not match format string)
Cause
This is caused by the default format of the Oracle which doesn't match the timestamps in JIRA.
Resolution
You may need to set the correct date format in the oracle database. See Oracle's documentation for information on how to set the time format for Oracle.
Was this helpful?