Can't create a new account in NPM 11.5

Question

Hello,

For some users from our AD domain, we can't create a new account.

* We obtain the following error:

* With this result in the web error report:

URL: edcorion:80/.../EditAccount.aspx

Referrer: edcorion:80/.../EditAccount.aspx

Message: Object reference not set to an instance of an object.

ErrorSite: App_Web.Orion_Admin_AccountLimitationEditor.UpdateRow

ErrorType: System.NullReferenceException

* I activated the debug log level mode for the web site, and a found that:

2016-04-25 13:41:53,036 [224] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT * FROM Limitations lim

LEFT JOIN LimitationTypes limType ON limType.LimitationTypeID=lim.LimitationTypeID

LEFT JOIN LimitationTypesMetadata met ON met.LimitationTypeID=limType.LimitationTypeID

WHERE LimitationID=@LimitationID (@LimitationID=336)

2016-04-25 13:41:53,036 [224] DEBUG SolarWinds.Orion.Web.DAL.LimitationDALImplementation - Could not find limitation with id 336.

2016-04-25 13:41:53,036 [224] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: SELECT 1 WHERE EXISTS(SELECT AccountId FROM Accounts WITH (NOLOCK) WHERE AccountId=@accountId) (@accountId=myuser)

2016-04-25 13:41:53,052 [224] ERROR ASP.global_asax - Application_Error(40f097d7beca40ee8ea48fec3015645e)

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)

So if someone have already this issue of know how to resolve it ...

Regards

Cyril

janene16 · Answer

nice

FormerMember · Answer

Thanks for your answer,

I solved the issue,

The user I tried to create was already register in the Accounts table because he was already in an AD group authorized in Orion.

All users of this AD Group was registered in the account table with the LimitationID1 = 336

This limitation ID doesn't exist in our Limitations table ... (I don't know why and how it's possible)

I updated the Accounts table to replace the value 336 by the value 0 in the LimitationID1 field.

Thanks again for your help.

Cyril

janene16 · Answer

Can you check your database and verify if LimitationID 336 is still present? Go to Limitations table and tell us also if there are whereclause value of 1=1

based on your error

Could not find limitation with id 336.