record not found

[karthikdurga]

I am trying to view a record in sys_user_group table in list view to form view. When I click on the group, I get an error 'Record not found". I checked the url and found that the it's redirected to "label.do" instead of "sys_user_group" table for this particular record. Does anyone have knowledge on how to fix this record ?

[shruti_tyagi]

Oh if this group looks good in any other instance and has same sys_id you can export and import it in affected instance. See this is something you want to do.

[karthikdurga]

This group is impacted in all instances.

[shruti_tyagi]

Hmm than its lil tricky, try to see any server side error when you click this link to see whats going on. Enable All logs and look for any error:

http://wiki.servicenow.com/index.php?title=Debugging_Tools_Best_Practices#gsc.tab=0http://wiki.servicenow.com/index.php?title=Debugging_Tools_Best_Practices#gsc.tab=0

[karthikdurga]

Hi All

The issue is resolved by Service now team. These records were corrupt - "sys_class" field for these records should be table name, instead it had label. When we contacted service now team, they said that these can only be fixed from their end and corrected them.

[Melissa Berry]

I had the same issue and was able to run a background script to update the sys_class field. Once I did that, i was able to view the record again. 

var gr= new GlideRecord("sys_user");
var q='user_name=enter the user name on your record';
gr.addEncodedQuery(q);
gr.query();

while (gr.next()) {
gr.setWorkflow(false);
gr.sys_class_name='sys_user';
gr.update();

}