'Incorrect syntax near the keyword DEFAULT Error is Thrown When Moving or Cloning Issues
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 attempting to clone or move issues (or in some cases when creating issues), the process fails with the following exception being thrown and appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2011-09-21 15:59:17,831 http-8080-3 ERROR [500ErrorPage.jsp] Exception caught in 500 page java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'.
net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'.
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:46)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39)
at com.atlassian.activeobjects.internal.RegistryBasedActiveObjectsProvider.get(RegistryBasedActiveObjectsProvider.java:29)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.getDelegate(DelegatingActiveObjects.java:126)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:111)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
.....
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'.
Diagnosis
The problem will only occurs when the following environment conditions are met:
Run on JIRA 4.4.x
Update the GreenHopper plugin to 5.7.2
JIRA is connected to MSSQL database
Resolution
As a temporary workaround to fix the problem, you may downgrade your GreenHopper back to 5.7.1, and wait for GreenHopper 5.7.3 whereby the bug is set to be fixed. To downgrade GreenHopper, you may perform the following steps:
Download GH 5.7.1 .jar file here
Shut down JIRA
Move GH 5.7.1 .jar file to $JIRA_HOME\plugins\installed-plugins directory
Remove the existing GH 5.7.2 from the directory
Restart JIRA
For more information, kindly refer to the following related bug reports:
Was this helpful?