{"action":"opened","issue":{"url":"https://api.github.com/repos/bleroy/OrchardImportTest/issues/129","labels_url":"https://api.github.com/repos/bleroy/OrchardImportTest/issues/129/labels{/name}","comments_url":"https://api.github.com/repos/bleroy/OrchardImportTest/issues/129/comments","events_url":"https://api.github.com/repos/bleroy/OrchardImportTest/issues/129/events","html_url":"https://github.com/bleroy/OrchardImportTest/issues/129","id":65782256,"number":129,"title":"Create a new blog post on Orchard configured against SQL Server resulted in SqlException","user":{"login":"bleroy","id":1165609,"avatar_url":"https://avatars.githubusercontent.com/u/1165609?v=3","gravatar_id":"","url":"https://api.github.com/users/bleroy","html_url":"https://github.com/bleroy","followers_url":"https://api.github.com/users/bleroy/followers","following_url":"https://api.github.com/users/bleroy/following{/other_user}","gists_url":"https://api.github.com/users/bleroy/gists{/gist_id}","starred_url":"https://api.github.com/users/bleroy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bleroy/subscriptions","organizations_url":"https://api.github.com/users/bleroy/orgs","repos_url":"https://api.github.com/users/bleroy/repos","events_url":"https://api.github.com/users/bleroy/events{/privacy}","received_events_url":"https://api.github.com/users/bleroy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-01T21:25:27Z","updated_at":"2015-04-01T21:25:27Z","closed_at":null,"body":"REPRO:  \nI configured Orchard against SQL Server (during setup). Then I created a new\nblog, and attempted to add a new post.  \n  \nRESULT:  \nMSDTC on server 'BRADMIWIN7' is unavailable.  \nDescription: An unhandled exception occurred during the execution of the\ncurrent web request. Please review the stack trace for more information about\nthe error and where it originated in the code.  \n  \nException Details: System.Data.SqlClient.SqlException: MSDTC on server\n'BRADMIWIN7' is unavailable.  \n  \nSource Error:  \nLine 157: criteria = criteria.SetMaxResults(count);  \nLine 158: }  \nLine 159: return criteria  \nLine 160: .List<ContentItemVersionRecord>()  \nLine 161: .Select(x => ContentManager.Get(x.Id,\nVersionOptions.VersionRecord(x.Id)))  \n  \nSource File: C:\\OrchardHg\\src\\Orchard\\ContentManagement\\DefaultContentQuery.cs\nLine: 159  \n  \nStack Trace (Trimmed):  \n[SqlException (0x80131904): MSDTC on server 'BRADMIWIN7' is unavailable.]  \nSystem.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean\nbreakConnection) +1951450  \nSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,\nBoolean breakConnection) +4849003  \nSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject\nstateObj) +194  \n  \n==== UPDATE ======  \nOnce I got into this state, pretty much every admin page throws a similar\nexception. I also ran into this one when attempting to access the front-end of\nthe site:  \n  \nThe transaction has aborted.  \nDescription: An unhandled exception occurred during the execution of the\ncurrent web request. Please review the stack trace for more information about\nthe error and where it originated in the code.  \n  \nException Details: System.Transactions.TransactionAbortedException: The\ntransaction has aborted.  \n  \nSource Error:  \nLine 27: if (_scope == null) {  \nLine 28: Logger.Debug(\"Creating transaction on Demand\");  \nLine 29: _scope = new TransactionScope(TransactionScopeOption.Required);  \nLine 30: }  \nLine 31: }  \n  \nSource File: C:\\OrchardHg\\src\\Orchard\\Data\\TransactionManager.cs Line: 29  \n  \nStack Trace (Trimmed):  \n[TransactionAbortedException: The transaction has aborted.]  \nSystem.Transactions.TransactionStateAborted.CreateAbortingClone(InternalTransa\nction tx) +11  \nSystem.Transactions.DependentTransaction..ctor(IsolationLevel isoLevel,\nInternalTransaction internalTransaction, Boolean blocking) +98  \nSystem.Transactions.Transaction.DependentClone(DependentCloneOption\ncloneOption) +143  \nSystem.Transactions.TransactionScope.SetCurrent(Transaction newCurrent) +85  \n\nWork Item Details\n--------------------\n**Original CodePlex Issue:**\t[Issue 16239](http://orchard.codeplex.com/workitem/16239)\n**Status:**\tClosed\n**Reason Closed:**\tUnassigned\n**Assigned to:**\tUnassigned\n**Reported on:**\tFeb 24, 2010 at 5:59 AM\n**Reported by:**\tbradmi\n**Updated on:**\tMar 4, 2010 at 6:38 PM\n**Updated by:**\tsuhacan\n**Closed on:**\tMar 4, 2010 at 6:38 PM\n**Closed by:**\tsuhacan\n**Status:**\tClosed\n**Reason Closed:**\tUnassigned\n**Assigned to:**\tUnassigned\n**Reported on:**\tFeb 24, 2010 at 5:59 AM\n**Reported by:**\tbradmi\n**Updated on:**\tMar 4, 2010 at 6:38 PM\n**Updated by:**\tsuhacan\n**Closed on:**\tMar 4, 2010 at 6:38 PM\n**Closed by:**\tsuhacan\n"}}