> Source: [sk163236](https://support.checkpoint.com/results/sk/sk163236)

# sk163236 - Duplicate users or machines in Endpoint Security Server database

| Property | Value |
|----------|-------|
| Solution ID | sk163236 |
| Date Created | 2019-10-22 |
| Last Modified | 2021-02-11 |
| Technical Level | General |
| Products | Endpoint Security |
| Versions | Cloud, E89.X, E88.X, R82.20, R82.10, R82, R81.20 |
| OS | Windows, Gaia |

## Symptoms

- * Duplicate users or machines in Endpoint Security Server database.
* See 'returned too many results' error in *server_messages.log* .


  Caused by: java.sql.SQLException: Error: executeQueryForObject **returned too many results.**
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:108)
  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
  ... 34 more

## Cause

Usually caused by:

* Domain changes
* User being deleted from the domain and readded
* User being moved in the domain and our adscanner not detecting the change (or has not scanned yet)

## Solution

This problem was fixed. The fix is included in:

* **[Security Management Server R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk160736&partition=Basic&product=All)**and up

Check Point recommends to always upgrade to [the most recent version](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk117536&partition=Basic&product=Endpoint).  

Refer to [sk170695](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk170695&partition=Advanced&product=Endpoint) for additional symptoms.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content