Resolving Internal Server Errors when Using the /get "Devices" Endpoint

The error occurs when attempting to invoke an endpoint in the SOTI Swagger API. In this specific case, the /devices [GET] endpoint was selected.

While the expected response is a "200 - Success," an "Error - response status 500" is returned instead.

Upon reviewing the MS logs, duplicate @Domains errors will be observed, as shown below:

SOTI MobiControl Version 2025.1.0

When calling the /getDevices endpoint via the SOTI Swagger interface, the request fails with an "Internal Server Error" (HTTP 500). This endpoint was previously functioning as expected.

This issue occurs when Android Enterprise environment devices have duplicate email addresses stored in the database with varying letter cases. Although the addresses appear identical, differences in uppercase and lowercase formatting (e.g., email123@soti.net vs. email123@SOTI.NET) cause the stored procedure to fail, resulting in an internal server error.

To resolve this issue, it is recommended to upgrade to one of the following versions of SOTI MobiControl, where the problem has been addressed:

• SOTI MobiControl 2025.1.1

• SOTI MobiControl 2026.0.0

• SOTI MobiControl 2026.1.0

Upgrading to any of these versions will prevent the error caused by duplicate email addresses with case differences.