1 Reply Latest reply on May 1, 2015 1:48 PM by tdanner

    Help me out here, I have a SWIS error that hits ever 5 minutes and I'm not sure I can make sense of it!

    MagnAxiom

      In the C:\ProgramData\Solarwinds\InformationService\v3.0\Orion.InformationService.txt

       

      2015-05-01 10:04:51,786 [51] ERROR SolarWinds.InformationService.Core.InformationService - SolarWinds.Orion.Core.BusinessLayer.DAL.AlertDAL.LoadSwisUris() 

      Exception for Operation: <s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing">

        <s:Header>

          <a:Action s:mustUnderstand="1">http://schemas.solarwinds.com/2007/08/informationservice/InformationService/QueryXml</a:Action>

          <a:MessageID>urn:uuid:13750ba6-8ae4-4271-a20d-59b996fdfcba</a:MessageID>

          <a:ReplyTo>

            <a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>

          </a:ReplyTo>

          <SwisSettings xmlns="http://schemas.solarwinds.com/2007/08/informationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

            <ApplicationTag>SolarWinds.Orion.Core.BusinessLayer.DAL.AlertDAL.LoadSwisUris() </ApplicationTag>

            <DataProviderTimeout>-PT1S</DataProviderTimeout>

          </SwisSettings>

          <i18n xmlns="http://schemas.solarwinds.com/2007/08/informationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

            <Culture>en-US</Culture>

          </i18n>

          <a:To s:mustUnderstand="1">net.tcp://localhost:17777/SolarWinds/InformationService/v3/Orion/certificate</a:To>

        </s:Header>

        <s:Body>

          <QueryXml xmlns="http://schemas.solarwinds.com/2007/08/informationservice">

            <query>SELECT CustomPollerAssignmentID, Uri FROM Orion.NPM.CustomPollerAssignmentOnNode WHERE CustomPollerAssignmentID = @param_0 OR CustomPollerAssignmentID = @param_1 RETURN XML RAW</query>

            <parameters>

              <item xmlns="http://schemas.solarwinds.com/2007/08/informationservice/propertybag">

                <key>param_0</key>

                <type>System.String</type>

                <value>6165</value>

              </item>

              <item xmlns="http://schemas.solarwinds.com/2007/08/informationservice/propertybag">

                <key>param_1</key>

                <type>System.String</type>

                <value>6165</value>

              </item>

            </parameters>

          </QueryXml>

        </s:Body>

      </s:Envelope>

      2015-05-01 10:04:51,786 [51] ERROR SolarWinds.InformationService.Core.InformationService - SolarWinds.Orion.Core.BusinessLayer.DAL.AlertDAL.LoadSwisUris() 

      Exception caught in method RunQuery

      System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.

         at System.Data.SqlClient.SqlConnection.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.TryHasMoreRows(Boolean& moreRows)

         at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)

         at System.Data.SqlClient.SqlDataReader.Read()

         at SolarWinds.InformationService.DataProviders.SqlQueryRelation.<GetEnumerator>d__0.MoveNext()

         at SolarWinds.Data.Query.PhysicalQueryPlan.ProjectOp.<GetEnumeratorInternal>d__0.MoveNext()

         at SolarWinds.Data.Query.PhysicalQueryPlan.PhysicalQueryPlan.<GetEnumerator>d__0.MoveNext()

         at SolarWinds.InformationService.Serialization.XmlResponseSerializerSimple..ctor(IQueryResultReader reader, Boolean includeQueryPlan)

         at SolarWinds.InformationService.Serialization.XmlSerializer.GetSerializer()

         at SolarWinds.InformationService.Serialization.XmlSerializer.PrepareSerialize(IQueryExpr query, ISchema schema, IQueryResultReader reader)

         at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer)

      ClientConnectionId:14956ab3-482a-4c12-9449-b4679f30346c