BUG #7917: Error while migrating data

The following bug has been logged on the website:

Bug reference:      7917
Logged by:          Renjith
Email address:      renjith.pt@galfar.com
PostgreSQL version: 9.1.0
Operating system:   Centos
Description:        =


I using one application alfresco with postgresql 9.1. it throws error once
data is migrated from another postgresql 9.1 database. kindly suggest your
solution. =


log details

[org.springframework.extensions.webscripts.AbstractRuntime] Exception from
executeScript - redirecting to status template error: SqlMapClient
operation; SQL [];   =

--- The error occurred in
alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml.  =

--- The error occurred while applying a parameter map.  =

--- Check the alfresco.avm.parameter_IdPatternMap.  =

--- Check the statement (query failed).  =

--- Cause: org.postgresql.util.PSQLException: ERROR: invalid escape string
  Hint: Escape string must be empty or one character.; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:   =

--- The error occurred in
alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml.  =

--- The error occurred while applying a parameter map.  =

--- Check the alfresco.avm.parameter_IdPatternMap.  =

--- Check the statement (query failed).  =

--- Cause: org.postgresql.util.PSQLException: ERROR: invalid escape string
  Hint: Escape string must be empty or one character.