cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to prepare user read acl cache

chouinard_
Champ on-the-rise
Champ on-the-rise

After migrate to Nuxeo Platform 10.10, we get the following exception. Seems like the database function is not adapted to the code. Using PostgreSQL. Anyone know what I am missing? Thanks

Failed to prepare user read acl cache

PSQLException: ERROR: column "users" is of type nx_string_table but expression is of type character varying[] Hint: You will need to rewrite or cast the expression. Where: PL/pgSQL function nx_prepare_user_read_acls(character varying[]) line 11 at SQL statement

2 REPLIES 2

Gregory_Carlin
Elite Collaborator
Elite Collaborator

Are you using PostgreSQL 9.6 or 11? (https

chouinard_
Champ on-the-rise
Champ on-the-rise

No, in fact I'm using PostgreSQL 10.4... though specs says from 9.6 to 11.... Is there a way to adapt Nuxeo 10.10 to use PostgreSQL 10.4 ?

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.