Users (including admin users) cannot view their token. Authentication seems to fail (message: You must authenticate successfully to access your token)
Nexus PRO 3.69.0-02
The nexus.log reports this error:
024-06-19 16:41:04,215+0200 WARN [qtp1077871857-26321] gturek org.sonatype.nexus.siesta.internal.UnexpectedExceptionMapper - (ID cec5c9b8-5410-4f56-a4a6-5095cbd4d421) Response: [500] 'ERROR: (ID cec5c9b8-5410-4f56-a4a6-5095cbd4d421) org.sonatype.nexus.datastore.api.DataAccessException:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
### The error may exist in org/sonatype/nexus/internal/security/apikey/ApiKeyDAO.xml
### The error may involve org.sonatype.nexus.internal.security.apikey.ApiKeyDAO.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO api_key (primary_principal, domain, token, principals , created ) VALUES (?, ?, ?, ? , ? ) ON CONFLICT (primary_principal, domain, principals) DO UPDATE SET token = ?, principals = ?, created = ? ;
### Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification'; mapped from: org.sonatype.nexus.datastore.api.DataAccessException:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
### The error may exist in org/sonatype/nexus/internal/security/apikey/ApiKeyDAO.xml
### The error may involve org.sonatype.nexus.internal.security.apikey.ApiKeyDAO.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO api_key (primary_principal, domain, token, principals , created ) VALUES (?, ?, ?, ? , ? ) ON CONFLICT (primary_principal, domain, principals) DO UPDATE SET token = ?, principals = ?, created = ? ;
### Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
2024-06-19 16:41:04,214+0200 WARN [qtp1077871857-26321] gturek org.sonatype.nexus.siesta.internal.UnexpectedExceptionMapper - (ID cec5c9b8-5410-4f56-a4a6-5095cbd4d421) Unexpected exception: org.sonatype.nexus.datastore.api.DataAccessException:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
### The error may exist in org/sonatype/nexus/internal/security/apikey/ApiKeyDAO.xml
### The error may involve org.sonatype.nexus.internal.security.apikey.ApiKeyDAO.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO api_key (primary_principal, domain, token, principals , created ) VALUES (?, ?, ?, ? , ? ) ON CONFLICT (primary_principal, domain, principals) DO UPDATE SET token = ?, principals = ?, created = ? ;
### Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
org.sonatype.nexus.datastore.api.DataAccessException:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
### The error may exist in org/sonatype/nexus/internal/security/apikey/ApiKeyDAO.xml
### The error may involve org.sonatype.nexus.internal.security.apikey.ApiKeyDAO.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO api_key (primary_principal, domain, token, principals , created ) VALUES (?, ?, ?, ? , ? ) ON CONFLICT (primary_principal, domain, principals) DO UPDATE SET token = ?, principals = ?, created = ? ;
#