Some instances see notification devices which have a "type" value of "email", in lower case, which does not exist as one of the sys_choice values for that field.

Steps to Reproduce

  1. Open an instance.
  2. Go to /cmn_notif_device_list.do.
  3. Scroll to where you see type = email.


Have a ServiceNow Customer Support agent run the following script in Scripts - Background to fix the issue. This script may also be run on a schedule to periodically check and fix these values.

var sysids = "";
var gr = new GlideRecord("cmn_notif_device");

  if(gr.type.indexOf("E") < 0) //No capital E found! These are the invalid choices.
   sysids += gr.sys_id + ",";
   //Set the type to the valid choice which is ‘Email’ 
   gr.type = Email;

//Log the results
if (sysids != "")
gs.logError("Invalid lower-cased 'email' types have been found on cmn_notif_device table, and cleaned up via this script.");
} else {
gs.log("No incorrect 'email' types have been found on cmn_notif_device.");


Related Problem: PRB603063

Seen In

Calgary Patch 3 Hot Fix 1
Calgary Patch 5
Dublin EA 8
Dublin Patch 2
Dublin Patch 6
Eureka Patch 5
Eureka Patch 6
Eureka Patch 6 Hot Fix 2
Eureka Patch 7
Eureka Patch 8
Eureka Patch 9 Hot Fix 4
Fuji Patch 3
Eureka Patch 3 Hot Fix 1

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-12-12 13:40:50