Jump to content


Photo

Starting Migration to Cloud Archive but getting errors

ArchiveOne Migration Database Error

This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#1 Mayson Morrissey

Mayson Morrissey
  • Members
  • 1 posts

Posted 20 April 2020 - 01:23 PM

I am hoping there are still some people around that have used ArchiveOne that could help me though this might simply be a database connection error that someone with more DB experience than me can help with. 

 

I have purchased Barracuda Cloud Archiving and am trying to migrate our ArchiveOne data there so that I can be off the ArchiveOne platform since it is beyond end of life. My installation has been a bit "flakey" anyway but when I run the Migration tool on our smallest repository, which is the 2020 journal repository it errors after about 45 seconds. Below is the anonymized log file from the most recent job. It seems to be a DB connection error and I confirmed our ArchiveOne service had read/write access into the database in case that was the issue but it did not help. 

 

Any assistance would be wonderful.

 

2020-04-20 11:02:56.7733   4: Migrate thread uses the following configuration for search and migration: Migration action 'Migration, Stubbing_None' 
2020-04-20 11:02:56.7733   4:     Repositories 'Journal 2020', Search expired items '1', Search deleted items '1' 
2020-04-20 11:02:56.7733   4:     BMA Connection type 'Cloud', server '{##############}', port '443', user '##########@covingtonwa.gov' 
2020-04-20 11:02:57.6328  11: ClearStaleRepositories deleted 'TempReposForMigration_###########################' 
2020-04-20 11:02:57.6484  11: Loading previous repository counts: 
2020-04-20 11:02:57.6484  11:  journal 2020:28521 
2020-04-20 11:02:57.7109  11: Opening connection to Migration database 
2020-04-20 11:02:57.7265  11:    Using connection string System.Data.SqlClient.SqlConnection 
2020-04-20 11:02:57.8047  11:    Connected to database 
2020-04-20 11:02:57.8828  11:    Restarting from Journal 2020 
2020-04-20 11:02:57.8828  11: Total migration estimate has been updated to 28521 
2020-04-20 11:02:57.8984  11: Starting searching into repository 'Journal 2020' 
2020-04-20 11:03:00.2584  11: Created temporary repository 'TempReposForMigration_#####################' and temp index directory 'D:\Repositories\Journal 2020\Index\TempForMigration_###########################' 
2020-04-20 11:03:00.2584  11:    Creating a temporary repository to run the search against 
2020-04-20 11:03:00.2584  11: Restarting processing for repository 'Journal 2020' from partition '1\COV-ARCHIVEONE_J#########=5_0000.a1i' 
2020-04-20 11:03:00.3521  11: Starting search in repository 'Journal 2020' and partition file '1\COV-ARCHIVEONE_J#########=5_0000.a1i' which is 1 of 11 
2020-04-20 11:03:01.6179  11:    Creating search BMAMigrationSearch 
2020-04-20 11:03:02.7587  11:    Running search BMAMigrationSearch 
2020-04-20 11:03:20.1043  11:    Initial count of search results is 2906 
2020-04-20 11:03:25.8706  11: MigrateBMAThread search got an initial estimate (no filtering) of 2906 items in repository 'Journal 2020' partition '1\COV-ARCHIVEONE_J############=5_0000.a1i' 
2020-04-20 11:03:30.3721  15: Stop requested 
2020-04-20 11:03:33.2340  11: Completed searching into repository 'Journal 2020' 
2020-04-20 11:03:33.7028  11: Opening DB connection to read stub count 
2020-04-20 11:03:33.7184  11: NumberAvailableToStub executing SQL 'SELECT Count(*) FROM BMAMigration WHERE State = 'ReadyToStub'' 
2020-04-20 11:03:33.7184  11: NumberAvailableToStub Invalid object name 'BMAMigration'.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at MigrateBMAService.MigrateBMAServiceCalls.NumberAvailableToStub(SqlConnection con)