topic Failed to prepare user read acl cache in Nuxeo Forum https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318088#M5089 <P>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</P> <P>Failed to prepare user read acl cache</P> <P>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</P> Tue, 31 May 2022 19:29:37 GMT chouinard_ 2022-05-31T19:29:37Z Failed to prepare user read acl cache https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318088#M5089 <P>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</P> <P>Failed to prepare user read acl cache</P> <P>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</P> Tue, 31 May 2022 19:29:37 GMT https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318088#M5089 chouinard_ 2022-05-31T19:29:37Z Re: Failed to prepare user read acl cache https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318089#M5090 <P>Are you using PostgreSQL 9.6 or 11? (https</P> Wed, 01 Jun 2022 08:26:19 GMT https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318089#M5090 Gregory_Carlin 2022-06-01T08:26:19Z Re: Failed to prepare user read acl cache https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318090#M5091 <P>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 ?</P> Wed, 01 Jun 2022 11:33:06 GMT https://connect.hyland.com/t5/nuxeo-forum/failed-to-prepare-user-read-acl-cache/m-p/318090#M5091 chouinard_ 2022-06-01T11:33:06Z