New Domain Controller Causes User Settings Page to Error

Nextcloud version: 22.2.0
Operating system and version: Ubuntu 20.04
Apache 2.4.41 Ubuntu
PHP version: PHP 7.4.3

Database:PostgreSQL 12.9

Issue-
Opening Users->Everyone errors out and is unable to load user list.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Active Directory Domain Controller was updated from Windows Server 2003 to Windows Server 2019
  2. Via OCC command via cli I disabled the active LDAP configuration file “s01”
  3. Logged in via local nextcloud administrator account, reconfigured LDAP configuration to point to new IPv4 of new Domain Controller.
  4. Via cli I enabled the LDAP configuration again.
  5. Tested, was able to successfully login using Active Directory username and password, LDAP gives me creen check box, able to talk to new AD server.
  6. When logged in as any administrator, local or LDAP when I go to Users → Everyone the page errors out and is unable to load the users. If I go to Disabled users same problem. However the “Admins” section opens and all my groups I created allow me to open and view my users and does not error out on me.

The output of your Nextcloud log in Admin > Logging:

[no app in context] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(64)

GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00

[user_ldap] Warning: provided name template for username does not contain any allowed characters

GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00

[PHP] Error: Trying to access array offset on value of type bool at /var/www/nextcloud/apps/user_ldap/lib/Access.php#563

GET /ocs/v2.php/cloud/users/details?offset=0&limit=25&search=
from 82.49.208.175 by ACX at 2022-02-07T12:04:47+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'passwordsalt' => 'XXXXXXXXX',
  'secret' => 'XXXXXXXXX',
  'trusted_domains' =>
  array (
    0 => 'localhost',
    1 => 'XXXXXXXXX',
    2 => 'XXXXXXXXX',
  ),
  'defaultapp' => 'apporder',
  'default_phone_region' => 'us',
  'datadirectory' => '/mnt/ncdata',
  'dbtype' => 'pgsql',
  'version' => '22.2.0.2',
  'overwrite.cli.url' => 'http://localhost/',
  'dbname' => XXXXXX_db',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'ncadmin',
  'dbpassword' => 'XXXXXXXXXXXXX',
  'installed' => true,
  'instanceid' => 'oc2ks27wdjhp',
  'upgrade.disable-web' => true,
  'log_type' => 'file',
  'logfile' => '/var/log/nextcloud/nextcloud.log',
  'loglevel' => '2',
  'log.condition' =>
  array (
    'apps' =>
    array (
      0 => 'admin_audit',
    ),
  ),
  'mail_smtpmode' => 'smtp',
  'remember_login_cookie_lifetime' => '1800',
  'log_rotate_size' => '10485760',
  'trashbin_retention_obligation' => 'auto, 60',
  'versions_retention_obligation' => 'auto, 180',
  'activity_expire_days' => '120',
  'simpleSignUpLink.shown' => false,
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'filelocking.enabled' => true,
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => '/var/run/redis/redis-server.sock',
    'port' => 0,
    'timeout' => 0.5,
    'dbindex' => 0,
    'password' => 'XXXXXXXXXXXXX',
  ),
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
  'mail_smtpsecure' => 'tls',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'it',
  'mail_domain' => 'XXXXXXXX',
  'mail_smtpauth' => 1,
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtphost' => 'XXXXXXXXXXX',
  'mail_smtpport' => '465',
  'mail_smtpname' => 'XXXXXXXXXX',
  'mail_smtppassword' => 'XXXXXXXXX',
  'logtimezone' => 'Etc/UTC',
  'htaccess.RewriteBase' => '/',
  'maintenance' => false,
  'templatedirectory' => NULL,
  'twofactor_enforced' => 'false',
  'twofactor_enforced_groups' =>
  array (
  ),
  'twofactor_enforced_excluded_groups' =>
  array (
  ),
);

The output of your Apache/nginx/system log in /var/log/____:

Nothing in my daily error log