- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 09:54 AM
What is causing sys_user.country field to only accept United States and not USA in sys_user table country field? It appears to have started with Xanadu Patch 9.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 10:04 AM - edited 07-21-2025 10:06 AM
Hi @Renee-17 ,
we have faced the similar issue
there are two BRs added in the patch (Prevent invalid country code & Prevent invalid language code)
check if those are the once causing the issue
as per that BR (US should be the choice value not USA)
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 02:24 PM
If the query of core_country had this instead, it should work for us since we are using USA and not US for country.
coreCountryGR = new GlideRecord("core_country");
var query = coreCountryGR.addQuery("iso3166_2", country);
query.addOrCondition("iso3166_3", country);
coreCountryGR.query();
if(coreCountryGR.getRowCount() == 0) {
gs.warn("Attempt to insert/update an invalid value for sys_user.country: " + country);
current.setAbortAction(true);
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 03:48 PM
Hi @Renee-17 ,
That's what we had done 😀(deactivated those 2 BRs)
If your issue is resolved
Could you please close this thread by accepting the solution
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya