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
832 views
Gregory Carlin
Are you using PostgreSQL 9.6 or 11? (https://doc.nuxeo.com/nxdoc/1010/postgresql/)
06/01/2022
chouinard
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