Unable to list client's databases in Plesk: TypeError: Cannot read properties of undefined (reading 'searchFilters')

Symptoms

• Server has a large amount of Databases
• After upgrading to Plesk Obsidian 18.0.69, accessing Domains > example.com > Databases results in the following error message:

  CONFIG_TEXT: TypeError: Cannot read properties of undefined (reading 'searchFilters')
  at I (https://one.example.com:8443/cp/javascript/views/smb/database/list.js?025074d95bc7de355bf6:7:916)
  at ml (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:60258)
  at ki (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:119227)
  at xc (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:108475)
  at vc (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:108403)
  at gc (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:108266)
  at ic (https://one.example.comm:8443/ui-library/plesk-ui-library.min.js?1742461004:35:105428)
  at Vs (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:46632)
  at nc (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:102558)
  at Xl (https://one.example.com:8443/ui-library/plesk-ui-library.min.js?1742461004:35:65575)
  at https://one.example.com:8443/cp/javascript/vendors.js?1744286852:20:5688
  at https://one.example.com:8443/cp/javascript/vendors.js?1744286852:20:4766
  at https://one.example.com:8443/cp/javascript/vendors.js?1744286852:20:5681
  at https://one.example.com:8443/cp/javascript/vendors.js?1744286852:42:19159
  at Array.forEach (<anonymous>)
  at ne (https://one.example.com:8443/cp/javascript/vendors.js?1744286852:42:19147)
  at ie (https://one.example.com:8443/cp/javascript/vendors.js?1744286852:42:20402)
  at ae (https://one.example.com:8443/cp/javascript/vendors.js?1744286852:42:25703)
  at async Object.t [as navigate] (https://one.example.com:8443/cp/javascript/vendors.js?1744286852:42:33476

Cause

The issue is caused by the pre-selected "Classic view" on the databases page, which is also default for a large number of databases.

This has been identified as bug #PPPM-14921 which will be fixed in future Plesk updates.

Once the update is released you may find the bug ID in the Plesk Obsidian Change Log.

Resolution

As a workaround, one can switch to the Active view of databases via the following steps:

1. Connect to the server via SSH

2. Back up the psa database:

# plesk db dump > /root/psa_$(date +%Y%m%d).sql

3. Find the ID of the affected customer (replace <userLogin> with the actual login name of the user experiencing the issue. For the admin user, use 'admin' as the login):

# plesk db "select id from clients where login = '<userLogin>';"
+----+
| id |
+----+
| 2  |
+----+

 4. Remove the following string from cl_param table, indicating the ID of the customer (value of the cl_id):

# plesk db "DELETE FROM cl_param WHERE cl_id=2 AND param='Smb_View_List_Databases-listType' AND val='classic';"