nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Provisioning of node fails after HF update

kendali

After doing the recommended updates last week our provisioning script from our application will not complete the script with an error in SWIS. Working before the update, so trying to figure out what changed with SW. The error we are seeing in the SWIS logs is:

ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.Invoke SolarWinds.InformationService.Verb.VerbExecutorException: ?Verb Cirrus.ConfigArchive.Execute: Not Found at SolarWinds.InformationService.Core.InformationService.Invoke[T](String entity, String verb, Action'1 setupParameters, Func'2 extractReturnValue)

I turned on the debug logs and got the following when I recreated the step that caused the above:

2021-10-25 08:24:33,418 [85] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception for Operation: <root type="array">
<item type="array">
<item type="string">eea284f9-5aea-4052-ab6b-b2f08faaa562</item>
</item>
<item type="string">system set host-name "Switch-host-name"
port set port 2 desc "port-2-description"
snmp set location "switch-address"
vlan remove vlan 1 port 2
config save</item>
<item type="string">portal</item>
</root>
2021-10-25 08:24:33,418 [85] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.Invoke
SolarWinds.InformationService.Verb.VerbExecutorException: Verb Cirrus.ConfigArchive.Execute: Not found
at SolarWinds.InformationService.Core.InformationService.Invoke[T](String entity, String verb, Action`1 setupParameters, Func`2 extractReturnValue)

Any suggestions on what to pursue with fixing on application side? I'm not even sure where to start with what the error is telling me.

Edited to add the debug log

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

There was a fix made necessary by HF2. Not sure if this would affect you because I don't know how your automation scripts work, but it may be worth moving up to the newer SDK/PowerShell Module.

kendali

I wasn't seeing that error anywhere, so wasn't thinking it was related. I'll show this to applications and see if they can expand on it.

KMSigma.SWI

Ah - I think I might be seeing it. The Execute verb was deprecated and you should use the ExecuteScript, ExecuteScriptOnNodes, or ExecuteScriptePerNode verbs instead.

kendali

Ah... we try to look through release notes for these kinds of notices, and could have missed it. Any idea when it was deprecated?

rachaeln

This was the issue - thanks! However, now we have run into a second issue. Looks like our code uses TransferQueue. Has this also been deprecated (did not see it in SWQL Studio)? If so, what is the proper replacement? Included our C# code below as well.

SW Error Log message

2021-11-03 09:54:43,089 [26] INFO SolarWinds.Data.Providers.NCM.Invokers.ConfigArchiveInvoker - (null) (null) ExecuteScript calling engine proxy for EngineID: 3 NodesCount: 1
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception running query:
SELECT T.Status, T.Error, T.Log FROM Cirrus.TransferQueue T WHERE T.TransferID=@transferId
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception for Operation: <root type="object">
<query type="string">SELECT T.Status, T.Error, T.Log FROM Cirrus.TransferQueue T WHERE T.TransferID=@transferId</query>
<parameters type="object">
    <transferId type="string">{fef98684-8032-4841-9a6c-2179cbfb6c4e}:portal:ExecuteScript</transferId>
</parameters>
</root>
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.RunQuery
SolarWinds.Data.Query.EntityNotFoundException: Source entity [Cirrus.TransferQueue] not found in catalog
   at SolarWinds.Data.Query.Processor.SemanticChecker.HandleSourceEntityExpression(SourceExpression sourceExpression)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(SourceExpression sourceExpression)
   at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(FromClause from)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(SelectStatement statement)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Process(SelectStatement statement, PreProcessorState state, String replaceStatementTagWith)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Process(SelectStatement statement, PreProcessorState state)
   at SolarWinds.Data.Query.Processor.PreProcessor.Process(SelectStatement selectStatement, PreProcessorState& preProcessorState)
   at SolarWinds.Data.Query.Engine.QueryProcessor.CompileQueryExecutionPlan(String query, IQueryExecutionContext context)
   at SolarWinds.InformationService.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)
   at SolarWinds.InformationService.Core.InformationService.GetQueryExecutionPlan(String query, IIdentity currentIdentity, Boolean federationEnabled, IQueryExecutionContext queryExecutionContext)
   at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer, IMessageFormatterStrategy messageFormatterStrategy)

