Error: Transaction (Process ID 78) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

In: 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetPostsByTerm(Int32 moduleId, Int32 blogID, String displayLocale, Int32 userId, Boolean userIsAdmin, Int32 termID, Int32 published, String limitToLocale, DateTime endDate, Int32 authorUserId, Int32 pageIndex, Int32 pageSize, String orderBy) at DotNetNuke.Modules.Blog.Entities.Posts.PostsController.GetPostsByTerm(Int32 moduleId, Int32 blogID, String displayLocale, Int32 termId, Int32 published, String limitToLocale, DateTime endDate, Int32 authorUserId, Int32 pageIndex, Int32 pageSize, String orderBy, Int32& totalRecords, Int32 userId, Boolean userIsAdmin) at DotNetNuke.Modules.Blog.Blog.EnsurePostList(Int32 pageSize) at DotNetNuke.Modules.Blog.Blog.vtContents_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) at DotNetNuke.Modules.Blog.Templating.ViewTemplate.Template_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) at DotNetNuke.Modules.Blog.Templating.Template.Template_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) at DotNetNuke.Modules.Blog.Templating.Template.ReplaceSubtemplates(Match m) at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator) at System.Text.RegularExpressions.Regex.Replace(String input, String pattern, MatchEvaluator evaluator) at DotNetNuke.Modules.Blog.Templating.Template.ReplaceContents()