Error while acquiring ItemMetalogix app lock can be observed in the Metalogix core log.
Example:
2025-09-18 08:50:16Z|13840|ServerName|128| WARN| RetryableTransferFromStaging|Error during transfering items from staging table to permanent table. Retrying! Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
Error while acquiring ItemMetalogix app lock.
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& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at QUADROtech.Common.Database.DatabaseHelpers.ExecuteNonQuery(SqlConnection connection, String sql, IList`1 parameters, Int32 timeoutSeconds)
at ArchiveShuttle.Core.Library.Metalogix.MetalogixCollectedItem.TransferFromStagingToPermanentTables(SqlConnection itemConnection, String tableName)
at ArchiveShuttle.Core.Library.Metalogix.MetalogixCollectedItem.RetryableTransferFromStaging(SqlConnection itemConnection, String stagingTableName)
Metalogix Archive Parallelism and Metalogix Item Parallelism were set too high. Setting high parallelism in Archive Shuttle Metalogix module screen can have performance risks.
Performance has significantly improved, after the Metalogix archive and item parallelism (thread count) was reduced from 20/10 to 5/5.
The default settings for Metalogix Archive Parallelism is 5 and for Metalogix Item Parallelism is also 5.
