Select to view content in your preferred language

After server upgrade Guid field query is now case-sensitive

154
0
03-05-2025 04:33 PM
FredSpataro
Frequent Contributor

Hi, 

I just update an ArcGIS server to 11.1 and now my queries against an feature service layer attribute with type = esriFieldTypeGUID are now failing.  I tracked it down to lowercase vs uppercase ie:

MyGUIDId = '{69bdd230-fac0-4753-4e3c-08d5903ee357}' fails

MyGUIDId = '{69BDD230-FAC0-4753-4E3C-08D5903EE357}' works

I was thinking this might just be an 11. 'feature' and was about to change all my code but I tried a similar query on a different 11.1 server with a guid column and the lowercase version works.  So maybe it was just a setting I accidently bumped in the server or in pro for the new publishing workflow?  

Also the lowercase version works fine against the same service currently published to AGOL (we hot swap between locations depending on various system states (live vs cache) and workflows. 

If you have any thoughts on how to get it back to working on lowercase, you'll save me from doing a .ToUpper() everywhere in my code.

 

Thanks! 

 

0 Kudos
0 Replies