FindByUUID API case-sensitive requirements for embedded PostgreSQL database
book
Article ID: 303340
calendar_today
Updated On:
Products
VMware vSphere ESXi
Issue/Introduction
Symptoms: FindByUUID API in MOB(Managed object browser) might return void if the UUID of the VM is searched using a case-characters different from the one stored in the PostgreSQL database.
Environment
VMWare SDK - TAP Program
Cause
PostgreSQL is case sensitive, the application generates the UUIDs in lower case-characters. Therefore, when searched using the FindByUUID API with upper case, the API will return void as the PostgreSQL considers UUID as a sequence of characters and registers the search with upper characters as a new/not existing value. Same applies if the case type is changed from lower to upper and upper to lower.
Resolution
To resolve this issue, always search with FindByUUID API using the same case-character type for the UUID present in the database.