After upgrading from System Center Orchestrator 2012 sp1 to 2012 R2, my Runbooks weren\u2019t running via my scheduled tasks. After some digging, I figured out that I couldn\u2019t open the Orchestration Console, because I kept getting this error:<\/p>\n
\nError executing the current operation.
[HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http:\/\/go.microsoft.com\/fwlink\/?linkid=106663&Version=5.1.20913.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer<\/a><\/p>\n<\/blockquote>\nI did some research, but couldn\u2019t figure it out, and there was a particular Runbook that I needed to have run every night. So I opened a ticket with Microsoft. In order to save you the trouble, if you come across this issue, here is the solution:<\/p>\n
\n1. Enable detailed logging for the connection attempt. <\/p>\n
Create a folder to store the log file: C:\\Logs in this sample: <\/p>\n
initializeData="C:\\logs\\SRV_Traces.svclog" \/><\/p>\n
Edit the Web.Config file located in the following default location: <\/p>\n
C:\\Program Files (x86)\\Microsoft System Center 2012 R2\\Orchestrator\\Web Service\\Orchestrator2012<\/p>\n
======================<\/p>\n
Part1 add the following just below section <configuration><\/p>\n
<system.diagnostics><\/p>\n
<sources><\/p>\n
<source name="System.ServiceModel"<\/p>\n
switchValue="Information, ActivityTracing"<\/p>\n
propagateActivity="true" ><\/p>\n
<listeners><\/p>\n
<add name="xml"\/><\/p>\n
<\/listeners><\/p>\n
<\/source><\/p>\n
<source name="System.ServiceModel.MessageLogging"><\/p>\n
<listeners><\/p>\n
<add name="xml"\/><\/p>\n
<\/listeners><\/p>\n
<\/source><\/p>\n
<\/sources><\/p>\n
<sharedListeners><\/p>\n
<add name="xml"<\/p>\n
type="System.Diagnostics.XmlWriterTraceListener"<\/p>\n
initializeData="C:\\logs\\SRV_Traces.svclog" \/><\/p>\n
<\/sharedListeners><\/p>\n
<\/system.diagnostics><\/p>\n
==============<\/p>\n
Part2 added into the section: <system.serviceModel><\/p>\n
<diagnostics wmiProviderEnabled="true"><\/p>\n
<messageLogging<\/p>\n
logEntireMessage="true"<\/p>\n
logMalformedMessages="true"<\/p>\n
logMessagesAtServiceLevel="true"<\/p>\n
logMessagesAtTransportLevel="true"<\/p>\n
maxMessagesToLog="3000"<\/p>\n
\/><\/p>\n
<\/diagnostics><\/p>\n
2. Perform an IISRestart and test connecting to the Orchestration console to generate the error.<\/p>\n
3. Stop the IIS Site and view the resulting log file.<\/p>\n
4. Opening the log file using: SvcTraceViewer.exe make it much easier to parse. <\/p>\n
You can get it either by installing (a non-express version of) Visual Studio, or by installing the (free) Windows SDKs<\/p>\n
(http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=E6E1C3DF-A74F-4207-8586-711EBE331CDC&displaylang=en<\/a>)<\/p>\n
5. Drilling into the XML data for the "Handling an Exception" entry and locating the inner exception we found the following: <\/p>\n
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘GetSecurityToken’, database ‘<SCO DB Name>’, schema ‘Microsoft.SystemCenter.Orchestrator’.<\/p>\n
It appears that in uninstalling\/reinstalling the Web Console the needed permissions were not updated in SQL. <\/p>\n
6. To address this issue we ran a SQL script that was contained in the following MSI<\/p>\n
%localappdata%\\Microsoft System Center 2012\\Orchestrator\\Microsoft.SystemCenter.Orchestrator.ManagementServer.msi"<\/p>\n
From the *.SQL located the file: Microsoft.SystemCenter.Orchestrator.Roles.SQL<\/p>\n
Using the text from this file, we created a new query to run against the Orchestrator database to reapply the permission grant operations. <\/p>\n<\/blockquote>\n
The key was step 6. The security evidently didn\u2019t get setup correctly on the update, and needed to be fixed manually.<\/p>\n","protected":false},"excerpt":{"rendered":"
After upgrading from System Center Orchestrator 2012 sp1 to 2012 R2, my Runbooks weren\u2019t running via my scheduled tasks. After some digging, I figured out that I couldn\u2019t open the Orchestration Console, because I kept getting this error: Error executing the current operation. [HttpWebRequest_WebException_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable. Often the key and… Continue reading Error after upgrading Orchestrator to 2012 R2<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17,21,33],"tags":[43,120,129,176,185],"class_list":["post-321","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-orchestrator","category-system-center","tag-2012-r2","tag-microsoft","tag-orchestrator","tag-system-center","tag-upgrade","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-5b","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=321"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/321\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}