Barracuda Icon
Chat
Live Chat

Hi, I'm Rosa.
How may I help you?

How may I help you?

Click below to send us a Message

Support

Ein globales Supportnetzwerk aus Experten. Zu Ihrer Verfügung.

Zurück zur Knowledgebase

ArchiveOne connection failure error on the Archive Search website

Solution #00007762
Scope:ArchiveOne, v7 or later
Answer:

SYMPTOMS

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)

ROOT CAUSE

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.

RESOLUTION

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: http://www.barracuda.com/kb?id=50160000000SvuX