AnsweredAssumed Answered

Error after enable Audit and open site dashboard

Question asked by bbiais on Jun 29, 2015
Hello,

I need to enable Auditing on Alfresco.

I managed to enable auditing on my dev environment, editing alfresco-global.properties file.

But sadly it doesn't work on my production environment.

It's quite the same configuration for both environment: 4.2.e version, PostgreSQL database.

I got the following error message in log:



18:44:24,870 ERROR [org.alfresco.repo.transaction.AlfrescoTransactionSupport] After completion (committed) listener exception:
   listener: org.alfresco.repo.audit.access.AccessAuditor$AccessTransactionListener@27b4c5cf
org.springframework.dao.DataIntegrityViolationException:
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
### The error may involve alfresco.propval.insert.insert_PropertyStringValue-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
; SQL []; ERROR: value too long for type character varying(16); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)



Fulltrace in attached log file.

Alfresco try to insert audit data related to site in database, but I can't identify the problematic table and field.

Can you help me please?

Thanks.

Attachments

Outcomes