| Description | This article describes the issue of failing to import a CSV file into User Groups in FortiAuthenticator v8.0.0 and 8.0.1. 'Failure occurred while importing users' when importing a user group CSV file into FortiAuthenticator v8.0.0 and 8.0.1. This issue does not happen in earlier versions of FortiAuthenticator, such as v6.6.6, v6.6.7 and etc. |
| Solution | Screenshot of the error message when attempting to import a CSV into the User Groups under Authentication -> User Management -> User Groups: 
Error seen in the log messages under Logging -> Log Access -> Logs: Error: psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:90:
ERROR: null value in column "ldap_group" of relation "fac_auth_facgroup" violates not-null constraint DETAIL: Failing row contains (24, EngZTNA, 0, 0, null, , null, t, null, null, null, null, f, f, null, null, null). psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:130:
ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:165:
ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:168:
ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:201:
ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:205:
ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/var/www/fac/fac/apps/fac_auth/sql/facgroup_import_qry.sql:217:
ERROR: current transaction is aborted, commands ignored until end of transaction block This is known issue #1227700, which will be resolved in FortiAuthenticator 8.0.2. |
