Could not create Queries from additional console

Version 4

    Versions Effected: LDMS 9.0 SP3 and newer

     

    Problem:

    In the additional console. If a user creates and saves a query the query isn't there. If you look in the console.exe.log there is an exception thrown because of NTLM authentication.

     

    09/20/2013 11:09:24 INFO  6472:Main Thread RollingLog : Critical Exception: System.ServiceModel.Security.MessageSecurityException: 
    The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was ''. ---> 
    System.Net.WebException:
    The remote server returned an error: (401) Unauthorized.
       at System.Net.HttpWebRequest.GetResponse()
       at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
       --- End of inner exception stack trace ---
    

     

     

    Before /DuringAfter
    query created.PNGdisappeared.PNG

     

     

    Cause:

    There is a proxy in use which is preventing the connection of the Remote console to the core, and thus the ability to view entries made to the DB via the remote console. The actual information is being written to the DB but you are unable to view them via the GUI

     

    This down to the fact that the console when successfully logged on makes two connections one to the DB and one to the IIS applications on the core server. Now when changes are made on the remote console, they are written to the DB. But because the console has to go through the proxy to access the IIS applications on the core, which request the information from the DB and display it on the console, this fails due to the NTLM error that you have noticed. So it looks like the task you were creating disappears when in fact it hasn't, you just can’t see it due to the proxy.

     

     

    Solution:

    The above case found that if they removed the Proxy settings in the IE, the query creation works fine. But as this can limit the connection to actual internet it is advised that you edit the proxy configuration be it an application or a PAC file to allow an exception for connections from client in the WAN to the core.

     

    Here are some great articles that you can read about proxy configuration, which you can use to help you configure your one to allow the correct communication from the console to the core:

     

     

    Windows 8 – Supporting proxy services with Static Configurations, Web Hosted PAC files and Domain Policy Configured Proxy

    http://blogs.technet.com/b/deploymentguys/archive/2013/05/08/windows-8-supporting-proxy-services-with-static-configurations-web-hosted-pac-files-and-domain-policy-configured-proxy.aspx

     

    Proxy auto-config

    http://en.wikipedia.org/wiki/Proxy_auto-config