topic Customize Dashboard throws PSQLException: ERROR in Alfresco Archive

Customize Dashboard throws PSQLException: ERROR

mohitashah — Fri, 20 Jan 2012 21:51:12 GMT

Greetings,I have installed Alfresco 3.4.5 on my Windows Machine with PostgreSQL as the DB.As soon as my Alfresco Server is up and Running, I go to Alfresco Share and create a Site. Once I have created a new site I click on the 'Customize Dashboard' button on the left hand side corner. Immediately I

Re: Customize Dashboard throws PSQLException: ERROR

mward — Wed, 08 Feb 2012 16:31:44 GMT

Assuming that you are using PostgreSQL 9.1.x - this is fixed ready for 4.0.1. There is also a workaround - to configure PostgreSQL to use the 'old' string handling:

standard_conforming_strings = off

See http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.1#Backward_compatibility_issues

Re: Customize Dashboard throws PSQLException: ERROR

kirit — Mon, 27 Feb 2012 13:17:11 GMT

I did following with my postgreSQL 9.1 , (I am using alfresco enterprise 3.4.6.)
1) login as user postgre
2) set standard_conforming_strings = off

Still I am getting the same issue of not seeing dashlets inside columns (where i suppose to see currently configured dashlets)
And same error is coming in backgournd

ERROR [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.
Caused by: org.postgresql.util.PSQLException: ERROR: invalid escape string
Hint: Escape string must be empty or one character.
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

Please suggest.