cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to prepare user read acl cache

chouinard_
Confirmed Champ
Confirmed Champ

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_
Confirmed Champ
Confirmed Champ

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.