Failed to prepare user read acl cache

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

0 votes

0 answers

335 views

ANSWER

Are you using PostgreSQL 9.6 or 11? (https://doc.nuxeo.com/nxdoc/1010/postgresql/)
06/01/2022

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 ?
06/01/2022