It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

ArchiveOne connection failure error on the Archive Search website

  • Type: Knowledgebase
  • Date changed: one year ago
Solution #00007762

Scope:ArchiveOne, v7 or later



When logging in to the ArchiveOne Search website, you receive the error:


?ArchiveOne Connection Failure

The website has failed to connect to the SQL database.

The connection string used was:

Data Source=?HOSTNAME\INSTANCE?;Integrated Security=SSPI;Initial Catalog=master;Connect Timeout=30

The exception thrown was:

The thread was aborted.

Please contact your administrator.?


The Data source given in the SQL database connection string is not blank and the SQL instance name is correct. Looking at the AOneSearch.log, you see the following error:

2016-07-06 17:16:48.9376   9:     Master connectionstring is 'Data Source="SERVER01\C2CArchiveOne";Integrated Security=SSPI;Initial Catalog=master;Connect Timeout=30'

2016-07-06 17:16:48.9376   9:     Browse archive connectionstring is 'Data Source="SERVER01\C2CArchiveOne";Integrated Security=SSPI;Initial Catalog=C2CBrowseArchiveFolders;Connect Timeout=30'

2016-07-06 17:16:49.2028   9:           Current database version : '3'

2016-07-06 17:16:49.2028   9:           Upgrading database to version : '4'

2016-07-06 17:16:49.2184   9:           Error:BADatabase threw EXCEPTION: The operation failed because an index or statistics with name 'IX_Stores_ID' already exists on table 'C2CBrowseArchiveFolders.dbo.Stores'.

2016-07-06 17:16:49.2184   9:              SOURCE:.Net SqlClient Data Provider

2016-07-06 17:16:49.2184   9:              METHOD:OnError

2016-07-06 17:16:49.2184   9:              STACK is as follows:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at AOneCombinedSearch.Data.BADatabase.UpgradeDatabase(Int32 PolicyServiceUpgradedTo, Int32 UpgradeToVersion)


When the Archive Search website tries to upgrade the database to the correct version, it fails as an index with the same name already exists.


You should delete the index so that the database upgrade can successfully proceed:

1.       Run SQL Management Studio and connect to the ArchiveOne SQL instance.

Expand the C2CBrowseArchiveFolders database and delete the named index in the error.

E.g. If the error is: 'IX_Stores_ID' already exists on table 'C2CBrowseArchiveFolders.dbo.Stores' expand the Stores table, expand Indexes and right-click the named index and select ?Delete?.

2.       Once the index has been deleted, retest access to the Archive Search website. You may have to delete multiple indexes. The following is a list of the indexes created by the database upgrade; some or all of these indexes may already exist:

a.       On the Stores table:

                                                               i.      IX_Stores_ID

                                                             ii.      IX_Stores_DN

                                                            iii.      IX_Stores_DisplayName

b.      On the Folders table:

                                                               i.      IX_Folders_ID

                                                             ii.      IX_Folders_Store

                                                            iii.      IX_Folders_ParentFolderID

                                                           iv.      IX_Folders_DisplayName

                                                             v.      IX_Folders_Display

c.       On the StoreAccess table:

                                                               i.      IX_StoreAccess_SID

                                                             ii.      IX_StoreAccess_Mailbox

d.      On the Items table:

                                                               i.      IX_Items_ID

                                                             ii.      IX_Items_FolderID

                                                            iii.      IX_Items_ArchiveGUID

                                                           iv.      IX_Items_Display

                                                             v.      IX_Items_Repository


Link to This Page: