Back to top

Postgres SQL failure when registering user accounts in bulk

Last updated July 26th, 2023


  • Knox Manage


When adding multiple users to a tenant with the Bulk Add Users registration method, you may encounter an error where the registration fails. In the User Upload Result dialog, the following error is displayed:

Error: org.postgresql.util.PSQLException


The Bulk Add Users dialog accepts an XLSX file containing unique user IDs to register user accounts. If there are multiple entries with the same User ID field in the spreadsheet, some rows may not be read successfully, resulting in the error.


To resolve the issue, you should remove any rows with duplicate IDs from the spreadsheet and re-upload the spreadsheet to the Bulk Add Users dialog.

A fix for this issue is planned in the 23.06 release.

Additional information

Register user accounts in bulk

Back to KBAs

Is this page helpful?