New Business Rule on User Table in Yokohama Patch 5

Tim Deniston
Mega Sage
Mega Sage

A new business rule was inserted on the sys_user table with Yokohama Patch 5. The BR is called "Prevent invalid country code" and has a sys_id of 3b638e8338596210f8773223ad5a62dd. This is causing an issue with updating users all of a sudden. If a user has an invalid Country value, all of a sudden no updates can occur on the user until this is corrected. This may be a problem for anyone who has LDAP or Azure AD pushing Country values that don't exactly conform to what ServiceNow is expecting. The Country field has historically been a string field with choices that have inconsistent values (US and USA and United States, for example). Starting with Yokohama Patch 5, these apparently need to all be corrected. 

 

The Yokohama Patch 5 release notes do not mention this new BR but it's sure having a big impact. 

16 REPLIES 16

You should clean up the values on your country core table for country code. This would be the cleanest solution.

Of course, Sujan. You can check the other replies in this thread to see how people have already resolved this challenge.