Our C# code - only replaced the line with Execute to ExecuteScript

        public string Execute(string nodeId, string script)
        {
            script = script.Trim('\r', '\n', ' ', '\t');

            Logger.Info("Executing on nodeId " + nodeId + ": " + script);

            string nodeGuid = GetNodeGuidForNodeId(nodeId);
            Guid[] nodeIdList =
            {
                new Guid(nodeGuid)
            };

            string transferId = @{ + nodeGuid + @}: + _UserName + ":ExecuteScript";
            // PBI 1575 - thwack.solarwinds.com/.../provisioning-of-node-fails-after-hf-update
            Invoke("Cirrus.ConfigArchive", "ExecuteScript", nodeIdList, script);

            bool done = false;
            string log = "";

            while (!done)
            {
                Thread.Sleep(1000);

                Dictionary<string, object> result =
                    ReadQueryFirst(
                        "SELECT T.Status, T.Error, T.Log FROM Cirrus.TransferQueue T WHERE T.TransferID=@transferId",
                        new {transferId});

                string status = result["Status"] as string;
                bool error = (bool) result["Error"];
                log = result["Log"] as string ?? "<empty log>";

                if (error || status == "Error" || log.ToLower().Contains("failure"))
                {
                    var message = "Error in executing script." +
                                  " \n status:" + status +
                                  ",\n nodeId:" + nodeId +
                                  ",\n script: " + script +
                                  ",\n log: " + result["Log"];
                    Logger.Error(message);
                    throw new WebException(message);
                }
                else if (status == "Complete")
                {
                    done = true;
                    Logger.Info("Successful execution of script: " + script + " Message was: " + log);
                }
                else if (status != "Transferring" && status != "Waiting")
                {
                    done = true;
                    Logger.Warn("Unhandled condition in reading from transfer queue. {0} {1}", argument1: status,
                        argument2: log);
                }
            }

            return log;
        }

rachaeln

Ah the deprecation issue fixed it - Thanks! Now we have a second issue (error posted below). Tried to post our C# that calls all this but the mods nuked it. What can be used in place of TransferQueue if it has been deprecated as well?

2021-11-03 09:54:43,089 [26] INFO SolarWinds.Data.Providers.NCM.Invokers.ConfigArchiveInvoker - (null) (null) ExecuteScript calling engine proxy for EngineID: 3 NodesCount: 1
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception running query:
SELECT T.Status, T.Error, T.Log FROM Cirrus.TransferQueue T WHERE T.TransferID=@transferId
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception for Operation: <root type="object">
<query type="string">SELECT T.Status, T.Error, T.Log FROM Cirrus.TransferQueue T WHERE T.TransferID=@transferId</query>
<parameters type="object">
    <transferId type="string">{fef98684-8032-4841-9a6c-2179cbfb6c4e}:portal:ExecuteScript</transferId>
</parameters>
</root>
2021-11-03 09:54:44,558 [54] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.RunQuery
SolarWinds.Data.Query.EntityNotFoundException: Source entity [Cirrus.TransferQueue] not found in catalog
   at SolarWinds.Data.Query.Processor.SemanticChecker.HandleSourceEntityExpression(SourceExpression sourceExpression)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(SourceExpression sourceExpression)
   at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(FromClause from)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(SelectStatement statement)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Process(SelectStatement statement, PreProcessorState state, String replaceStatementTagWith)
   at SolarWinds.Data.Query.Processor.SemanticChecker.Process(SelectStatement statement, PreProcessorState state)
   at SolarWinds.Data.Query.Processor.PreProcessor.Process(SelectStatement selectStatement, PreProcessorState& preProcessorState)
   at SolarWinds.Data.Query.Engine.QueryProcessor.CompileQueryExecutionPlan(String query, IQueryExecutionContext context)
   at SolarWinds.InformationService.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)
   at SolarWinds.InformationService.Core.InformationService.GetQueryExecutionPlan(String query, IIdentity currentIdentity, Boolean federationEnabled, IQueryExecutionContext queryExecutionContext)
   at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer, IMessageFormatterStrategy messageFormatterStrategy)