BUG #7917: Error while migrating data

From: renjith(dot)pt(at)galfar(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7917: Error while migrating data
Date: 2013-03-05 06:35:19
Message-ID: E1UClT5-0000Ca-7i@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7917
Logged by: Renjith
Email address: renjith(dot)pt(at)galfar(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Shin-ichi MORITA 2013-03-05 10:56:16 Re: BUG #7914: pg_dump aborts occasionally
Previous Message Euler Taveira 2013-03-05 04:30:03 Re: BUG #7913: TO_CHAR Function & Turkish collate