Unable to access Admin>Users tab in CCR. Message displayed: Error in '/npc' Application.Unable to cast object of type 'System.DBNull' to type 'NetQoS.Services.Interfaces.IRole'.

book

Article ID: 36937

calendar_today

Updated On:

Products

CA Capacity Manager CA MICS Resource Management

Issue/Introduction

Issue:

Select  Admin>Users tab in CCR produces the following error:

Server Error in '/npc' Application. Unable to cast object of type 'System.DBNull' to type 'NetQoS.Services.Interfaces.IRole'. 

 

Description:

An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

   

  

<Please see attached file for image>

Capture.PNG1.PNG

 

CAUSE:

Error is generated when the roleID column in the user_definitions table for the MySQL server database is set to an incorrect value. 

  

RESOLUTION:

 1) Open MySQL server in the command prompt, on the CCR server 

mysql db: mysql -P3308 netqosportal 

 

2) Type the below query to display the userID, Name, and  roleID  columns from the user_definitions tables with ;  

select * from user_definitions; 

 

3) Check The roleID for the user you are logged in with when you received the error. The value should be 3. If not, then this value will need to be updated. 

 

4) To update the user_definitions table, set the roleID column = 3 Where userid column = "X' 

Example: update user_definitions set roleid=3 where userid=3; 

 

5) After making the changes, restart IIS

Environment

Release: HYPCMA05900-5.2-Hyperformix-Capacity Manager-Application
Component:

Attachments

1558723590285000036937_sktwi1f5rjvs16wx2.png get_app