Unable to add or edit an AD account or group in the Orion Web Console

This article describes the issue where you are unable to add or edit a particular AD account or group in the Web Console and it throws the following message:

It also shows the following error log:

2015-07-10 16:33:29,186 [25] ERROR ASP.global_asax - Application_Error(e448188144304ecb8cfd4f034234522b)

System.NullReferenceException: Object reference not set to an instance of an object.

   at Orion_Admin_AccountLimitationEditor.UpdateRow(Limitation limit, PlaceHolder phType, PlaceHolder phDetail)

   at Orion_Admin_AccountLimitationEditor.UpdateControlState()

   at Orion_Admin_Accounts_EditAccount.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

This issue may occur due to the following reasons: 

• The account or group may have been added and deleted.
• The account or group still exists on the database but the limitation assigned to the account no longer exists.

1. From your Orion server, Use Database Manager to view the SolarWinds database . 
2. Click Add default server.
3. Expand your SolarWindsOrion database.
4. Double-click the Accounts table and execute the following query:

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   SELECT accountid, limitationid1, limitationid2, limitationid3 FROM [dbo].[Accounts]
   where accountid = 'PUT THE ACCOUNT OR GROUP THAT CANNOT BE EDITTED HERE'

5.  Double-click the Limitations table and click Execute Query. Notice that there is a limitation assigned to the account or group.
6.  Go back to the Accounts table and click Enable table editing. 
7. Change the LimitationID1 column value from 'X' to 0
8. Click 'EXECUTE QUERY' and verify that you can now add or edit the account or group.