Postgres SQL failure when registering user accounts in bulk

Environment

• Knox Manage

Overview

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

Cause

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.

Workaround

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