java.sql.SQLException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
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
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2012-05-21 14:50:37,320 StreamsCompletionService::thread-1 ERROR grkidd 890x8x2 xqut80 137.195.178.34,127.0.0.1 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Error building feed
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Microsoft SQL Server
- version:08.00.2055
- minor version:0
- major version:8
Driver:
- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
- version:1.2.4
java.sql.SQLException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:47)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52)
...
Caused by: java.sql.SQLException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.Cause
The problem is usually caused due to using SQL Server 2000 which is not a supported platform as stated in this documentation
Resolution
Migrate to SQL Server 2008
Was this helpful?