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

# sk130773 - PostgreSQL escape character error in server_messages.log of R80.20.M1 Server

| Property | Value |
|----------|-------|
| Solution ID | sk130773 |
| Date Created | 2018-06-28 |
| Last Modified | 2018-10-07 |
| Technical Level | Advanced |
| Products | Endpoint Security |
| Versions | Cloud, E89.X, E88.X, R82.20, R82.10, R82, R81.20 |
| OS | Gaia |

## Symptoms

- * PostgreSQL escape character error in *$UEPMDIR/logs/server_messages.log* of R80.20.M1 Server:

  ```
  
  [DATE TIME] ERROR Dispatcher-Thread-9 - Statement "GetAllFailedOutgoingBatchStatistics" by iBATIS failed, it will be skipped (SyncDaoImpl)
  com.ibatis.common.jdbc.exception.NestedSQLException:
  --- The error occurred in sqlMap/syncMonitor.xml.
  --- The error occurred while applying a parameter map.
  --- Check the GetAllFailedOutgoingBatchStatistics-InlineParameterMap.
  --- Check the statement (query failed).
  --- Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"
    Position: 271
          at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
          at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
          at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:578)
          at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:552)
          at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
          at com.checkpoint.uepm.backend.syncMonitor.dao.SyncDaoImpl.getAllStatistics(SyncDaoImpl.java:42)
          at com.checkpoint.uepm.backend.syncMonitor.commands.GetSyncStatusesCommand.executeSpecificGet(GetSyncStatusesCommand.java:79)
          at com.checkpoint.uepm.backend.is.commands.GetCommand.execute(GetCommand.java:72)
          at com.checkpoint.uepm.backend.is.infrastructure.TransactionManager.executeSingleGetCommandActual(TransactionManager.java:613)
          at com.checkpoint.uepm.backend.is.infrastructure.TransactionManager.executeSingleGetCommand(TransactionManager.java:562)
          at com.checkpoint.uepm.backend.is.infrastructure.BackendIsFacadeAbstract.executeGetCommandActual(BackendIsFacadeAbstract.java:314)
          at com.checkpoint.uepm.backend.is.infrastructure.BackendIsFacadeAbstract.
  ```

* The error repeats many times in *$UEPMDIR/logs/server_messages.log*

## Cause

Escape character for Postgres was changed from "\\" to ' "" '.

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# 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