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:
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 informationBack to KBAs
Is this page helpful?
Thank you for your feedback!