11 Replies Latest reply on Dec 3, 2012 11:11 AM by tdanner

    How to connect with SWQL Studio from SDK 1.5 ?

    deathunt

      I try to connect to the SWISS using the connect SWQL Studio from SDK 1.5

      I use the same username and password than the one for "Orion web console".

      I use Server Type: "Orion (v3) over HTTPS"

       

      When I connect, I click on the '+' to expand the database tree and then it crash !

      I just wait 20 second and it crash...

      SWQLcnxErr.jpeg

        • Re: How to connect with SWQL Studio from SDK 1.5 ?
          Jan Pelousek

          Hi deathunt,

          could you, please provide more information which product are you trying to connect to? I see you are using connection to SWIS v3. So the question is if the Orion you are connecting to has really installed SWIS v3 (e.g. NPM 10.3 +). If you connect via SWIS v2 is it working correctly?

            • Re: How to connect with SWQL Studio from SDK 1.5 ?
              deathunt

              I got the SDK install on a VM.

              Solarwinds software is install on a server (x.x.x.130)

              Solarwinds database is install on another server (x.x.x.136)

               

              To use the WSQL Studio app (SDK 1.5) and connect to SWISS.

               

              I am curently connecting trough "ServerName (v2) over HTTP" or "ServerName (v3) over HTTP". I click on the '+' to expand the database tree and it crash (after a few seconds) !

               

               

              I supose that swiss running fine:

              SolardWinds.InformationsServiceServiceV3.exe *32

              taskManager.JPG

                • Re: How to connect with SWQL Studio from SDK 1.5 ?
                  tdanner

                  C:\ProgramData\Solarwinds\Logs\SwqlStudio.log should tell us why it is crashing. Could you attach it to a message in this thread?

                   

                  Also, what version of NPM are you using?

                  1 of 1 people found this helpful
                    • Re: How to connect with SWQL Studio from SDK 1.5 ?
                      deathunt

                      Orion Core 2012.1.1

                      SAM 5.0.1

                      IPAM 3.0

                      NPM 10.3.1

                      IVIM 1.3.0

                      © 1995-2012 All Rights Reserved

                       

                      I checked out those path:

                      VM:

                      C:\Program Files\SolarWinds\Orion SDK\SWQL Studio

                      No SwqlStudio.log

                       

                      App Server:

                      C:\ProgramData\Solarwinds\Logs\

                      No "SWQL Studio" folder or log

                       

                      After checking up, I do nothing and , it crash after 20 second.

                        • Re: How to connect with SWQL Studio from SDK 1.5 ?
                          tdanner

                          Could you look in C:\ProgramData\Solarwinds\Logs\ on the VM?

                            • Re: How to connect with SWQL Studio from SDK 1.5 ?
                              deathunt

                              I checked out already.

                              I run a search with "SWQ*.log" and I found nothing

                                • Re: How to connect with SWQL Studio from SDK 1.5 ?
                                  tdanner

                                  It occurs to me that the ProgramData directory is only writable by admins. Are you running SWQL Studio as an admin?

                                  1 of 1 people found this helpful
                                    • Re: How to connect with SWQL Studio from SDK 1.5 ?
                                      deathunt

                                      No, I'm not admin on my machine*

                                      I'm probably just an user.

                                       

                                      Asking a team mate to test this out .....

                                      • Re: How to connect with SWQL Studio from SDK 1.5 ?
                                        deathunt

                                        Hurray.  The log was hidding in:

                                        C:\Documents and Settings\All Users\Application Data\SolarWinds\Logs

                                        2012-11-30 15:52:23,703 [5] INFO  SwqlStudio.MainForm - Opening subscriber endpoint at net.tcp://localhost:17777/SolarWinds/SwqlStudio/2364/Subscriber

                                        2012-11-30 15:52:26,938 [5] ERROR SwqlStudio.MainForm - Exception opening subscriber host with address net.tcp://localhost:17777/SolarWinds/SwqlStudio/2364/Subscriber.

                                        System.ServiceModel.CommunicationException: TransportManager n’a pas pu écouter sur l’URI fourni en utilisant le service NetTcpPortSharing : impossible de démarrer le service car il est désactivé. Un administrateur peut l’activer en exécutant « sc.exe config NetTcpPortSharing start= demand ».. ---> System.InvalidOperationException: Impossible de démarrer le service NetTcpPortSharing sur l'ordinateur '.'. ---> System.ComponentModel.Win32Exception: Le service ne peut pas être démarré parce qu'il est désactivé ou qu'aucun périphérique activé ne lui est associé

                                           --- Fin de la trace de la pile d'exception interne ---

                                           à System.ServiceProcess.ServiceController.Start(String[] args)

                                           à System.ServiceProcess.ServiceController.Start()

                                           à System.ServiceModel.Channels.SharedConnectionListener.SharedListenerProxy.HandleServiceStart(Boolean isReconnecting)

                                           --- Fin de la trace de la pile d'exception interne ---

                                           à System.ServiceModel.Channels.SharedConnectionListener.SharedListenerProxy.HandleServiceStart(Boolean isReconnecting)

                                           à System.ServiceModel.Channels.SharedConnectionListener.SharedListenerProxy.Open(Boolean isReconnecting)

                                           à System.ServiceModel.Channels.SharedConnectionListener.StartListen(Boolean isReconnecting)

                                           à System.ServiceModel.Channels.SharedConnectionListener..ctor(BaseUriWithWildcard baseAddress, Int32 queueId, Guid token, OnDuplicatedViaDelegate onDuplicatedViaCallback)

                                           à System.ServiceModel.Channels.SharedTcpTransportManager.OnOpenInternal(Int32 queueId, Guid token)

                                           à System.ServiceModel.Channels.SharedTcpTransportManager.OnOpen()

                                           à System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener)

                                           à System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback)

                                           à System.ServiceModel.Channels.TransportChannelListener.OnOpen(TimeSpan timeout)

                                           à System.ServiceModel.Channels.ConnectionOrientedTransportChannelListener.OnOpen(TimeSpan timeout)

                                           à System.ServiceModel.Channels.TcpChannelListener`2.OnOpen(TimeSpan timeout)

                                           à System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

                                           à System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)

                                           à System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

                                           à System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)

                                           à System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

                                           à System.ServiceModel.Channels.CommunicationObject.Open()

                                           à SwqlStudio.MainForm.OpenSubscriber(Object unused)

                                        2012-11-30 15:54:21,110 [1] DEBUG SolarWinds.InformationService.Contract2.InfoServiceProxy - Creating channel factory for Information Service @

                                        2012-11-30 15:54:22,266 [5] DEBUG SolarWinds.InformationService.Contract2.InfoServiceProxy - Creating channel factory for Information Service @ https://x.x.x.130:17778/SolarWinds/InformationService/v3/OrionBasic

                                        2012-11-30 15:54:22,282 [5] DEBUG SolarWinds.InformationService.Contract2.InfoServiceProxy - Query: SELECT Entity.FullName, Entity.BaseType, (Entity.Type ISA 'System.Indication') AS IsIndication,

                                            Entity.Properties.Name, Entity.Properties.Type, Entity.Properties.IsNavigable, Entity.Properties.IsInherited, Entity.Properties.IsKey,

                                            Entity.Verbs.EntityName, Entity.Verbs.Name

                                        FROM Metadata.Entity RETURN XML AUTO

                                        2012-11-30 15:54:43,501 [5] ERROR SolarWinds.InformationService.Contract2.InfoServiceProxy - Error executing query: System.ServiceModel.EndpointNotFoundException: Connexion à https://x.x.x.130:17778/SolarWinds/InformationService/v3/OrionBasic impossible. Code d’erreur TCP 10060 : Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu x.x.x.130:17778.  ---> System.Net.WebException: Impossible de se connecter au serveur distant ---> System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu x.x.x.130:17778

                                           à System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

                                           à System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)

                                           à System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

                                           --- Fin de la trace de la pile d'exception interne ---

                                           à System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)

                                           à System.Net.HttpWebRequest.GetRequestStream()

                                           à System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()

                                           --- Fin de la trace de la pile d'exception interne ---

                                        Server stack trace:

                                           à System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()

                                           à System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout)

                                           à System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

                                           à System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)

                                           à System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

                                           à System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

                                        Exception rethrown at [0]:

                                           à System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

                                           à System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

                                           à SolarWinds.InformationService.Contract2.IInformationService.Query(QueryXmlRequest query)

                                           à SolarWinds.InformationService.Contract2.InfoServiceProxy.Query(QueryXmlRequest query)

                                        SELECT Entity.FullName, Entity.BaseType, (Entity.Type ISA 'System.Indication') AS IsIndication,

                                            Entity.Properties.Name, Entity.Properties.Type, Entity.Properties.IsNavigable, Entity.Properties.IsInherited, Entity.Properties.IsKey,

                                            Entity.Verbs.EntityName, Entity.Verbs.Name

                                        FROM Metadata.Entity RETURN XML AUTO

                                        2012-11-30 15:54:43,595 [5] ERROR SwqlStudio.Program - Unhandled exception

                                        System.ServiceModel.EndpointNotFoundException: Connexion à https://x.x.x.130:17778/SolarWinds/InformationService/v3/OrionBasic impossible. Code d’erreur TCP 10060 : Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu x.x.x.130:17778.  ---> System.Net.WebException: Impossible de se connecter au serveur distant ---> System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu x.x.x.130:17778

                                           à System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

                                           à System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)

                                           à System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

                                           --- Fin de la trace de la pile d'exception interne ---

                                           à System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)

                                           à System.Net.HttpWebRequest.GetRequestStream()

                                           à System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()

                                           --- Fin de la trace de la pile d'exception interne ---

                                        Server stack trace:

                                           à System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()

                                           à System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout)

                                           à System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)

                                           à System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

                                           à System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)

                                           à System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

                                           à System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

                                        Exception rethrown at [0]:

                                           à System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

                                           à System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

                                           à SolarWinds.InformationService.Contract2.IInformationService.Query(QueryXmlRequest query)

                                           à SolarWinds.InformationService.Contract2.InfoServiceProxy.Query(QueryXmlRequest query)

                                           à SolarWinds.InformationService.Contract2.InformationServiceQuery.Execute(Boolean hierarchical)

                                           à SolarWinds.InformationService.Contract2.InformationServiceQuery`1.<GetEnumerator>d__0.MoveNext()

                                           à SwqlStudio.ConnectionInfo.<Query>d__0`1.MoveNext()

                                           à System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)

                                           à System.Linq.Enumerable.ToDictionary[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)

                                           à SwqlStudio.SwisMetaDataProvider.Refresh()

                                           à SwqlStudio.ObjectExplorer.<>c__DisplayClass10.<RefreshServer>b__b(Object o)

                                           à System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)

                                           à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

                                           à System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)

                                           à System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

                          • Re: How to connect with SWQL Studio from SDK 1.5 ?
                            RichardLetts

                            have you allowed access to port 17777/17778 through the firewall on the server?