Cannot add/edit node: ProvideFault failed, check fault information

Overview

This article provides resolution to issues in adding and editing nodes after upgrading from NPM 12.0 to NPM 12.0.1.

Description: When Editing a Node, Orion Web Console gives out an error. In Manage Nodes> Add Node customer gets the same error.

For some reason, Configuration Wizard was using SQL script from Agent Management 1.4 instead of 1.5. This probably leads to inconsistent packaging data so CW was picking part of files from new Agent Management package and part from old one.

Environment

• NPM 12.0.1 and Later
• SAM 6.3 and Later

Resolution

Check OrionWeb.log for one of the following errors:

ERROR Orion_Nodes_Controls_AgentInfo - (null)  System.ServiceModel.FaultException`1[SolarWinds.Orion.Core.Common.CoreFaultContract]: ProvideFault failed, check fault information. (Fault Detail is equal to SolarWinds.Orion.Core.Common.CoreFaultContract(Unknown): System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information.

Invalid column name 'OSType'.

Invalid column name 'OSDistro'. (Fault Detail is equal to InfoServiceFaultContract [ System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'OSType'.

Invalid column name 'OSDistro'.

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.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataRe...).

ERROR Orion_Nodes_Controls_AgentInfo - (null)  System.ServiceModel.FaultException`1[SolarWinds.Orion.Core.Common.CoreFaultContract]: ProvideFault failed, check fault information. (Fault Detail is equal to SolarWinds.Orion.Core.Common.CoreFaultContract(Unknown): System.ServiceModel.CommunicationException: Could not connect to net.tcp://localhost:17777/SolarWinds/InformationService/v3/Orion/certificate. The connection attempt lasted for a time span of 00:00:00. TCP error code 10013: An attempt was made to access a socket in a way forbidden by its access permissions 127.0.0.1:17777.  ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions 127.0.0.1:17777

To make sure that everything is consistent, try the following:

1. Go to c:\Program Files (x86)\SolarWinds\Orion\Packaging\Active\ and delete everything inside (there are two folders and one file).
2. Run Configuration Wizard and select all 3 checkboxes - Website, Services, and Database.
3. This should restore packaging state from scratch and put it to a consistent state for future upgrades.